dropdown list in datagrid

[madhukk]

Im trying to have dropdown list in datagrid where a list is extracted from a table but when i press the edit link in data grid the list items are disappearing
help me please.... following is code.....

DataGrid1_ItemDataBound( )  ...   
 
 
 SqlConnection cnn = new SqlConnection("Data Source=NETZOOM\\MADHUK_2005;Integrated Security=SSPI;Initial Catalog=master");
 
string sql = "select dept from dptmnt";
        DataSet ds = new DataSet();
        SqlCommand cmd = new SqlCommand(sql, cnn);
        cnn.Open();
        SqlDataReader dr = cmd.ExecuteReader();
 
 
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            DropDownList DropDownList1 = (DropDownList)((DataGridItem)e.Item).FindControl("DropDownList1");
             ListItem li = new ListItem();
             DropDownList1.Items.Add(li);
             DropDownList1.DataSource = dr;
             DropDownList1.DataValueField = "dept";
             DropDownList1.DataTextField = "dept";
             DropDownList1.DataBind();

[tlhintoq]

TIP: When you are writing your question, there is a button on the tool bar that wraps the [code] tags around your copy/pasted code. It helps a bunch. Its the button with a '#' on it. More on tags. They're cool. Check'em out.