The proccesses finished berfore they become completed

Posted by Meysam Javadi on Stack Overflow See other posts from Stack Overflow or by Meysam Javadi
Published on 2010-05-12T08:18:43Z Indexed on 2010/05/12 8:24 UTC
Read the original article Hit count: 202

Filed under:
|

suppose this scenario:

i have a XML file that is uploaded, i read it to a DataTable with ReadXml method. now i want to insert this DataTable to database. i create a t-sql command to insert database(with StoredProcedure) for example

var command =string.Format("exec SyncToDB '{0}','{1}", odatarow.ItemArray.GetValue(0), odatarow..ItemArray.GetValue(1));

Hitherto everything is ok but when i run this code ,all of rows not affected to DB, i think that a timeout occur the code execution.

*note:*the number of rows is numerous.(25000).

how to solve this?

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about c#