[ishaa]

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

[PsychoCoder]

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:


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

[akori.anand@rediffmail.com]

ishaa, on 9 Feb, 2008 - 07:45 AM, said:

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

[akori.anand@rediffmail.com]

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

[PsychoCoder]

@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

Also, here is a tutorial on OleDb Basics in VB.NET that you can read

[chandraker]

ishaa, on 9 Feb, 2008 - 06:45 AM, said:

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