on save from dataset (parent with child )

Question

hoshiar ali · Answer

when i save it this error will appear

hoshiar ali · Answer

THIS IS MY BACKUP FILE

Muralidharan Deenathayalan · Answer

If you have proper primary - foreign key relationship in your dataset then you should get the same error in the dataset itself. Now, use sql profiler and see what are informations are passed to the sql server during update.

hoshiar ali · Answer

Yes i have Pr Key & For Key and I selected when i created dataset . The problem is why if i not putting any thing in cell leave or cell enter it is ok working !!!!

Iftikar Hussain · Answer

please check while binding the data to ballonPressDataSet, weather you have selected primary key or not Regards, Iftikar

Muralidharan Deenathayalan · Answer

Do you have primary key & foreign key constraint / relationship in your dataset / datasource?

hoshiar ali · Answer

this is the whole code

hoshiar ali · Answer

this is the whole code

Iftikar Hussain · Answer

can you share the complete code? Regards, Iftikar

hoshiar ali · Answer

Mr. Iftikar when i put this function to the cellLeave Function it make this error and this is the function bellow : private void tbl_main_subDataGridView_CellLeave(object sender, DataGridViewCellEventArgs e) { try{ // decimal sum = 0.00m; decimal s, s1,s13=0.0m, pr = 0.0m , to =0.0m; int qt = 0; for (int i = 0; i { if (tbl_main_subDataGridView.CurrentRow.Cells["hight"].Value != DBNull.Value) s = Convert.ToDecimal(tbl_main_subDataGridView.CurrentRow.Cells["hight"].Value); else s = 0.00m; if (tbl_main_subDataGridView.CurrentRow.Cells["width"].Value != DBNull.Value) s1 = Convert.ToDecimal(tbl_main_subDataGridView.CurrentRow.Cells["width"].Value); else s1 = 0.00m; if (tbl_main_subDataGridView.CurrentRow.Cells["qty"].Value != DBNull.Value) qt = Convert.ToInt32(tbl_main_subDataGridView.CurrentRow.Cells["qty"].Value); else qt = 0; if (tbl_main_subDataGridView.CurrentRow.Cells["price"].Value != DBNull.Value) pr = Convert.ToDecimal(tbl_main_subDataGridView.CurrentRow.Cells["price"].Value); else pr = 0.00m; s13 = (((s1 * s)/1000000)*qt); tbl_main_subDataGridView.CurrentRow.Cells["m2"].Value = s13; to = pr * s13; qt = 0; if (tbl_main_subDataGridView.CurrentRow.Cells["tatal"].Value != DBNull.Value) pr = Convert.ToDecimal(tbl_main_subDataGridView.CurrentRow.Cells["tatal"].Value); else to = 0.0m; tbl_main_subDataGridView.CurrentRow.Cells["tatal"].Value = to; } } catch(Exception ex ) { ex.ToString(); } }

Iftikar Hussain · Answer

Hi, Please check your ballonPressDataSet weather it is containing right parent id or not? Regards, Iftikar

on save from dataset (parent with child )

Answers (11)