Welcome to Dream.In.Code
Become a VB.NET Expert!

Join 149,460 VB.NET Programmers for FREE! Get instant access to thousands of VB.NET experts, tutorials, code snippets, and more! There are 2,116 people online right now. Registration is fast and FREE... Join Now!




ms access database connectivity with vb.net

 
Reply to this topicStart new topic

ms access database connectivity with vb.net

ishaa
9 Feb, 2008 - 06:45 AM
Post #1

New D.I.C Head
*

Joined: 9 Feb, 2008
Posts: 1

hi
send me code for ms access database connectivity using oledb and adodb using vb.net
User is offlineProfile CardPM
+Quote Post

PsychoCoder
RE: Ms Access Database Connectivity With Vb.net
9 Feb, 2008 - 06:55 AM
Post #2

using DIC.Core;
Group Icon

Joined: 26 Jul, 2007
Posts: 9,477



Thanked: 161 times
Dream Kudos: 9025
Expert In: VB, VB.Net, C#, SQL, ASP, ASP.Net, Web Development, HTML, CSS, Win32 API, Javascript, mySQL, J#, Boo.Net

My Contributions
Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Post your code like this: code.gif


Given that, if you had used the search feature you would have found this tutorial on OleDb Basics in VB.Net which should answer your questions. Also, ADODB is no longer used in VB.Net, well its available but I wouldnt use VB6 libraries in VB.Net so stick with OleDb smile.gif
User is online!Profile CardPM
+Quote Post

akori.anand@rediffmail.com
RE: Ms Access Database Connectivity With Vb.net
1 Nov, 2008 - 09:05 AM
Post #3

New D.I.C Head
*

Joined: 20 Aug, 2007
Posts: 2


My Contributions
QUOTE(ishaa @ 9 Feb, 2008 - 07:45 AM) *

hi
send me code for ms access database connectivity using oledb and adodb using vb.net

hi
i am using ms access
i need some help
User is offlineProfile CardPM
+Quote Post

akori.anand@rediffmail.com
RE: Ms Access Database Connectivity With Vb.net
1 Nov, 2008 - 09:15 AM
Post #4

New D.I.C Head
*

Joined: 20 Aug, 2007
Posts: 2


My Contributions
CODE
Imports System.Data.OleDb
Public Class DatabaseConnection
    Private CommonConnection As OleDbConnection
    Private CommaonDataAdapter As OleDbDataAdapter
    Private CommonCommand As OleDbCommand
    Private CommonDataSet As DataSet

    Public Sub New()
        CommonConnection = New OleDbConnection("provider=MicroSoft.jet.OLEDDB.4.0;" & "Data Source=..\db1.mdb;" & "persist Security Info=false")
        CommonCommand = New OleDbCommand
        CommonCommand.Connection = CommonConnection
        CommonDataSet = New DataSet
    End Sub
    Protected ReadOnly Property p_CommonConnection() As OleDbConnection
        Get
            Return CommonConnection
        End Get
    End Property
    Protected Property p_CommonDataAdapter() As OleDbDataAdapter
        Get
            Return CommaonDataAdapter
        End Get
        Set(ByVal Value As OleDbDataAdapter)
            CommaonDataAdapter = Value
        End Set
    End Property
    Protected ReadOnly Property p_CommonCommand() As OleDbCommand
        Get
            Return CommonCommand
        End Get
    End Property
    Protected Property p_CommonDataSet() As DataSet
        Get
            Return CommonDataSet
        End Get
        Set(ByVal Value As DataSet)
            CommonDataSet = Value
        End Set
    End Property

End Class

User is offlineProfile CardPM
+Quote Post

PsychoCoder
RE: Ms Access Database Connectivity With Vb.net
1 Nov, 2008 - 09:22 AM
Post #5

using DIC.Core;
Group Icon

Joined: 26 Jul, 2007
Posts: 9,477



Thanked: 161 times
Dream Kudos: 9025
Expert In: VB, VB.Net, C#, SQL, ASP, ASP.Net, Web Development, HTML, CSS, Win32 API, Javascript, mySQL, J#, Boo.Net

My Contributions
@akori.anand@rediffmail.com: Nice way to hijack someone's thread. Next time open a thread for your question, it's bad netiquette to hijack a thread.

Also, is there a question about your code, does it not work, do you get an error? These are things we need in order to help smile.gif

Also, here is a tutorial on OleDb Basics in VB.NET that you can read
User is online!Profile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/7/09 01:58PM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live VB.NET Help!

VB.NET Tutorials

Reference Sheets

VB.NET Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month