string output="";
//连接数据库(略)
string sql="select * from tablename ";
SqlCommand cmd=new SqlCommand(sql,MyConn);
SqlDataReader dr1=cmd.ExecuteReader();
while(dr1.Read())//把if 改成while!!!
{
output+="<li>"+dr1["title"].ToString()+"</li><br>";
}
response.write(output.tostring());
//连接数据库(略)
string sql="select * from tablename ";
SqlCommand cmd=new SqlCommand(sql,MyConn);
SqlDataReader dr1=cmd.ExecuteReader();
while(dr1.Read())//把if 改成while!!!
{
output+="<li>"+dr1["title"].ToString()+"</li><br>";
}
response.write(output.tostring());
或者用ds来作!
while (myReader.Read())
Console.WriteLine("\t{0}\t{1}", myReader.GetInt32(0), myReader.GetString(1));
myReader.Close();
所以要用循环
while(myReader.Read())
{
....
}
myReader.Close();