how to fetch multiple data from database to label in C# windows application

Question

private void button1_Click(object sender, EventArgs e)
{
    con.Open();
    SqlDataAdapter da = new SqlDataAdapter(
        "select  CustomerName,CompanyName,ContactNo from tbl_LeadFollowUp where WorkType='internet shopping'", con);
    DataSet ds = new DataSet();
    DataTable dt = new DataTable();
    da.Fill(ds);
    da.Fill(dt);

    foreach (DataRow row in dt.Rows)
    {
        textBox1.Text = (row["CompanyName"].ToString());
        textBox2.Text = (row["CustomerName"].ToString());
        label2.Text = (row["ContactNo"].ToString());
     }
     con.close();
}

Is the question here "how do I display multiple rows in the UI?" - because... you're probably going to want a grid of some kind (DataGridView etc) to put the results in... — Marc Gravell
– Marc Gravell, Commented Jul 1, 2016 at 12:06
I'm not sure if you are asking for this but, label2.Text += (row["ContactNo"].ToString());. If you want to show multiple data in label (as you told in the question) use this. — Berkay Yaylacı
– Berkay Yaylacı, Commented Jul 1, 2016 at 12:22

Vignesh Kumar A · Accepted Answer · 2016-07-01 12:09:49Z

1

You have to use DataGridview for binding the multiple data from Database to UI.

You can't iterate multiple data to single lable. It will get overwrite not append

private void button1_Click(object sender, EventArgs e)
{
  con.Open();
  SqlDataAdapter da = new SqlDataAdapter("select  CustomerName,CompanyName,ContactNo from tbl_LeadFollowUp where WorkType='internet shopping'", con);
  DataSet ds = new DataSet();
  DataTable dt = new DataTable();
  da.Fill(ds);
  da.Fill(dt);
  dataGridView1.DataSource = da;
  dataGridView1.DataMember = "Lead";
  con.close();
}

answered Jul 1, 2016 at 12:09

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

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

Collectives™ on Stack Overflow

how to fetch multiple data from database to label in C# windows application

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related