I'm using Rad Grid in my application. I need to show my grid as follows.
Source Column |
Lookup Column |
Filter Condition |
Action |
This is Drop down (Dynamic values) |
This is Dropdown (Dynamic values) |
This is (static values) Drop down |
Edit |
This is Dropdown (Dynamic values) |
This is Dropdown (Dynamic values) |
This is (static values) Drop down |
Edit |
This is Drop down (Dynamic values) |
This is Dropdown (Dynamic values) |
This is (static values) Drop down |
Edit |
This is Dropdown (Dynamic values) |
This is Dropdown (Dynamic values) |
This is (static values) Drop down |
Edit |
Each Dynamic Dropdown has different set of values.
aspx coding:
<telerik:RadGrid runat="server" ID="GridRelateColumn" GridLines="None" Skin="Outlook" AllowPaging="true" PageSize="10" OnItemDataBound="GridRelateColumn_ItemDataBound" AutoGenerateColumns="False"> <mastertableview> <Columns> <telerik:GridTemplateColumn headertext="Source Columns" uniquename="SourceColumn"> <itemtemplate> <asp:DropDownList ID="SourceDropDownList" runat="server” Width="160px"></asp:DropDownList> </itemtemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn headertext="LookUp Columns" uniquename="LookUpColumns"> <itemtemplate> <asp:DropDownList ID="LookUpDropDownList" Width ="160px" runat="server"></asp:DropDownList> </itemtemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="FilterCondition" HeaderText="Filter Condition"> <itemtemplate> <asp:DropDownList runat="server" Width ="160px" ID="ddlApplicationStatus"></asp:DropDownList> </itemtemplate> </telerik:GridTemplateColumn> <telerik:GridEditCommandColumn HeaderText="Action" UniqueName="EditCommandColumn" /> </Columns> </mastertableview> </telerik:RadGrid> Codebehind coding: protected void GridRelateColumn_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridDataItem) { DataTable dtDDList = new DataTable(); DataTable dttest = new DataTable(); string definitionID = string.Empty; GridDataItem item = (GridDataItem)e.Item; dttest = (DataTable)item.OwnerTableView.DataSource; for (int i = 0; i < dttest.Rows.Count; i++) { definitionID = dttest.Rows[i]["Source Column"].ToString(); if (definitionID != "" && definitionID != "1") { DropDownList dDownList = (DropDownList)item.FindControl("SourceDropDownList"); dtDDList = (DataTable)BLogic.BusinessComponents.RelateColumn.getAllColumnsByDefinitionID(new Guid(definitionID), new Guid(Session["ProjectID"].ToString())); dDownList.DataSource = dtDDList; dDownList.DataTextField = "ColumnName"; dDownList.DataValueField = "Selected_Column_GUID"; dDownList.DataBind(); } } for (int j = 0; j < dttest.Rows.Count; j++) { definitionID = dttest.Rows[j]["Lookup Column"].ToString(); if (definitionID != "" && definitionID != "1") { DropDownList dDownList = (DropDownList)item.FindControl("LookUpDropDownList"); dtDDList = (DataTable)BLogic.BusinessComponents.RelateColumn.getAllColumnsByDefinitionID(new Guid(definitionID), new Guid(Session["ProjectID"].ToString())); dDownList.DataSource = dtDDList; dDownList.DataTextField = "ColumnName"; dDownList.DataValueField = "Selected_Column_GUID"; dDownList.DataBind(); } } } } |
|||||||||||||||||||||
For Example (please have a look at the below grid)
|
Please help us as soon as possible. we need the solution or suggestion urgently. Thanks Alexis. |
|