adapter.Update method

[santhoshcz]

Hi i am using a dataset to update a table in database.

I am using a loop to insert multiple records in the dataset.The dataset gets updated perfectly in the dataset.But when i call the adapter.update method
i.e. adap.Update(ds,"table")

only the last record gets added n times.... I don know wats happening there..

Can anyone help me???

Thanks
Santhosh.

This is my code:
FOR LOOP{
adap.InsertCommand = new SqlCommand("INSERT INTO SAN_PB_BAL_GRP VALUES('" + bal_name + "','" + eq_name + "')", conn);

DataRow newrow = ds.Tables["temp_table"].NewRow();
newrow[0] = bal_name;
newrow[1] = eq_name;
ds.Tables["temp_table"].Rows.Add(newrow);
}//END OF FOR LOOP

adap.Update(ds, "temp_table");

[jabeerbe]

Hi i am using a dataset to update a table in database.

I am using a loop to insert multiple records in the dataset.The dataset gets updated perfectly in the dataset.But when i call the adapter.update method
i.e. adap.Update(ds,"table")

only the last record gets added n times.... I don know wats happening there..

Can anyone help me???

Thanks
Santhosh.

This is my code:
FOR LOOP{
adap.InsertCommand = new SqlCommand("INSERT INTO SAN_PB_BAL_GRP VALUES('" + bal_name + "','" + eq_name + "')", conn);

DataRow newrow = ds.Tables["temp_table"].NewRow();
newrow[0] = bal_name;
newrow[1] = eq_name;
ds.Tables["temp_table"].Rows.Add(newrow);
}//END OF FOR LOOP

adap.Update(ds, "temp_table");

Hi,

From my knowlegde, The problem will be with the variables.

bal_name

eq_name

... The value is not updating. Please check that.