how to get selected values from database to dropdown on the behalf of a Session

string SqlConnect = System.Configuration.ConfigurationManager.ConnectionStrings["Connect"].ConnectionString; SqlConnection Sqlconn = new SqlConnection(SqlConnect); SqlCommand sqlcomm = new SqlCommand("select * from Category", Sqlconn); Sqlconn.Open(); SqlDataReader dr = sqlcomm.ExecuteReader(); if (dr.HasRows) { DropDownList1.DataSource = dr; DropDownList1.DataTextField = "CatName"; DropDownList1.DataValueField = "Catid"; DropDownList1.DataBind(); ListItem c = new ListItem("Select Category", "0"); DropDownList1.Items.Insert(0, c); ListItem d = new ListItem("Select Warranty", "0"); DropDownList2.Items.Insert(0, d); dr.Close(); Sqlconn.Close(); } this code can tell u what i know and if u want to help then Welcome.

Buddy Sorry But i'm not arrogant look above comment that guy said that "And it was so urgent you forgot to ask a question in your haste? How is any of this a problem? Do you not know how to connect to your database (whatever it is)? Do you know know how to write a query? Do you not know how to execute a query?" this thing made me sad thats y i said to him not to comment its not for you Buddy :(