Commnad timeout for SqlDataAdapter?

Question

hi all Is there a command timeout for SqlDataAdapter? There is one for Sqd command which is cmd.CommandTimeOut = 600 but I need one for SqlDataAdapter too. Is it SqlDataAdapter.ContinueUpdateOnError = true ?

Andrzej Wegierski · Answer

See command builders (SqlCommandBuilder etc.)

sunspotzzz · Answer

Hi thanks a lot for your reply I need to execute a string which is a qery code and put it inside a datatable. _________________________________________________________________________ SqlDataAdapter daGetOriginalQuery = new SqlDataAdapter (Querystring conn); daGetOriginalQuery.Fill(dsQuery QueryResults); _________________________________________________________________________ How do I convert the above to Insert Command?

miker · Answer

You have to look inside the objects you are working with. SqlDataAdapter has SelectCommand/UpdateCommand/InsertCommand properties. Use them to set CommandTimeout.