on save from dataset (parent with child )

hoshiar ali

13y1.7kVisual Basic .NET

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

hoshiar ali13y ago

when i save it this error will appear
0
hoshiar ali13y ago
THIS IS MY BACKUP FILE
0
13y ago
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.
0
hoshiar ali13y ago
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 !!!!
0
Iftikar Hussain13y ago
please check while binding the data to ballonPressDataSet, weather you have selected primary key or not

Regards,
Iftikar
0
13y ago
Do you have primary key & foreign key constraint / relationship in your dataset / datasource?
0
hoshiar ali13y ago
this is the whole code
0
hoshiar ali13y ago
this is the whole code
0
Iftikar Hussain13y ago
can you share the complete code?

Regards,
Iftikar
0
hoshiar ali13y ago
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 < tbl_main_subDataGridView.Rows.Count; 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();

}



}
0
Iftikar Hussain13y ago
Hi,
Please check your ballonPressDataSet weather it is containing right parent id or not?

Regards,
Iftikar
0