Retrieve data in dropdown from SQL Server database

Question

I have two tables, one is dept and the other is emp with primary and foreign key relationship from emp.deptid which is a foreign key to dept.id. I have an aspx webpage and I have a dropdown list on it which I want to use to select dname form dropdown. But when I try to execute this code I get an error

Fill: SelectCommand.Connection property has not been initialized.

This is my code:

 protected void Page_Load(object sender, EventArgs e) 
 {
      string cs = ConfigurationManager.ConnectionStrings["practproject"].ConnectionString;

      using (SqlConnection con = new SqlConnection(cs))              
      { }             

      binddeptdropdown();
 }          

 void binddeptdropdown() 
 {            
      SqlDataAdapter da = new SqlDataAdapter("select * from dept", con); 

      DataSet ds = new DataSet();             

      da.Fill(ds, "dept");

      DropDownList1.DataSource = ds;             
      DropDownList1.DataValueField = "dname";             
      DropDownList1.DataTextField = "deptid";             
      DropDownList1.DataBind();          
 }

Please improve the indentation!

Rahul Tripathi
– Rahul Tripathi

2014-08-09 11:57:24 +00:00
Commented Aug 9, 2014 at 11:57 — Rahul Tripathi
– Rahul Tripathi, Commented Aug 9, 2014 at 11:57

Spevy · Accepted Answer · 2014-08-09 13:18:53Z

Your closing brace on your using function is in the wrong place, and your connection object needs to be passed to your function.

 protected void Page_Load(object sender, EventArgs e) 
 {
      string cs = ConfigurationManager.ConnectionStrings["practproject"].ConnectionString;

      using (SqlConnection con = new SqlConnection(cs))              
      {             

      binddeptdropdown(con );
      } 


 } 

 void binddeptdropdown(SQLConnection con) 
     {            
          SqlDataAdapter da = new SqlDataAdapter("select * from dept", con); 

          DataSet ds = new DataSet();             

          da.Fill(ds, "dept");

          DropDownList1.DataSource = ds;             
          DropDownList1.DataValueField = "dname";             
          DropDownList1.DataTextField = "deptid";             
          DropDownList1.DataBind();          
     }

Collectives™ on Stack Overflow

Retrieve data in dropdown from SQL Server database

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