超时查询

这就是它的外观 SqlCommand.CommandTimeout

   SqlCommand cmd = new SqlCommand();
   cmd.CommandText = "SELECT blah FROM Categories ORDER BY CategoryID";
   cmd.CommandTimeout = 600;  // 10 minutes = 600 seconds
   // Caveat: it you need a timeout value of more than 30 - 60 seconds
   //         perhaps time to look at why it takes so long...

您可以设置 CommandTimout 性质 Command 反对10分钟。当命令超时时,SQL Server将注意到连接已断开并取消查询。