The proccesses finished berfore they become completed
- by Meysam Javadi
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?