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.
The following C# source code illustrate how to connect a Data Grid View to a database and new/update or delete the database values from Data Grid View.
But in many cases this only provides a modest improvement as each UPDATE operation still requires a round-trip communication with the database server.
Close() con = Nothing End Sub ' Save data back into database Private Sub Button1_Click(By Val sender As System. I copied this code into a project, ran it and the "Data Grid View1. The question marks are just placeholders for the data that will be used to update the database. I used to rock and roll every night and party every day. Now I'm lucky if I can find 30 minutes a week in which to get funky. Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!
This line in Form_Load should be throwing an object reference error: Data Grid View1. Fill(my Data Set, "Table1") Then you try to access it with "My Table". Then in the button click sub, make that reference the same.
I have never used the Ole Db Data Adapter & Ole Db Command and am not sure what I am doing.
Keep getting this err msg at the high-lighted code, "Object reference not set to an instance of an object".