public static SqlDataReader ExecuteReader(string connString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParms) { SqlCommand cmd = new SqlCommand(); SqlConnection conn = new SqlConnection(connString); try { PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); cmd.Parameters.Clear(); return rdr;
} catch (Exception ex) { conn.Close(); throw ex; } }
怎樣修改好呢,現(xiàn)在發(fā)現(xiàn)經(jīng)常有超時(shí)的現(xiàn)象,數(shù)據(jù)庫(kù)連接池已滿的現(xiàn)象
今天在新公司發(fā)現(xiàn)這樣的代碼,是不是有錯(cuò)誤
幕布斯7119047
2018-12-06 17:02:20