private void btnUpdate_Click(object sender, RoutedEventArgs e)
comocoLTSDataContext dc = new comocoLTSDataContext();
DCdate dateRow = dataGrid1.SelectedValue as DCdate;
DCdate date = (from d in dc.DCdates
where d.GKId == dateRow.GKId & d.DId==dateRow.DId & d.DCcontainer.ContainerNo==txtContNo.Text
date.Date1 = dateRow.Date1;
date.Temp00 = dateRow.Temp00;
date.Temp06 = dateRow.Temp06;
date.Temp12 = dateRow.Temp12;
date.Temp18 = dateRow.Temp18;
date.DLane = dateRow.DLane;
date.DVentilation = dateRow.DVentilation;
date.DRemarks = dateRow.DRemarks;
MessageBox.Show("Row Updated Successfully");
catch (Exception ex)
this is how I tried to update my db using datagridview. code seems to be ok. also giving the "Row updated" message. but when call LoadDates() Db has not been updated.
please help me soon...
why can't anyone give me a reason.....
Edited 17-Oct-12 4:37am
I found a good solution from this
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)