When the validation fails, the editor is closed, but the user cannot change the current row in the grid until a valid cell value is entered.
It replaces the Data Grid control with an easy to use and extremely customizable grid that supports many of the features that are needed for our customers.
I am creating one application visual basic and sqlce I have two forms name Form1 and Form2. Execute Non Query() Msg Box("Data added successfully.", Msg Box Style. Some one suggested me to fill the datagridview at run time by using OLe DB command.
I used Form1 to add data to database using OLe Db command and used Form2 to show data in datagridview by using dataset I used following code: FFORM1 CODE is as following Private Sub Add_data() Try Dim DBConn As Ole Db Connection Dim DBInsert As New Ole Db Command DBConn = New Ole Db Connection(Myconnection_String) DBInsert. Then I created Form3 to fill the datagridview2 by using OLedb command and datareader and found that Form3 shows the recently(added by Form1 at run time) added data.
Use of Designer dataset is required for me , because I am using the similar dataset to create report.
How my Form2 dataset,datagridview can show the latest data from the database Private Sub Form2_Load(By Val sender As System.
Refresh Report(); to update datagridvies at run time 'UI is the form name 'modify ur datasetname and table adaptor names run UI.