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"];
}
DS_Target.Tables[0].Rows.Add(rw3);

myChangedDataset = DS_Target.GetChanges();

adptr_DataAdapter1.InsertCommand.CommandTimeout = 500;

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

DS_Target.AcceptChanges();