Question

ExecuteQuery方法没有采用2个参数的重载是什么意思?

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储名称</param>
/// <returns></returns>
public DataTable ExecuteQueryt(string sql,CommandType ct)
{
DataTable dt = new DataTable();
cmd = new SqlCommand(sql , GetConn());
cmd.CommandType = ct;
using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(sdr);
}
return dt;
}

//根据类别名称取出该类别下的所有选题
public DataTable SelectAllCourse()
{
return sqlhelper.ExecuteQuery("ProcCourseSelectAllCourse", CommandType.StoredProcedure);
}

Answer 1

public DataTable ExecuteQueryt(string sql,CommandType ct)

兄弟,你的函数多了个 t ........汗.......

return sqlhelper.ExecuteQueryt("ProcCourseSelectAllCourse", CommandType.StoredProcedure);