Time out

• sunil446 69306

  SSC Rookie

  Points: 29

  More actions

  November 2, 2012 at 5:23 am

  #269658

  Hi,

  I'm doing bulk insert which is taking 36sec approx. can anyone tell me how to execute using asp.net c#. normal executenonquery is throwing timeout expection

  Thanks in Advance

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  November 2, 2012 at 5:27 am

  #1555401

  Change SqlCommand.CommandTimeout to higher number. Default is 30 sec...

  _____________________________________________
  "The only true wisdom is in knowing you know nothing"
  "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
  (So many miracle inventions provided by MS to us...)

  How to post your question to get the best and quick help[/url]

• sunil446 69306

  SSC Rookie

  Points: 29

  More actions

  November 2, 2012 at 5:46 am

  #1555410

  I set it to 0 that means infinity right? if i'm not wrong

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  November 2, 2012 at 9:52 am

  #1555565

  0 should be infinity.

  http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout%28v=VS.71%29.aspx

• sunil446 69306

  SSC Rookie

  Points: 29

  More actions

  November 7, 2012 at 4:22 am

  #1556712

  Thanks all it worked for me..