How to handle multiple rows from SQL select query in C#?

Question

I have a simple C# windows form in which I have 6 text-boxes. Now I have a SQL query which returns 3 rows (it will always return 3 rows - query gets data from junction table and another table) and each row has 2 columns (Name and Email). What I want to do is populate these 6 text-boxes with the result from sql query like Name 1 & Email 1 should get the value of row 1, Name 2 & Email 2 should get the value of row 2 etc etc.

I have searched here and there but I haven't been able to find a solution so please help me out. I know I need to apply some loop here but I am not able to find the logic here.

Images for reference :

SQL Query Result :

enter image description here

C# Win Form :

enter image description here

Code (which is obviously not the way to do it) :

        SqlDataReader rdr = null;
        SqlConnection con = null;
        SqlCommand cmd = null;
        String Name;
        String Email;
        string ConnectionString = "// my connection string...";
        con = new SqlConnection(ConnectionString);
        con.Open();
        string CommandText = "//sql query goes here";
         cmd = new SqlCommand(CommandText);
         cmd.Connection = con;
        rdr = cmd.ExecuteReader();
        while(rdr.Read())
          {
                  Name = rdr["Name"].ToString(); 
                 Email = rdr["Email"].ToString();
          }

        con.Close();

You should really be using a repeater control for list like data. — Aron
– Aron, Commented Mar 26, 2014 at 12:49
if its only 3 sets, you can just as well hard code the control names. Abstraction (I.E., a control loop) isn't really buying you much yet. — RBarryYoung
– RBarryYoung, Commented Mar 26, 2014 at 12:55

NewbieProgrammer · Accepted Answer · 2014-03-26 13:14:31Z

1

Create two arrays of your textboxes

 TextBox[] names = new TextBox[] {txtName1, txtName2, txtName3};     
 TextBox[] mails = new TextBox[] {txtMail1, txtMail2, txtMail3};

Now after retrieving the reader for your table

int idx = 0;
while(reader.Read() && idx < names.Length)
{
    names[idx].Text = reader.GetString(0);
    mails[idx].Text = reader.GetString(1);
    idx++;
}

Of course this solution is strictly limited by your statement: it will always return 3 rows

edited Mar 26, 2014 at 13:14

NewbieProgrammer

8643 gold badges23 silver badges53 bronze badges

answered Mar 26, 2014 at 12:52

Steve

217k22 gold badges242 silver badges296 bronze badges

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

3 Comments

NewbieProgrammer Over a year ago

Thank you Sir, you have just solved my problem. I can't believe I didn't think of arrays - how stupid of me....

NewbieProgrammer Over a year ago

what if I wanted to do same in DataGridView? I have added three columns in DataGridView and want to display Name1, Name2 and Name3.

Steve Over a year ago

Bind the DataGridView to a DataTable. It is a lot easier

Gaurav K. · Accepted Answer · 2014-03-26 12:51:50Z

1

You may put result of query into DataTable. And later you can set textboxes to show data on each row of DataTable.

answered Mar 26, 2014 at 12:51

Gaurav K.

672 gold badges3 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to handle multiple rows from SQL select query in C#?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related