Edit Saved items from the Database.

Here is the code I have tried and does not work .If you could point me in the right direction that will be appreciated. 


private void UpdateDatabase_Clock (object sender, EventArgs e)
{

DialogResults update;

update = MessageBox.Show ("Are you sure you want to update this record" "Delete Record" , MessageBoxButtons.OKCancel);

if (update == System.Windows.Forms.DialogResults.OK)


{

Try

{ tbl_AppointmentsTableAdapter.update(this.datasetnumber1.TBL_Appointments);
tbl_EngineerTableAdapter.Update (this.datasetNumber1.TBL_Engineers);

_selectedAppointmentRow = null;
}


catch (Exception ex)
{
MessageBox.Show("Unable to delete the record due to the following error; " + ex.Message);


}
}
}

R u trying in Windows or Web Application ?

Paste the code that you have tried.


Please have a visit on this link

http://www.dotnettutorials.com/tutorials/database/linq-to-sql-add-edit-delete-cs/


https://msdn.microsoft.com/en-us/library/bb399339%28v=vs.110%29.aspx


https://msdn.microsoft.com/en-us/library/vstudio/bb386870%28v=vs.100%29.aspx


Thanks

Just use the update command and update the column value

for all  - without any condition
for single row- use where condition on the basis of primary key column

Note:- Don't try to update the value of primary key column


update tablename set FirstName = Sam where roll_no='101'