C#中SQL語句執(zhí)行時間過長服務(wù)器未響應(yīng)問題的解決

解決方法如下：
    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;