Working with ADO.NET Database Components in VS.NET
Working with ADO.NET Database Components in VS.NET and WinForms is so fun. You write few lines of code and these controls take care of rest for you. In this article, I'm going to show you how to use these database Components in your .NET WinForms applications using VB.NET.
The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: 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
It is the same account you read, post and publish with — and you will come straight back to this page.
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