I tried several times in combobox data is not retrieved DB

narasiman rao

My code as follows

In pageload i written the below code as follows

SqlConnection conn = new SqlConnection(@"Data Source=DOCTOR\SQLEXPRESS;Initial Catalog=Testing;User ID=sa;Password=a");

conn.Open();
SqlCommand sc = new SqlCommand("select Designation from Designations where active <> 'd'", conn);
SqlDataReader reader;
reader = sc.ExecuteReader();
DataTable dt = new DataTable();
dt.Columns.Add("Designation", typeof(string));
dt.Load(reader);
dt.Load(reader);
ComboBox1.DataTextField = "Designation";
ComboBox1.DataValueField = "Designation";
ComboBox1.DataSource = dt;
ComboBox1.DataBind();
conn.Close();

In database records as follows (Table name Designations )

ID Name Designation
1 Raj Course Officer
2 Ramesh Authorised signatoury

In run mode as follows

Designation Combobox

But in combobox designation is not displayed.
i tried several time but in combobox designation is not shown.
please help me what is the problem in my above code.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raja T11y ago
Hi, I have checked your code it is working for me fine.

I have tried bellow code it is working fine
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=localhost;Initial Catalog=TestDemo;User ID=abc;Password=passwd@123");

conn.Open();
SqlCommand sc = new SqlCommand("select distinct(fname) from tbl_users where fname!=''", conn);
SqlDataReader reader;
reader = sc.ExecuteReader();
DataTable dt = new DataTable();
dt.Columns.Add("fname", typeof(string));
dt.Load(reader);
DropDownList1.DataTextField = "fname";
DropDownList1.DataValueField = "fname";
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
conn.Close();
}

0
Rakesh11y ago
Hello Narasiman Rao,
1. write code in Page load event,
2. Check your database connection string,
3. check this link :
http://csharp.net-informations.com/dataset/dataset-combobox.htm
0