C#中SQL语句执行时间过长服务器未响应问题的解决
解决方法如下:
sqlcommand sold _ cmd = new sqlcommand(SQL _ sold,conn);
sold_cmd。CommandTimeout = 300
SqlCommand detail _ cmd = new SqlCommand(SQL _ detail,conn);
detail_cmd。CommandTimeout = 300
sqlDA_sold。SelectCommand = sold _ cmd
sqlDA_detail。SelectCommand = detail _ cmd
0条评论