Im trying to update a datagrid and a text box value in access database.
both shld be saved in the same row simultaneously.,unfortunately its not happening.
they were gettign saved in a different rows.
conn.Open() sqlQRY = "Insert Into tblPlot(SurveyNo)" sqlQRY = sqlQRY & "Values" sqlQRY = sqlQRY & "('" & Me.Text.ToString & "')" With cmd .CommandText = sqlQRY .Connection = conn .ExecuteNonQuery() End With da.Update(ds, "tblPlot") conn.Close() 'da.Update(ds, "tblPlot") DataGridView1.[ReadOnly] = False save_btn.Enabled = True MsgBox("Data Saved:" & Me.Text.ToString)