SQLCommand的用法public DataTable newTable(string procName,CommandType ct){ ODCmd = new SqlCommand(procName,ODCon);ODCmd.CommandType =CommandType.StoredProcedure;using (ODSdr = ODCmd.ExecuteReader(CommandBehavior.CloseConnection)){dt.Load(ODSdr);}r
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/21 12:24:31
![SQLCommand的用法public DataTable newTable(string procName,CommandType ct){ ODCmd = new SqlCommand(procName,ODCon);ODCmd.CommandType =CommandType.StoredProcedure;using (ODSdr = ODCmd.ExecuteReader(CommandBehavior.CloseConnection)){dt.Load(ODSdr);}r](/uploads/image/z/14600164-4-4.jpg?t=SQLCommand%E7%9A%84%E7%94%A8%E6%B3%95public+DataTable+newTable%28string+procName%2CCommandType+ct%29%7B+ODCmd+%3D+new+SqlCommand%28procName%2CODCon%29%3BODCmd.CommandType+%3DCommandType.StoredProcedure%3Busing+%28ODSdr+%3D+ODCmd.ExecuteReader%28CommandBehavior.CloseConnection%29%29%7Bdt.Load%28ODSdr%29%3B%7Dr)
SQLCommand的用法public DataTable newTable(string procName,CommandType ct){ ODCmd = new SqlCommand(procName,ODCon);ODCmd.CommandType =CommandType.StoredProcedure;using (ODSdr = ODCmd.ExecuteReader(CommandBehavior.CloseConnection)){dt.Load(ODSdr);}r
SQLCommand的用法
public DataTable newTable(string procName,CommandType ct)
{
ODCmd = new SqlCommand(procName,ODCon);
ODCmd.CommandType =CommandType.StoredProcedure;
using (ODSdr = ODCmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(ODSdr);
}
return dt;
}
其中procname="procSelectRecommendNews"
提示找不到存储过程该怎么解决
SQLCommand的用法public DataTable newTable(string procName,CommandType ct){ ODCmd = new SqlCommand(procName,ODCon);ODCmd.CommandType =CommandType.StoredProcedure;using (ODSdr = ODCmd.ExecuteReader(CommandBehavior.CloseConnection)){dt.Load(ODSdr);}r
SqlDataReader sdr = cmd.ExecuteReader();--查询,很明显可以看到 返回的是 SqlDataReader对象 ,然后在使用SqlDataReader的 sdr.Read()方法读出数据