or
Protected Sub UserNeedDatasource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs)Dim DataKey As String = Me.Grid1.MasterTableView.DataKeyValues(Me.Grid1SelectedIndexes(0))("DataKeyName").ToString Me.Grid2.DataSource = MyDataSource.GetData(DataKey)end Sub
protected void RadGrid1_Load(object source, GridNeedDataSourceEventArgs e) { String ConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand(@"SELECT columns FROM tables)", conn); DataSet myDataTable = new DataSet(); conn.Open(); try { adapter.Fill(myDataTable, "tables"); } finally { conn.Close(); } DataView myDataView = myDataTable.Tables["tabels"].DefaultView; RadGrid1.MasterTableView.DataSource = myDataView; RadGrid1.MasterTableView.DataBind(); }<telerik:RadAjaxPanel ID="RadAjaxPanel2" runat="server"> <div class="EnterpriseNodes1"> <telerik:RadComboBox ID="RadComboBox1" runat="server" Skin="WebBlue" MarkFirstMatch="true" Visible="false" AllowCustomText="true" Filter="StartsWith" CssClass="combo1" NoWrap="True" OnItemDataBound="RadComboBox1_ItemDataBound" AutoPostBack="false" OnSelectedIndexChanged="RadComboBox1_OnSelectedIndexChanged" OnClientSelectedIndexChanged="RadComboBox1_OnClientSelectedIndexChanged"> </telerik:RadComboBox> <br /> <telerik:RadComboBox ID="RadComboBox2" runat="server" Skin="WebBlue" MarkFirstMatch="true" Visible="false" AllowCustomText="true" Filter="StartsWith" CssClass="combo2" NoWrap="True" OnItemDataBound="RadComboBox2_ItemDataBound" AutoPostBack="false" OnSelectedIndexChanged="RadComboBox2_OnSelectedIndexChanged" OnClientSelectedIndexChanged="RadComboBox2_OnClientSelectedIndexChanged"> </telerik:RadComboBox> <br /> </div></telerik:RadAjaxPanel>function RadComboBox1_OnClientSelectedIndexChanged(sender, args) { __doPostBack('RadComboBox1', '');}function RadComboBox2_OnClientSelectedIndexChanged(sender, args) { __doPostBack('RadComboBox2', '');}protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { RadComboBoxItem item = null; item = new RadComboBoxItem(); item.Value = "1"; item.Text = "Canada"; RadComboBox1.Items.Add(item); item = new RadComboBoxItem(); item.Value = "2"; item.Text = "USA"; RadComboBox1.Items.Add(item); item = new RadComboBoxItem(); item.Value = "3"; item.Text = "BC"; RadComboBox2.Items.Add(item); item = new RadComboBoxItem(); item.Value = "4"; item.Text = "NB"; RadComboBox2.Items.Add(item); item = new RadComboBoxItem(); item.Value = "5"; item.Text = "ON"; RadComboBox2.Items.Add(item); item = new RadComboBoxItem(); item.Value = "6"; item.Text = "CAL"; RadComboBox2.Items.Add(item); item = new RadComboBoxItem(); item.Value = "7"; item.Text = "FLA"; RadComboBox2.Items.Add(item); item = new RadComboBoxItem(); item.Value = "8"; item.Text = "NY"; RadComboBox2.Items.Add(item); RadComboBox1.Text = ""; RadComboBox1.ClearSelection(); RadComboBox1.Visible = true; RadComboBox2.Text = ""; RadComboBox2.ClearSelection(); RadComboBox2.Visible = true; } }protected void RadComboBox1_OnSelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e) { FilterNext(ref RadComboBox1, ref RadComboBox2); }private void FilterNext(ref RadComboBox cbCurrent, ref RadComboBox cbNext) { if (cbCurrent.Text == "Canada") { for (int i = 0; i <= cbNext.Items.Count - 1; i++) { if (cbNext.Items[i].Text == "BC" || cbNext.Items[i].Text == "NB" || cbNext.Items[i].Text == "ON") { cbNext.Items[i].Visible = true; //WriteLog("true " + cbNext.Items[i].Text); } else { cbNext.Items[i].Visible = false; //WriteLog("false " + cbNext.Items[i].Text); } } } if (cbCurrent.Text == "USA") { for (int i = 0; i <= cbNext.Items.Count - 1; i++) { if (cbNext.Items[i].Text == "CAL" || cbNext.Items[i].Text == "FLA" || cbNext.Items[i].Text == "NY") { cbNext.Items[i].Visible = true; //WriteLog("true " + cbNext.Items[i].Text); } else { cbNext.Items[i].Visible = false; //WriteLog("false " + cbNext.Items[i].Text); } } } cbNext.DataBind(); }| protected void grvReport_ItemDataBound(object sender, GridItemEventArgs e) |
| { |
| if (e.Item is GridDataItem) |
| { |
| GridDataItem item = ((GridDataItem)e.Item); |
| item["coltrainerList"].Text = item["coltrainerList"].Text.Replace(",", "<br/>"); |
| } |
| // Other unrelated stuff |
| } |
| if (item["coltrainerList"] != null) item["coltrainerList"].Text = item["coltrainerList"].Text.Replace(",", "<br/>"); |
<telerik:RadGrid ID="grdPayment" runat="server" AutoGenerateColumns="false" HeaderStyle-Font-Bold="true" AllowMultiRowSelection="true" AllowAutomaticInserts="True" OnDetailTableDataBind="grdPayment_DetailTableDataBind" CssClass="RadGridCustomClass" OnNeedDataSource="grdPayment_NeedDataSource" Width="98%"> <MasterTableView HierarchyLoadMode="Client" AllowSorting="true" NoDetailRecordsText="" CommandItemDisplay="TopAndBottom" EditMode="InPlace" DataKeyNames="PaymentItemID"> <CommandItemTemplate> <div style="padding: 5px 5px;"> <telerik:RadButton ID="btnInsert" runat="server" CommandName="InitInsert" Visible='<%# !grdHAGroup.MasterTableView.IsItemInserted %>' Text="Add new"> <Icon PrimaryIconUrl="~/Image/Button/add.gif" PrimaryIconLeft="4" PrimaryIconTop="4" /> </telerik:RadButton> <telerik:RadButton runat="server" Text="Save" ID="Button01" Visible='<%# !grdPayment.MasterTableView.IsItemInserted %>'> <Icon PrimaryIconUrl="~/Image/Button/save.gif" PrimaryIconLeft="8" PrimaryIconTop="4" /> </telerik:RadButton> <asp:LinkButton ID="btnCancel" runat="server" CommandName="CancelAll" Visible='<%# grdPayment.EditIndexes.Count > 0 || grdPayment.MasterTableView.IsItemInserted %>'> <img style="border:0px;vertical-align:middle;" alt="" src="~/Image/Button/cancel.gif" />Cancel editing </asp:LinkButton> <asp:LinkButton ID="LinkButton3" runat="server" CommandName="PerformInsert" Visible='<%# grdPayment.MasterTableView.IsItemInserted %>'> <img style="border:0px;vertical-align:middle;" alt="" src="~/Image/Button/yes.gif" /> Add this Bill No </asp:LinkButton> <telerik:RadButton runat="server" Text="Delete selected Bill No(s)" ID="RadButton5" Visible='<%# !grdPayment.MasterTableView.IsItemInserted %>' OnClientClick="javascript:return confirm('Delete all selected customers?')" CommandName="DeleteSelected"> <Icon PrimaryIconUrl="~/Image/Button/remove.gif" PrimaryIconLeft="8" PrimaryIconTop="4" /> </telerik:RadButton> </div> </CommandItemTemplate> <Columns> <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" /> <telerik:GridTemplateColumn UniqueName="CostCentreDisplyID" HeaderText="Bill No."> <ItemTemplate> <asp:Label ID="lblCostCentreID" runat="server" Text='<%# Eval("BillNo") %>' /> <asp:TextBox ID="txtCostCentreID" runat="server" Text='<%# Bind("BillNo") %>' Width="95%" Style="display: none" /> </ItemTemplate> <InsertItemTemplate> <asp:TextBox ID="txtCostCentreID" runat="server" Width="95%" /> </InsertItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="CostCentre" HeaderText="Description"> <ItemTemplate> <asp:Label ID="lblCostCentre" runat="server" Text='<%# Eval("BillDesp") %>' /> <asp:TextBox ID="txtCostCentre" runat="server" Text='<%# Bind("BillDesp") %>' Width="95%" Style="display: none" /> </ItemTemplate> <InsertItemTemplate> <asp:TextBox ID="txtCostCentre" runat="server" Width="95%" /> </InsertItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="discount" HeaderText="Discount(%)" DataFormatString="{0:###,##0.###0}" UniqueName="discount"> <ItemStyle HorizontalAlign="Right" /> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle Width="50px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Amount" HeaderText="Certified Amount" DataFormatString="{0:###,##0.#0}" UniqueName="Amount"> <ItemStyle HorizontalAlign="Right" /> <HeaderStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> </Columns> <DetailTables> <telerik:GridTableView DataKeyNames="PaymentItemID" Name="ItemLevel" Width="100%" CommandItemDisplay="TopAndBottom" EditMode="InPlace" HierarchyLoadMode="ServerOnDemand"> <HeaderStyle CssClass="MostInnerHeaderStyle" /> <CommandItemTemplate> <div style="padding: 5px 5px;"> <telerik:RadButton ID="btnInsertDetail" runat="server" CommandName="InitDetailInsert" Visible='<%# !(Container as GridCommandItem).OwnerTableView.IsItemInserted %>' Text="Add New Milestone#" > <Icon PrimaryIconUrl="~/Image/Button/add.gif" PrimaryIconLeft="4" PrimaryIconTop="4" /> </telerik:RadButton> <telerik:RadButton ID="btnCancelDetail" runat="server" CommandName="InitDetailCancel" Visible='<%# grdPayment.EditIndexes.Count > 0 || (Container as GridCommandItem).OwnerTableView.IsItemInserted %>' Text="Cancel editing" > <Icon PrimaryIconUrl="~/Image/Button/cancel.gif" PrimaryIconLeft="4" PrimaryIconTop="4" /> </telerik:RadButton> <telerik:RadButton ID="btnPerformInsertNewDetail" runat="server" CommandName="PerformInsertDetail" Visible='<%# (Container as GridCommandItem).OwnerTableView.IsItemInserted %>' Text="Add this Record" > <Icon PrimaryIconUrl="~/Image/Button/add.gif" PrimaryIconLeft="4" PrimaryIconTop="4" /> </telerik:RadButton> <telerik:RadButton ID="btnDeleteDetails" runat="server" CommandName="InitDetailDelete" OnClientClick="javascript:return confirm('Delete all selected customers?')" Visible='<%# !(Container as GridCommandItem).OwnerTableView.IsItemInserted %>' Text="Delete selected Milestone#" > <Icon PrimaryIconUrl="~/Image/Button/remove.gif" PrimaryIconLeft="4" PrimaryIconTop="4" /> </telerik:RadButton> </div> </CommandItemTemplate> <Columns> <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn"> <HeaderStyle Width="5%" /> <ItemStyle Width="5%" /> </telerik:GridClientSelectColumn> <telerik:GridTemplateColumn UniqueName="ItemNo" HeaderText="Item No."> <ItemTemplate> <asp:Label ID="lblMilestoneDisplyID" runat="server" Text='<%# Bind("ItemNo") %>' /> <asp:TextBox ID="txtMilestoneDisplyID" runat="server" Text='<%# Bind("ItemNo") %>' Width="95%" Style="display: none" /> </ItemTemplate> <InsertItemTemplate> <asp:TextBox ID="txtMilestoneDisplyID" runat="server" Width="95%" /> </InsertItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="ItemDesp" HeaderText="Description"> <ItemTemplate> <asp:TextBox ID="tbxCostActivities" runat="server" Text='<%# Bind("ItemDesp") %>' Width="95%" Style="display: none" /> </ItemTemplate> <InsertItemTemplate> <asp:TextBox ID="txtCostActivities" runat="server" Width="95%" /> </InsertItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="Amount" HeaderText="Certified Amount" DataFormatString="{0:###,##0.#0}" UniqueName="Amount"> <ItemStyle HorizontalAlign="Right" /> <HeaderStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> </Columns> <ExpandCollapseColumn Visible="True"/> </telerik:GridTableView> </DetailTables> </MasterTableView> <ClientSettings AllowExpandCollapse="false"> <Selecting AllowRowSelect="true" /> </ClientSettings> </telerik:RadGrid>