5 Replies - 66096 Views - Last Post: 17 September 2009 - 11:05 PM Rate Topic: -----

#1 ishaa  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 09-February 08

ms access database connectivity with vb.net

Post icon  Posted 09 February 2008 - 07:45 AM

hi
send me code for ms access database connectivity using oledb and adodb using vb.net
Is This A Good Question/Topic? 0
  • +

Replies To: ms access database connectivity with vb.net

#2 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1642
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: ms access database connectivity with vb.net

Posted 09 February 2008 - 07:55 AM

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:


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 :)
Was This Post Helpful? 0
  • +
  • -

#3 akori.anand@rediffmail.com  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 2
  • Joined: 20-August 07

Re: ms access database connectivity with vb.net

Posted 01 November 2008 - 10:05 AM

View Postishaa, 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
Was This Post Helpful? 1
  • +
  • -

#4 akori.anand@rediffmail.com  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 2
  • Joined: 20-August 07

Re: ms access database connectivity with vb.net

Posted 01 November 2008 - 10:15 AM

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


Was This Post Helpful? 0
  • +
  • -

#5 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1642
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: ms access database connectivity with vb.net

Posted 01 November 2008 - 10:22 AM

@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
Was This Post Helpful? 0
  • +
  • -

#6 chandraker  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 17-September 09

Re: ms access database connectivity with vb.net

Posted 17 September 2009 - 11:05 PM

View Postishaa, on 9 Feb, 2008 - 06:45 AM, said:

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

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1