public void DataGrid1_Edit(object sender,DataGridCommandEventArgs e)
        {            
            string strSql;
            string ConnectionString;
            ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
            DataGrid1.EditItemIndex =(int)e.Item.ItemIndex;    
            BindGrid();                        
            DropDownList ddl = (DropDownList)(DataGrid1.Items[e.Item .ItemIndex].Cells [4].Controls [1]);
            strSql = "select WorkState,ItemNumber from ASP_Temp";    

            OleDbConnection myconn=new OleDbConnection(ConnectionString );
            OleDbCommand mycommand=new OleDbCommand (strSql,myconn);    
            myconn.Open();            
            OleDbDataReader myreader=mycommand.ExecuteReader();
                
            ddl.DataSource =myreader;
            ddl.DataTextField ="WorkState";
            ddl.DataValueField = "ItemNumber";
            ddl.DataBind ();    
            myreader.Close();
            myconn.Close();            
        }