Working with ADO.NET Database Components in VS.NET
The text of this article is not in this database — only its details are. Read it on the old site: Working with ADO.NET Database Components in VS.NET
1 Comment
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment.
Roshan PereraPosted Oct 19, 2007, 7:11 AM
Dear Sir, I wrote codes correctly, but the error msg comming from the following line dataadep.Fill(ds, "Customers") Herewith my total codes set and please help me to go fowared. Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conStr As String = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=D:\Roshan\VBNet\Test.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1" Dim sqlstr As String = "Select * from Employees" Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection(conStr) conn.Open() Dim dataadep As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(sqlstr, conn) Dim ds As DataSet = New DataSet dataadep.Fill(ds, "Customers") DataGrid1.DataSource = ds.DefaultViewManager conn.Close() End Sub