ASP.NET : populate many label from one SQL command

Question

It is possible to populate many labels from one SqlCommand instead of writing many SqlCommand?

For example

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

So I ask - is it possible using just one SqlCommand?

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. — Roman Marusyk
– Roman Marusyk, Commented Dec 27, 2018 at 16:12
I ask how/or if is possible to using one sql command to populate multiple Labels with different ID like where ID=1-for Label1 Text , where ID=2 for label2.text — Leszcz Terry
– Leszcz Terry, Commented Dec 27, 2018 at 16:18
Then you are using ADO.NET, which is when you use SqlConnection directly (or some other provider that implements System.Data.Common.DbConnection. — mason
– mason, Commented Dec 27, 2018 at 16:43
If you want multiple records to come back from the database, consider rewriting your sql where clause or eliminating it altogether. No need for multiple select statements. For instance, "Select name from users" or "Select name from users where ID between @x and @y". Then use a repeater or some sort of loop to fill your labels dynamically in your UI. — iii
– iii, Commented Dec 27, 2018 at 17:04

soccer7 · Accepted Answer · 2018-12-27 16:56:48Z

2

As per your confirmation that you use ADO.NET, here is what you are looking for-

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();

answered Dec 27, 2018 at 16:56

soccer7

4,0613 gold badges33 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Leszcz Terry Over a year ago

Thank you sir. This is what i need.

Collectives™ on Stack Overflow

ASP.NET : populate many label from one SQL command

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related