In the following code, I cannot give an insertcommand in the adaptor. This is because, I insert rows to the dataset. And so, I cannot set a commandTimeout in the insertcommand of the data adaptor. However, how can I set a commandtimeout while updating the table?

foreach (DataRow rw in DS_Source.Tables[0].Rows)

rw3 = DS1.Tables[0].NewRow();
rw3["facility_2"] = rw["facility"];

myChangedDataset = DS_Target.GetChanges();

adptr_DataAdapter1.InsertCommand.CommandTimeout = 500;

int modifiedRows2 = adptr_DataAdapter1.Update(myChangedDataset, str_table_name1);