This is a migrated thread and some comments may be shown as answers.

[Solved] Binding items to a Dynamically generated GridDropDownColumn

8 Answers 371 Views

Grid

This is a migrated thread and some comments may be shown as answers.

ketan reddy asked on 17 Apr 2009, 02:48 PM

Hi,

I am having problems with populating a dynamically created GridDropDownColumn. It is not getting populated.

I am doing everything from the codebehind. I am creating a Grid. then adding columns-Checkbox, dropdowns and textboxes.

case 12: // Implies DropDownList Column
                                dropDownColumn = new GridDropDownColumn();
                                dropDownColumn.HeaderText = ListTableColumn[varLoop].Title;
                                dropDownColumn.DataField = ListTableColumn[varLoop].ColumnName;
                           //     dropDownColumn.DataSourceID = "SqlDataSource1";
                                dropDownColumn.ListTextField = ListTableColumn[varLoop].ColumnName;
                                dropDownColumn.ListValueField = ListTableColumn[varLoop].ColumnName;
                                dropDownColumn.UniqueName = ListTableColumn[varLoop].ColumnName;
                               grdMain.MasterTableView.Columns.Add(dropDownColumn);

Though the GridBoundColumn and the GridCheckBoxColumn get populated, the dropdown column shows me an empty column. Even when i get into the edit mode, the dropdown does not have any values.
Do I need to use an ItemDataBound event handler? I tried this but was not sucessfull.

Can someone please help me with this?

Thanks.

8 Answers, 1 is accepted

answered on 20 Apr 2009, 07:38 AM

Hi Ketan,

From the above given code it seems that you have commented out the line which sets the DataSourceID for the GridDropDownColumn. Try setting the DataSourceID for the GridDropDownColumn and see whether it works. Here is the code which I tried on my end.

CS:

    
               RadGrid grid = new RadGrid(); 
        
                .... 
        
              GridDropDownColumn DropCol = new GridDropDownColumn(); 
        
              DropCol.HeaderText = "ProductName"; 
        
              DropCol.DataField = "ProductName"; 
        
              DropCol.DataSourceID = "SqlDataSource1"; 
        
              DropCol.ListTextField = "ProductName"; 
        
              DropCol.ListValueField = "ProductName"; 
        
              DropCol.UniqueName = "DropCol"; 
        
              grid.MasterTableView.Columns.Add(DropCol);

Thanks
Shinu

answered on 27 Apr 2009, 07:55 PM

Allright....I found my mistake. When I tried with a "sqldatasourceId" and set the griddropdown datasource id, it worked.

I had been doing the following where dsTableDetails2 is a SqlDataAdapter. How do I assign data from a dataAdapter to the griddropdown?

    
            dropDownColumn.HeaderText = "StateOrProvinceId";  
        
            dropDownColumn.DataField = "StateOrProvinceId";  
        
            dropDownColumn.ListTextField = "Title";  
        
            dropDownColumn.ListValueField = "StateOrProvinceId";  
        
            dropDownColumn.DataSourceID = "dsTableDetails2";  //This is the SQLdataAdaptor  
        
            dropDownColumn.UniqueName = "dropDownColumn";

    
                SqlConnection con2 = new SqlConnection(ConnString);  
        
                                con2.Open();  
        
                                string sqlString2 = "SELECT StateOrProvinceId, Title FROM City";  
        
                                dsTableDetails2 = new DataSet();  
        
                                adapter2 = new SqlDataAdapter();  
        
                                adapter2.SelectCommand = new SqlCommand(sqlString2, con2);  
        
                                adapter2.Fill(dsTableDetails2,"City");

Thanks.

Accepted