Member Avatar for jun_1987
jun_1987 0 Newbie Poster

hi..i am newbie for vb.net.i jz wan to ask how to link microsoft access field with my text box.i jz wan to get the information from the table to my textbox.i already connect it to my form.
this is how i connect to form..
'TODO: This line of code loads data into the 'Db1DataSet.customerdetails' table. You can move, or remove it, as needed.
Me.CustomerdetailsTableAdapter.Fill(Me.Db1DataSet.customerdetails)
Dim ConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Jun Wong\Desktop\program\db1.mdb"
Dim SQLString As String = "SELECT * FROM customerdetails"
Dim OleDBConn1 As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(ConnString)
Dim DataSet1 As New DataSet()
Dim OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter(SQLString, OleDBConn1)
OleDBConn1.Open()
OleDbDataAdapter1.Fill(DataSet1, "customerdetails")
DataGridView1.DataSource = DataSet1.Tables("customerdetails")
DataGridView1.Visible = False


thanks ya..

  • 1 Contributor
  • 0 Replies
  • 70 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.