How to Save changes in DataGridView into Database programmatically without using DataGridView Wizard

[vbDiggerz]

How to Save record or row changes in DataGridView directly into Database programmatically without using DataGridView Wizard or using an button events like btnSave_Click??? Anybody please help... I'm having difficulty with this problem... Here's my code how to fill records into DataGridview this works ok but i dont know how to save or update the new changes of the record inside this DataGridView Directly into database anyone can help me please??? please note: im using an MS ACCESS as database ************************ Private Sub LoadRecord(ByVal strSQL As String) Try 'open the connection oleConnection.ConnectionString = dbConnectionString oleConnection.Open() oleDataAdapter = New OleDbDataAdapter(strSQL, oleConnection) dbDataTable = New DataTable() dbBindingSource = New BindingSource oleDataAdapter.Fill(dbDataTable) dbBindingSource.DataSource = dbDataTable 'bind datagrid to BindingSource dgDailyTimeRecord.DataSource = dbBindingSource Catch ex As Exception MsgBox(ex.ToString()) Finally oleConnection.Close() End Try End Sub ****************************

[rohitsrivastava]

see this only u want to save the data grid this is the code objsqlcon=new sqlconnection("user id=sa;password=;initial catalog=databasename;data source=servername") objsqlcon.open dim i as integer for i=0 to datagridview1.rowcount-1 strinsert="insert into tablename(fieldname1,fieldname2) values('" & datgridview1.cell(columnname1).rows(i)(0).value & "',"' & datgridview1.cell(columnname1).rows(i)(0).value & "')" objsqlcmd=new sqlcommand(strinsert,objsqlcon) objsqlcmd.executenonquery() next messagebox.show("Record Successfully Saved ")

[vbDiggerz]

thanks for the reply... i appreciate that... your connection is SQLConnection Type so i've a little convertion as OleDBConnection type because im using an .MDB database.. ******************** Dim strinsert As String oleConnection.ConnectionString = dbConnectionString oleConnection.Open() Dim i As Integer For i = 0 To dgDailyTimeRecord.RowCount - 1 strinsert = "insert into tablename(fieldname1,fieldname2) values('" & dgvDailyTimeRecord.rows(i).cell(0).value & "', '" & dgvDailyTimeRecord.rows(i).cell(0).value & "')" oleCommand = New OleDbCommand(strinsert, oleConnection) oleCommand.ExecuteNonQuery() Next MessageBox.Show("Record Successfully Saved ") ******************** Thank you so much...