cmd.CommandText = "select shifu,UsrNm from EnterStateTable where EnterID in(" + enterID + ") ";
SqlDataReader ds = cmd.ExecuteReader();
ds.Read();
{
string shifu = Convert.ToString(ds["shifu"].ToString());
string UsrNm = Convert.ToString(ds["UsrNm"].ToString()); Response.Write(shifu + "</br>");
}代码以上!!为什么只显示一条记录呢!!要怎么实现 enterID 全部的数据呢!!!!
SqlDataReader ds = cmd.ExecuteReader();
ds.Read();
{
string shifu = Convert.ToString(ds["shifu"].ToString());
string UsrNm = Convert.ToString(ds["UsrNm"].ToString()); Response.Write(shifu + "</br>");
}代码以上!!为什么只显示一条记录呢!!要怎么实现 enterID 全部的数据呢!!!!
ds.Read();
使用的 方法不对
cmd.CommandText = "select shifu,UsrNm from EnterStateTable where EnterID in(" + enterID + ") ";
SqlDataReader ds = cmd.ExecuteReader();
while(ds.Read())
{
string shifu = Convert.ToString(ds["shifu"].ToString());
string UsrNm = Convert.ToString(ds["UsrNm"].ToString()); Response.Write(shifu + " </br> ");
}