asp.net - ASP.NET：从一个 SQL 命令填充多个标签

Question

可以从一个填充多个标签SqlCommand而不是编写多个SqlCommand？

例如

select name from users where ID=1
select name from users where ID=2
select name from users where ID=3
select name from users where ID=4

Label1.Text = //here should be ID 1
Label2.Text = //here should be ID 2
Label1.Text = //here should be ID 3
Label2.Text = //here should be ID 4

所以我问 - 是否可以只使用一个SqlCommand？

标签： asp.netsql-server

Answer 1

根据您对使用 ADO.NET 的确认，这就是您要查找的内容 -

SqlConnection con = new SqlConnection(@"server=localhost; database=Site; trusted_connection=true;"); 
con.Open(); 
SqlCommand cmd = new SqlCommand(@"select id, name from users where ID Between 1 and 4", con); 
SqlDataReader dr = cmd.ExecuteReader(); 
while (dr.Read()) 
{
   if(dr["id"].ToString() == "1")
     Label1.Text = dr["Name"].ToString();
   else if(dr["id"].ToString() == "2")
     Label2.Text = dr["Name"].ToString();
   else if(dr["id"].ToString() == "3")
     Label3.Text = dr["Name"].ToString();
   else if(dr["id"].ToString() == "4")
     Label4.Text = dr["Name"].ToString();
} 
dr.Close(); 
con.Close();