将数据库的表读到网页出现内容覆盖的问题
来源:百度知道 编辑:UC知道 时间:2024/05/28 03:34:30
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=127.0.0.1;Integrated Security=SSPI;Initial Catalog=db_new";
conn.Open();
SqlCommand cmd = new SqlCommand("select * from tuser", conn);
SqlDataReader drNew = cmd.ExecuteReader();
if (drNew.Read())
{
while (drNew.Read())
{
Label1.Text = drNew["sid"].ToString();
Label2.Text = drNew["name"].ToString();
}
}
drNew.Close();
conn.Close();
请高手帮忙看下 谢谢
1 张三
2 李四
5 小王
这个是数据库里面的表的内容 只能读出5 小王 到网页中 前面2个都被覆盖掉了
你的代码会出现这种情况,按记录行读取数据后,后读的记录会改变上次的赋值的。
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=127.0.0.1;Integrated Security=SSPI;Initial Catalog=db_new";
conn.Open();
SqlCommand cmd = new SqlCommand("select * from tuser", conn);
SqlDataReader drNew = cmd.ExecuteReader();
if (drNew.Read())
{
while (drNew.Read())
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=127.0.0.1;Integrated Security=SSPI;Initial Catalog=db_new";
conn.Open();
SqlCommand cmd = new SqlCommand("select * from tuser", conn);
SqlDataReader drNew = cmd.ExecuteReader();
if (drNew.Read())
{
while (drNew.Read())
{