One very common use of the Data Grid View control is binding to a table in a database.
Unbound mode is suitable for displaying relatively small amounts of data that you manage programmatically.
Add(dt) da = New Ole Db Data Adapter("Select * from table Student Details", con) da. Unbound mode is suitable for displaying relatively small amounts of data that you manage programmatically. Click Dim connection String As String = "Data Source=.; Initial Catalog=pubs; Integrated Security=True" Dim sql As String = "SELECT * FROM Stores" Dim connection As New Sql Connection(connection String) connection. Virtual mode gives you a higher degree of control by allowing you to wait until a cell is actually being displayed to provide the value it will contain. Sql Client Public Class Form1 Dim s Command As Sql Command Dim s Adapter As Sql Data Adapter Dim s Builder As Sql Command Builder Dim s Ds As Data Set Dim s Table As Data Table Private Sub load_btn_Click(By Val sender As System. Open() s Command = New Sql Command(sql, connection) s Adapter = New Sql Data Adapter(s Command) s Builder = New Sql Command Builder(s Adapter) s Ds = New Data Set() s Adapter. All your insertions, updates, and deletions will be effected by the single button.You are change the properties of the projected copy of the entity, while entity itself stays unchanged. Add(dt) da = New Ole Db Data Adapter("Select * from table Student Details", con) Dim cb = new Ole Db Command Builder(da) cb.