or
I want to call a storedprocedure when filtering happens in RadGrid , but it does not seem to be working. How do I override the default filering and bind to the data from the storedprocedure?
protected void RadGridMaster_ItemCommand(object source, GridCommandEventArgs e) { if (e.CommandName == RadGrid.FilterCommandName) { Pair filterPair = (Pair)e.CommandArgument; string filterPattern = ((TextBox)(e.Item as GridFilteringItem)[filterPair.Second.ToString()].Controls[0]).Text; //string filter = RadGridMaster.MasterTableView.FilterExpression; BindMasterGrid(filterPattern); (this.Page as BasePage).ClearAllControls(); } }<tel:RadGrid runat="server" ID="rgImportData" AutoGenerateColumns="false" Width="100%" > <MasterTableView> <Columns> <tel:GridTemplateColumn HeaderText="Exclude from Import" UniqueName="ExcludeColumn" > <ItemTemplate> <asp:CheckBox ID="cbExcludeFromImport" runat="server" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridBoundColumn DataField="SpeciesName" HeaderText="Species Name" UniqueName="SpeciesName" /> <tel:GridBoundColumn DataField="SpeciesID" UniqueName="SpeciesID" Display="false" /> <tel:GridTemplateColumn HeaderText="Length" UniqueName="Length" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntLength" Text='<%# Eval("Length") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Weight" UniqueName="Weight" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntWeight" Text='<%# Eval("Weight") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridBoundColumn DataField="Sex" HeaderText="Sex" UniqueName="Sex" /> <tel:GridTemplateColumn HeaderText="Age" UniqueName="Age" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntAge" Text='<%# Eval("Age") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Magn." UniqueName="Magnification" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntMagnification" Text='<%# Eval("Magnification") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Annulus 1" UniqueName="Annulus1" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntAnn1" Text='<%# Eval("Annulus1") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Annulus 2" UniqueName="Annulus2" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntAnn2" Text='<%# Eval("Annulus2") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Annulus 3" UniqueName="Annulus3" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntAnn3" Text='<%# Eval("Annulus3") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Annulus 4" UniqueName="Annulus4" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntAnn4" Text='<%# Eval("Annulus4") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Annulus 5" UniqueName="Annulus5" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntAnn5" Text='<%# Eval("Annulus5") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Annulus 6" UniqueName="Annulus6" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntAnn6" Text='<%# Eval("Annulus6") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Annulus 7" UniqueName="Annulus7" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntAnn7" Text='<%# Eval("Annulus7") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Annulus 8" UniqueName="Annulus8" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntAnn8" Text='<%# Eval("Annulus8") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> <tel:GridTemplateColumn HeaderText="Edge" UniqueName="Edge" > <ItemTemplate> <tel:RadNumericTextBox runat="server" ID="rgrntEdge" Text='<%# Eval("Edge") %>' NumberFormat-DecimalDigits="0" Width="40px" MaxValue="9999" /> </ItemTemplate> </tel:GridTemplateColumn> </Columns> <NoRecordsTemplate> Select a file to see what data will be imported into this view. </NoRecordsTemplate> </MasterTableView></tel:RadGrid>
<table class="topbot" pgwide="1" id="nzf_734"><caption> Recommended regimens for <i>Helicobacter pylori</i> eradication in adults </caption><colgroup cols="5"><col colname="col1" /><col colname="col2" /><col colname="col3" /><col colname="col4" /><col colname="col5" /></colgroup><colspec colname="col1" /><colspec colname="col2" /><colspec colname="col3" /><colspec colname="col4" /><colspec colname="col5" /><thead> etc
But the editor display the above content as like
<table id="nzf_734" class="topbot" pgwide="1"><caption>
Recommended regimens for
<i>Helicobacter pylori</i>
eradication in adults
</caption>
<colgroup cols="5"><col colname="col1">
<col colname="col2"><col colname="col3">
<col colname="col4"><col colname="col5">
</colgroup><colspec colname="col1"><colspec colname="col2"><colspec colname="col3"><colspec colname="col4"><colspec colname="col5"><thead>
Editor automatically remove the end tag, if it is not contain the value.
it will create problem for me. How to solve this issue. Please help me. It is urgent.
Thanks
Uma