saving data from datagridview when row is filled

Question

Hi I have DataGridView control (with binding data).When user add new row and fill it their is button that allows to save data from row to database. I do not want my program to work in that way. I want new record to be saved after user fill current row. thanks

Crish · Answer

Hi you can refer following code i think it will help you. Private Sub bt_Click(ByVal sender As System.Object ByVal e As System.EventArgs) Handles btn.Click 'Load DataGridView mAdapter.SelectCommand = _ New OleDb.OleDbCommand(SQL1 New OleDb.OleDbConnection(connectionString)) 'Auto-Generate INSERT UPDATE and DELETE sql commands Dim cb As New OleDb.OleDbCommandBuilder(mAdapter) mAdapter.AcceptChangesDuringFill = False 'Fill table Dim table As New DataTable() mAdapter.Fill(table) 'Set as DataSource for grid Me.dgResults.DataSource = table Me.dgResults.AutoResizeColumns( _ DataGridViewAutoSizeColumnsMode.AllCells) End Sub

Dozd · Answer

Thanks Suthish I have read that article before I post my problem. In mean time I have think a lot so I find solution. I used KeyUp event from datagridview and UserAddRows. when user click Eneter or Tab key in calls method for data saving from last row. If somebody wants/needs I can post code. This solution is working but I am not completly satisfate becouse in UI i have code like if statements and try/ catch  which I think is not good from encapsulation rule point of view.

Suthish Nair · Answer

refer might helps