How to fetch id from databse in SQL server

Question

0.00/5 (No votes)

See more:

public void cmbdisp()
{
    SqlConnection con = new SqlConnection(ConnectionString);
    cmboSelEmp.Items.Clear();
    con.Open();
    SqlCommand cmd = new SqlCommand();
    cmd = con.CreateCommand();
    cmd.CommandText = "Select * from add_employee";
    cmd.ExecuteNonQuery();
    DataTable dt = new DataTable();
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    da.Fill(dt);
    foreach (DataRow dr in dt.Rows)
    {
        cmboSelEmp.Items.Add(dr["name"].ToString());
        cmboSelEmp.SelectedValuePath = (dr["name"].ToString());
        cmboSelEmp.SelectedValuePath = (dr["eid"].ToString());
    }

}

What I have tried:

public void cmbdisp()
{
    SqlConnection con = new SqlConnection(ConnectionString);
    cmboSelEmp.Items.Clear();
    con.Open();
    SqlCommand cmd = new SqlCommand();
    cmd = con.CreateCommand();
    cmd.CommandText = "Select * from add_employee";
    cmd.ExecuteNonQuery();
    DataTable dt = new DataTable();
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    da.Fill(dt);
    foreach (DataRow dr in dt.Rows)
    {
        cmboSelEmp.Items.Add(dr["name"].ToString());
        cmboSelEmp.SelectedValuePath = (dr["name"].ToString());
        cmboSelEmp.SelectedValuePath = (dr["eid"].ToString());
    }

}

Posted 1-Sep-22 20:59pm

prashanth manoj

Updated 1-Sep-22 21:59pm

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2022-09-01T21:59:00

The trouble with loops is, when you assign a value to a single variable inside one after the loop you only have a single value in it - the last one:

C#

foreach (int x in Enumerable.Range(0, 9))
   {
   lastvalue = x;
   }

So when your do the same thing with a datatable, the only result you get is always the last element in the table ...

How to fetch id from databse in SQL server

1 solution

Solution 1

Add your solution here

Preview 0

How to fetch id from databse in SQL server

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us