Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
164 views
I have a TreeList that allows multiple row selection (server-side) and has a TreeListSelectColumn.  This configuration also creates a checkbox in the header that allows all rows to be selected/deselected.  When an individual row is selected the expected ItemCommand event is triggered on the server-side.  However, when the select-all checkbox in the header is checked and all rows are selected, the subsequent postback does not generate ItemCommand events.  Is there a particular event for this select-all postback? Any recommendations for capturing these selection changes?

<telerik:RadTreeList ID="OrganizationTreeList"
                     runat="server"
                     AllowPaging="True"
                     AllowSorting="True"
                     AllowMultiItemSelection="True"
                     AutoGenerateColumns="false"
                     DataKeyNames="ID"
                     ParentDataKeyNames="ParentID"
                     GridLines="Vertical"
                     OnNeedDataSource="OrganizationTreeList_OnNeedData"
                     OnItemDataBound="OrganizationTreeList_OnItemDataBound"
                     OnItemCommand="OrganizationTreeList_ItemCommand">
    <NoRecordsTemplate>
        There are no organizations to display.
    </NoRecordsTemplate>
    <Columns>
        <telerik:TreeListSelectColumn UniqueName="SelectColumn" HeaderStyle-Width="5%"  />
        <telerik:TreeListBoundColumn DataField="ID" 
                                     HeaderText="ID"
                                     UniqueName="ID"
                                     HeaderStyle-Width="80px"
                                     HeaderStyle-HorizontalAlign="Center"
                                     ItemStyle-HorizontalAlign="Center" />
        <telerik:TreeListCheckBoxColumn DataField="IsActive"
                                        HeaderText="Active"
                                        UniqueName="IsActive"
                                        HeaderStyle-Width="55px"
                                        HeaderStyle-HorizontalAlign="Center"
                                        ItemStyle-HorizontalAlign="Center" />
        <telerik:TreeListBoundColumn DataField="Name"
                                     HeaderText="Name"
                                     UniqueName="Name"
                                     HeaderStyle-Width="68%" />
    </Columns>
    <PagerStyle Mode="NextPrevAndNumeric"  />
</telerik:RadTreeList>   
Marin
Telerik team
 answered on 07 Apr 2011
1 answer
120 views
I've getting an error on the grouping of my grid.  I get the "Column ? does not exist in table"  however it's here.  I have a form with several ways to filter the grid.  I need to group the grid based on the first 4 columns.

Here is my aspx and code behind.

CODE BEHIND

 

protected void btnReport_Click(object sender, EventArgs e)

 

 

{

 

 

grdInventory.Visible = true;

 

 

 

grdInventory.Rebind();

 

 

}



 

protected void grdInventory_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

 

 

{


 

List<ProductInventoryList> pList = (List<ProductInventoryList>)Session["ShipmentActivity"];

 

#region

 

Selection

 

 

 

string selection = "";

 

 

 

if (ddlProduct.SelectedItem.Text != "")

 

 

{

 

 

selection += "Product = '" + ddlProduct.SelectedItem.Text + "'";

 

 

}

 

 

if (ddlLot.SelectedItem.Text != "")

 

 

{

 

 

if (selection != string.Empty)

 

 

{

 

 

selection += " AND ";

 

 

}

 

 

selection += Operator(ddlLotSearch.SelectedItem.Text, "Lot", ddlLot.SelectedItem.Text);

 

 

}

 

 

if (ddlProtocolID.SelectedItem.Text != "")

 

 

{

 

 

if (selection != string.Empty)

 

 

{

 

 

selection += " AND ";

 

 

}

 

 

selection += Operator(ddlProtocolSearch.SelectedItem.Text, "ProtocolID", ddlProtocolID.SelectedItem.Text);

 

 

}

 

 

if (ddlShipTo.SelectedItem.Text != "")

 

 

{

 

 

if (selection != string.Empty)

 

 

{

 

 

selection += " AND ";

 

 

}

 

 

selection += "ShipTo = '" + ddlShipTo.SelectedItem.Text+"'";

 

 

}

 

 

if (ddlStockNumber.SelectedItem.Text != "")

 

 

{

 

 

if (selection != string.Empty)

 

 

{

 

 

selection += " AND ";

 

 

}

 

 

selection += Operator(ddlStockSearch.SelectedItem.Text, "StockNumber", ddlStockNumber.SelectedItem.Text);

 

 

}

 

 

if (ddlShipNo.SelectedItem.Text !="")

 

 

{

 

 

if (selection != string.Empty)

 

 

{

 

 

selection += " AND ";

 

 

}

 

 

selection += Operator(ddlShipNo.SelectedItem.Text, "ShippmentNumber", ddlShipNo.SelectedItem.Text);

 

 

}

 

 

if (ddlClientShip.SelectedItem.Text != "")

 

 

{

 

 

if (selection != string.Empty)

 

 

{

 

 

selection += " AND ";

 

 

}

 

 

selection += Operator(ddlShipNo.SelectedItem.Text, "ClientOrderNumber", ddlShipNo.SelectedItem.Text);

 

 

}

 

 

if (dtStartDate.SelectedDate != null)

 

 

{

 

 

if (selection != string.Empty)

 

 

{

 

 

selection += " AND ";

 

 

}

 

 

selection += "ShipDate >= '" + dtStartDate.SelectedDate.Value.ToShortDateString() +"'";

 

 

}

 

 

if (dtEndDate.SelectedDate != null)

 

 

{

 

 

if (selection != string.Empty)

 

 

{

 

 

selection += " AND ";

 

 

}

 

 

selection += "ShipDate <= '" + dtEndDate.SelectedDate.Value.ToShortDateString() + "'";

 

 

}

 

 

#endregion

 

Selection

 

 

 

var query = from l in pList

 

 

select new ProductInventoryList

 

{

 

DrugName = l.DrugName.Trim(),

 

 

 

Organization = l.Organization.Trim(),

 

 

 

StockNumber = l.StockNumber.Trim(),

 

 

 

UnitsPerPackage = l.UnitsPerPackage.Trim(),

 

 

 

PackingUnit = l.PackingUnit.Trim(),

 

 

 

PackContainer = l.PackContainer.Trim(),

 

 

 

Lot = l.Lot.Trim(),

 

 

 

ProtocolID = l.ProtocolID.Trim(),

 

 

 

ShipmentNumber= l.ShipmentNumber,

 

 

 

ClientOrderNumber = l.ClientOrderNumber,

 

 

 

ShipTo = l.Organization,

 

 

 

ShipmentAddress = l.ShipmentAddress,

 

 

 

ShipmentAddress2 = l.ShipmentAddress2,

 

 

 

ShipCity= l.ShipCity,

 

 

 

ShipState= l.ShipState,

 

 

 

ShipZipCode = l.ShipZipCode,

 

 

 

ShipCountry = l.ShipCountry,

 

 

 

Investigator = l.Investigator,

 

 

 

QuantityShipped = l.QuantityShipped,

 

 

 

ShipmentDate = l.ShipmentDate

 

};

 

DataTable dt = new DataTable();

 

 

 

dt.Columns.Add("ShipmentNumber", typeof(string));

 

 

 

dt.Columns.Add("ShipDate", typeof(DateTime));

 

 

 

dt.Columns.Add("ProtocolID", typeof(string));

 

 

 

dt.Columns.Add("ClientShip", typeof(string));

 

 

 

dt.Columns.Add("ShipTo", typeof(string));

 

 

 

dt.Columns.Add("ShipAddress", typeof(string));

 

 

 

dt.Columns.Add("Product", typeof(string));

 

 

 

dt.Columns.Add("PackUnit", typeof(string));

 

 

 

dt.Columns.Add("Investigator", typeof(string));

 

 

 

dt.Columns.Add("StockNumber", typeof(string));

 

 

 

dt.Columns.Add("Lot", typeof(string));

 

 

 

dt.Columns.Add("QtyShipped", typeof(string));

 

 

 

foreach (var p in query)

 

 

{

 

 

DataRow row = dt.NewRow();

 

 

 

if (p.ShipmentNumber != "")

 

 

{

 

 

row["ShipmentNumber"] = p.ShipmentNumber;

 

 

}

 

 

if (p.ShipmentDate != null)

 

 

{

 

 

row["ShipDate"] = DateTime.Parse(p.ShipmentDate).Date;

 

 

}

 

 

if (p.ProtocolID == "")

 

 

{

 

 

row["ProtocolID"] = " ";

 

 

}

 

 

else

 

{

 

row["ProtocolID"] = p.ProtocolID;

 

 

}

 

 

row["ClientShip"] = p.ClientOrderNumber;

 

 

 

row["ShipTo"] = p.ShipTo;

 

 

 

row["ShipAddress"] = p.ShipmentAddress + "<br/>" + p.ShipmentAddress2 + "<br/>" + p.ShipCity + ", " + p.ShipState + " " + p.ShipZipCode + " " + p.ShipCountry;

 

 

 

row["Investigator"] = p.Investigator;

 

 

 

row["Product"] = p.DrugName;

 

 

 

row["PackUnit"] = p.UnitsPerPackage + " " + p.PackingUnit + " " + p.PackContainer;

 

 

 

row["StockNumber"] = p.StockNumber;

 

 

 

row["Lot"] = p.Lot;

 

 

 

row["QtyShipped"] = p.QuantityShipped;

 

 

 

dt.Rows.Add(row);

 

 

}

 

 

grdInventory.VirtualItemCount = dt.Rows.Count;

 

 

 

grdInventory.DataSource = dt.Select(selection);
}


ASPX

 

 

 

<telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">

 

 

 

 

 

 

 

 

 

<script type="text/javascript">

 

 

 

 

 

 

 

 

 

function RequestStarted(ajaxManager, eventArgs) {

 

 

 

 

if (eventArgs.get_eventTarget().indexOf("imgbtnExcel") != -1)

 

 

 

 

eventArgs.set_enableAjax(false);

 

 

}

 

 

 

 

 

</

 

 

script>

 

 

 

 

</telerik:RadScriptBlock>

 

 

 

 

 

 

 

 

 

<h1>Product Inventory</h1>

 

 

 

 

 

 

 

 

 

<br />

 

 

<

 

 

div class="maincontent">

 

 

<

 

 

div class="labels">

 

 

 

 

 

 

 

 

 

<asp:Label ID="lblProduct" runat="server" Text="Product:"></asp:Label>

 

 

</

 

 

div>

 

 

<

 

 

div class="textlabel">

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlProduct" runat="server" EnableEmbeddedSkins="false"

 

 

 

 

Skin="DMID" onload="ddlProduct_Load" onprerender="ddlProduct_PreRender"

 

 

 

 

DataTextField="Description" Width="350px">

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

</

 

 

div>

 

 

<

 

 

div class="labels">

 

 

 

 

 

 

 

 

 

<asp:Label ID="lblLot" runat="server" Text="Lot #:"></asp:Label>

 

 

</

 

 

div>

 

 

<

 

 

div class="textlabel">

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlLotSearch" runat="server"

 

 

 

 

EnableEmbeddedSkins="false" Skin="DMID"

 

 

 

 

onprerender="ddlLotSearch_PreRender" onload="ddlLotSearch_Load">

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

 

 

<img src="../App_Themes/DMID/Images/onepix.gif" alt="" width="15px"/>

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlLot" runat="server" EnableEmbeddedSkins="false"

 

 

 

 

Skin="DMID" onload="ddlLot_Load" onprerender="ddlLot_PreRender"

 

 

 

 

DataTextField="Lot">

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

</

 

 

div>

 

 

<

 

 

div class="labels">

 

 

 

 

 

 

 

 

 

<asp:Label ID="lblProtocolID" runat="server" Text="Protocol #:"></asp:Label>

 

 

</

 

 

div>

 

 

<

 

 

div class="textlabel">

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlProtocolSearch" runat="server"

 

 

 

 

EnableEmbeddedSkins="false" Skin="DMID"

 

 

 

 

onprerender="ddlProtocolSearch_PreRender" onload="ddlProtocolSearch_Load">

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

 

 

 

 

 

 

 

<img src="../App_Themes/DMID/Images/onepix.gif" alt="" width="15px"/>

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlProtocolID" runat="server"

 

 

 

 

EnableEmbeddedSkins="false" Skin="DMID" onload="ddlProtocolID_Load"

 

 

 

 

onprerender="ddlProtocolID_PreRender" DataTextField="ProtocolID">

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

</

 

 

div>

 

 

<

 

 

div class="labels">

 

 

 

 

 

 

 

 

 

<asp:Label ID="lblShipTo" runat="server" Text="Ship To:" ></asp:Label>

 

 

</

 

 

div>

 

 

<

 

 

div class="textlabel">

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlShipTo" runat="server"

 

 

 

 

EnableEmbeddedSkins="false" Skin="DMID" onload="ddlShipTo_Load"

 

 

 

 

onprerender="ddlShipTo_PreRender" DataTextField="ShipTo" Width="250px">

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

</

 

 

div>

 

 

<

 

 

div class="labels">

 

 

 

 

 

 

 

 

 

<asp:Label ID="lblStockNumber" runat="server" Text="FBS Stock Number:"></asp:Label>

 

 

</

 

 

div>

 

 

<

 

 

div class="textlabel">

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlStockSearch" runat="server"

 

 

 

 

EnableEmbeddedSkins="false" Skin="DMID"

 

 

 

 

onprerender="ddlStockSearch_PreRender" onload="ddlStockSearch_Load">

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

 

 

 

 

 

 

 

<img src="../App_Themes/DMID/Images/onepix.gif" alt="" width="15px"/>

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlStockNumber" runat="server"

 

 

 

 

EnableEmbeddedSkins="false" Skin="DMID" onload="ddlStockNumber_Load"

 

 

 

 

onprerender="ddlStockNumber_PreRender" DataTextField="StockNumber">

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

</

 

 

div>

 

 

<

 

 

div class="labels">

 

 

 

 

 

 

 

 

 

<asp:Label ID="lblFBSShipNo" runat="server" Text="FBS Ship #:"></asp:Label>

 

 

</

 

 

div>

 

 

<

 

 

div class="textlabel">

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlShipNoSearch" runat="server"

 

 

 

 

EnableEmbeddedSkins="false" Skin="DMID"

 

 

 

 

onprerender="ddlShipNoSearch_PreRender" onload="ddlShipNoSearch_Load">

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

 

 

 

 

 

 

 

<img src="../App_Themes/DMID/Images/onepix.gif" alt="" width="15px"/>

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlShipNo" runat="server"

 

 

 

 

EnableEmbeddedSkins="False" Skin="DMID"

 

 

 

 

 

 

 

 

 

onprerender="ddlShipNo_PreRender" onload="ddlShipNo_Load" >

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

</

 

 

div>

 

 

<

 

 

div class="labels">

 

 

 

 

 

 

 

 

 

<asp:Label ID="lblClientShip" runat="server" Text="Client Ship #:"></asp:Label>

 

 

</

 

 

div>

 

 

<

 

 

div class="textlabel">

 

 

 

 

 

 

 

 

 

<telerik:RadComboBox ID="ddlClientShip" runat="server" EnableEmbeddedSkins="false"

 

 

 

 

Skin="DMID" onload="ddlClientShip_Load" onprerender="ddlClientShip_PreRender"

 

 

 

 

DataTextField="ClientShip">

 

 

 

 

 

 

 

 

 

</telerik:RadComboBox>

 

 

</

 

 

div>

 

 

<

 

 

div class="labels">

 

 

 

 

 

 

 

 

 

<asp:Label ID="lblStartDate" runat="server" Text="Start Date:"></asp:Label>

 

 

</

 

 

div>

 

 

<

 

 

div class="textlabel">

 

 

 

 

 

 

 

 

 

<telerik:RadDatePicker ID="dtStartDate" runat="server" Skin="DMID" EnableEmbeddedSkins="False">

 

 

<

 

 

Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False"

 

 

 

 

ShowRowHeaders="False"></Calendar>

 

 

<

 

 

DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>

 

 

<

 

 

DateInput DisplayDateFormat="MM/dd/yyyy" DateFormat="MM/dd/yyyy" EnableEmbeddedSkins="False"></DateInput>

 

 

 

 

 

 

 

 

 

</telerik:RadDatePicker>

 

 

 

 

 

 

 

 

 

<asp:Label ID="lblEndDate" runat="server" Text="End Date:"></asp:Label>

 

 

 

 

 

 

 

 

 

<telerik:RadDatePicker ID="dtEndDate" runat="server" Skin="DMID" EnableEmbeddedSkins="False">

 

 

<

 

 

Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False"

 

 

 

 

ShowRowHeaders="False"></Calendar>

 

 

<

 

 

DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>

 

 

<

 

 

DateInput DisplayDateFormat="MM/dd/yyyy" DateFormat="MM/dd/yyyy" EnableEmbeddedSkins="False"></DateInput>

 

 

 

 

 

 

 

 

 

</telerik:RadDatePicker>

 

 

</

 

 

div>

 

 

<

 

 

p style="text-align: center">

 

 

 

 

 

 

 

 

 

<telerik:RadButton ID="btnReport" runat="server" Text="Generate Report"

 

 

 

 

EnableEmbeddedSkins="False" Skin="DMID" onclick="btnReport_Click">

 

 

 

 

 

 

 

 

 

</telerik:RadButton>

 

 

</

 

 

p>

 

 

 

 

<telerik:RadGrid ID="grdInventory" runat="server" EnableEmbeddedSkins="False"

 

 

 

 

Skin="DMID" AllowPaging="True"

 

 

 

 

AutoGenerateColumns="False" CellSpacing="0"

 

 

 

 

ShowFooter="True" ShowStatusBar="True"

 

 

 

 

 

 

 

 

 

PageSize="20"

 

 

 

 

 

 

 

 

 

onneeddatasource="grdInventory_NeedDataSource"

 

 

 

 

GridLines="None" >

 

 

<

 

 

HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default" ></HeaderContextMenu>

 

 

 

 

 

 

 

 

 

<ExportSettings ExportOnlyData="True" FileName="ProductInventory" OpenInNewWindow="True" >

 

 

 

 

 

 

 

 

 

</ExportSettings>

 

 

 

 

 

 

 

 

 

<PagerStyle AlwaysVisible="True" Mode="NumericPages" />

 

 

<

 

 

MasterTableView CommandItemDisplay="Top" UseAllDataFields="true" GroupLoadMode="Server" TableLayout="Fixed">

 

 

<

 

 

CommandItemSettings ShowAddNewRecordButton="False"

 

 

 

 

ShowExportToExcelButton="True" ShowRefreshButton="False">

 

 

</

 

 

CommandItemSettings>

 

 

 

 

 

 

 

 

 

<CommandItemStyle HorizontalAlign="Right" />

 

 

 

 

 

 

 

 

 

<CommandItemTemplate >

 

 

 

 

 

 

 

 

 

<asp:ImageButton ID="imgbtnExcel" runat="server" ImageUrl="~/App_Themes/DMID/Images/Excel.gif" OnClick="imgbtnExcel_Click" />

 

 

</

 

 

CommandItemTemplate>

 

 

 

 

 

 

 

 

 

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

 

 

<

 

 

HeaderStyle HorizontalAlign="Center" Font-Bold="True"></HeaderStyle>

 

 

</

 

 

RowIndicatorColumn>

 

 

<

 

 

ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

 

 

</

 

 

ExpandCollapseColumn>

 

 

 

 

 

 

 

 

 

<Columns>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="ShipmentNumber"

 

 

 

 

 

 

 

 

 

FilterControlAltText="Filter ShipmentNumber column"

 

 

 

 

HeaderText="FBS Ship #"

 

 

 

 

UniqueName="ShipmentNumber" DataType="System.String"

 

 

 

 

SortExpression="ShipmentNumber" >

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="70px" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="ShipDate"

 

 

 

 

FilterControlAltText="Filter ShipDate column"

 

 

 

 

HeaderText="Date"

 

 

 

 

 

 

 

 

 

UniqueName="ShipDate" DataType="System.DateTime" DataFormatString="{0:d}"

 

 

 

 

 

 

 

 

 

SortExpression="ShipDate" >

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="40px" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="ProtocolID"

 

 

 

 

FilterControlAltText="Filter ProtocolID column"

 

 

 

 

HeaderText="Protocol #" SortExpression="ProtocolID"

 

 

 

 

 

 

 

 

 

UniqueName="ProtocolID" DataType="System.String" >

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="40px" HorizontalAlign="Center"/>

 

 

 

 

 

 

 

 

 

<ItemStyle HorizontalAlign="Center" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="ClientShip"

 

 

 

 

SortExpression="ClientShip" HeaderText="Client Ship #"

 

 

 

 

UniqueName="ClientShip" DataType="System.String" >

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="90px" HorizontalAlign="Center"/>

 

 

 

 

 

 

 

 

 

<ItemStyle HorizontalAlign="Center" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="ShipTo"

 

 

 

 

SortExpression="ShipTo"

 

 

 

 

 

 

 

 

 

HeaderText="Shipped To" ShowSortIcon="False"

 

 

 

 

UniqueName="ShipTo" DataType="System.String">

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="200px" HorizontalAlign="Center"/>

 

 

 

 

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="ShipAddress"

 

 

 

 

FilterControlAltText="Filter ShipAddress column" HeaderText="Ship To Address"

 

 

 

 

SortExpression="ShipAddress" UniqueName="ShipAddress">

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="200px" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="Product"

 

 

 

 

SortExpression="Product"

 

 

 

 

 

 

 

 

 

FilterControlAltText="Filter Product column"

 

 

 

 

 

 

 

 

 

HeaderText="Product" ShowSortIcon="False"

 

 

 

 

UniqueName="Product">

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="200px" HorizontalAlign="Center"/>

 

 

 

 

 

 

 

 

 

<ItemStyle HorizontalAlign="Left" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="PackUnit"

 

 

 

 

SortExpression="PackUnit"

 

 

 

 

 

 

 

 

 

FilterControlAltText="Filter PackUnit column"

 

 

 

 

 

 

 

 

 

HeaderText="Packaging Unit" ShowSortIcon="False"

 

 

 

 

UniqueName="PackUnit" >

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="60px" HorizontalAlign="Center" />

 

 

 

 

 

 

 

 

 

<ItemStyle HorizontalAlign="Center" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="Investigator"

 

 

 

 

FilterControlAltText="Filter Investigator column"

 

 

 

 

 

 

 

 

 

SortExpression="Investigator"

 

 

 

 

HeaderText="Investigator Name" ShowSortIcon="False"

 

 

 

 

UniqueName="Investigator">

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="60px" HorizontalAlign="Center"/>

 

 

 

 

 

 

 

 

 

<ItemStyle HorizontalAlign="Center" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="StockNumber" SortExpression="StockNumber" HeaderText="FBS Stock #"

 

 

 

 

ShowSortIcon="False" UniqueName="StockNumber" DataType="System.String">

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="70px" HorizontalAlign="Center"/>

 

 

 

 

 

 

 

 

 

<ItemStyle HorizontalAlign="Center" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="Lot" HeaderText="Lot #"

 

 

 

 

UniqueName="Lot" SortExpression="Lot" >

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="60px" HorizontalAlign="Center"/>

 

 

 

 

 

 

 

 

 

<ItemStyle HorizontalAlign="Center" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

<telerik:GridBoundColumn DataField="QtyShipped" SortExpression="QtyShipped"

 

 

 

 

 

 

 

 

 

HeaderText="Qty Shipped" UniqueName="QtyShipped" DataType="System.String">

 

 

 

 

 

 

 

 

 

<HeaderStyle Width="40px" HorizontalAlign="Center"/>

 

 

 

 

 

 

 

 

 

<ItemStyle HorizontalAlign="Center" />

 

 

 

 

 

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

 

 

 

 

 

</Columns>

 

 

 

 

 

 

 

 

 

<GroupByExpressions>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByExpression>

 

 

 

 

 

 

 

 

 

<SelectFields>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByField FieldName="ShipmentNumber" HeaderText="FBS Ship#"></telerik:GridGroupByField>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByField FieldName="ShipDate" HeaderText="Date" FormatString="{0:d}" ></telerik:GridGroupByField>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByField FieldName="ProtocolID" HeaderText="Protocol #" ></telerik:GridGroupByField>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByField FieldName="ClientShip" HeaderText="Client Ship #" ></telerik:GridGroupByField>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByField FieldName="ShipTo" HeaderText="Shipped To"></telerik:GridGroupByField>

 

 

 

 

 

 

 

 

 

</SelectFields>

 

 

 

 

 

 

 

 

 

<GroupByFields>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByField FieldName="ShipmentNumber" SortOrder="Ascending" ></telerik:GridGroupByField>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByField FieldName="ShipDate" HeaderText="Date" ></telerik:GridGroupByField>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByField FieldName="ProtocolID" HeaderText="Protocol #"></telerik:GridGroupByField>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByField FieldName="ClientShip" HeaderText="Client Ship #" ></telerik:GridGroupByField>

 

 

 

 

 

 

 

 

 

<telerik:GridGroupByField FieldName="ShipTo" HeaderText="Shipped To" ></telerik:GridGroupByField>

 

 

 

 

 

 

 

 

 

</GroupByFields>

 

 

 

 

 

 

 

 

 

</telerik:GridGroupByExpression>

 

 

 

 

 

 

 

 

 

</GroupByExpressions>

 

 

<

 

 

EditFormSettings>

 

 

<

 

 

EditColumn FilterControlAltText="Filter EditCommandColumn column"

 

 

 

 

CancelImageUrl="Cancel.gif" EditImageUrl="Edit.gif" InsertImageUrl="Update.gif"

 

 

 

 

UpdateImageUrl="Update.gif"></EditColumn>

 

 

</

 

 

EditFormSettings>

 

 

<

 

 

PagerStyle AlwaysVisible="True" PageButtonCount="20"></PagerStyle>

 

 

</

 

 

MasterTableView>

 

 

 

 

 

 

 

 

 

<HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="10%" />

 

 

 

 

 

 

 

 

 

<ClientSettings AllowGroupExpandCollapse="True" ReorderColumnsOnClient="True" AllowDragToGroup="True"

 

 

 

 

 

 

 

 

 

AllowColumnsReorder="True">

 

 

 

 

 

 

 

 

 

</ClientSettings>

 

 

<

 

 

FilterMenu EnableImageSprites="False"></FilterMenu>

 

 

 

 

 

 

 

 

 

</telerik:RadGrid>

 

 

telerik

 

:RadAjaxManager ID="RadAjaxManager1" runat="server"

 

 

 

 

DefaultLoadingPanelID="RadAjaxLoadingPanel1">

 

 

 

 

 

 

 

 

 

<ClientEvents OnRequestStart="RequestStarted" />

 

 

 

 

 

 

 

 

 

<AjaxSettings>

 

 

 

 

 

 

 

 

 

<telerik:AjaxSetting AjaxControlID="btnReport">

 

 

 

 

 

 

 

 

 

<UpdatedControls>

 

 

 

 

 

 

 

 

 

<telerik:AjaxUpdatedControl ControlID="grdInventory"

 

 

 

 

LoadingPanelID="RadAjaxLoadingPanel1" />

 

 

 

 

 

 

 

 

 

</UpdatedControls>

 

 

 

 

 

 

 

 

 

</telerik:AjaxSetting>

 

 

 

 

 

 

 

 

 

<telerik:AjaxSetting AjaxControlID="grdInventory">

 

 

 

 

 

 

 

 

 

<UpdatedControls>

 

 

 

 

 

 

 

 

 

<telerik:AjaxUpdatedControl ControlID="grdInventory"

 

 

 

 

LoadingPanelID="RadAjaxLoadingPanel1" />

 

 

 

 

 

 

 

 

 

</UpdatedControls>

 

 

 

 

 

 

 

 

 

</telerik:AjaxSetting>

 

 

 

 

 

 

 

 

 

</AjaxSettings>

 

 

 

 

 

 

 

 

 

</telerik:RadAjaxManager>

 

 

 

 

 

 

 

 

 

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Web20">

 

 

 

 

 

 

 

 

 

</telerik:RadAjaxLoadingPanel>

 

Vasil
Telerik team
 answered on 07 Apr 2011
3 answers
120 views
Hi,

I have a page that has a normal asp button and a radgrid. My radgrid uses the NeedDataSource command which is used because my radgrid has paging. However, when my page loads, the needdatasource will trigger and bind my radgrid with data. Is there any way I can load my page and not have the grid bind anything until the user clicks the button thats on my page?

In other words when the page is loaded, the radgrid will be empty, and only have data when the user clicks the button. It works if I remove the needdatasource, but I need this because of my paging. Any advice?

Thanks!
Daniel
Telerik team
 answered on 07 Apr 2011
3 answers
204 views
I need a grid where all rows are in Edit Mode. Then I want  with Update button all rows to updateWhat should I add in code-behind?
<body>
    <form id="form1" runat="server">
    <div>
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        </telerik:RadScriptManager>
        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
            <AjaxSettings>
                <telerik:AjaxSetting AjaxControlID="RadGrid1">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                    </UpdatedControls>
                </telerik:AjaxSetting>
            </AjaxSettings>
        </telerik:RadAjaxManager>
 
 
 
 
<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticUpdates="True"
            CellSpacing="0" DataSourceID="SqlDataSource1" GridLines="None">
<MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Top" DataKeyNames="id"
                DataSourceID="SqlDataSource1">
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
 
<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
 
<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
 
    <Columns>
        <telerik:GridBoundColumn DataField="id" DataType="System.Int32"
            FilterControlAltText="Filter id column" HeaderText="id" ReadOnly="True"
            SortExpression="id" UniqueName="id">
        </telerik:GridBoundColumn>
        <telerik:GridTemplateColumn FilterControlAltText="Filter TemplateColumn column"
            HeaderText="f1" UniqueName="f1">
            <ItemTemplate>
                <telerik:RadTextBox ID="RadTextBox1" Runat="server" Text='<%# Bind("f1") %>'
                    Width="125px">
                </telerik:RadTextBox>
            </ItemTemplate>
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn FilterControlAltText="Filter TemplateColumn1 column"
            HeaderText="f2" UniqueName="f2">
            <ItemTemplate>
                <telerik:RadNumericTextBox ID="RadNumericTextBox1" Runat="server"
                    Culture="de-DE" DbValue='<%# Bind("f2") %>' Width="125px">
                </telerik:RadNumericTextBox>
            </ItemTemplate>
        </telerik:GridTemplateColumn>
    </Columns>
 
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
    <CommandItemTemplate>
         <asp:LinkButton ID="btnUpdateEdited" runat="server" CommandName="UpdateEdited" >Update</asp:LinkButton>
    </CommandItemTemplate>
</MasterTableView>
 
<FilterMenu EnableImageSprites="False"></FilterMenu>
 
<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>
        </telerik:RadGrid>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:webzeus %>"
            SelectCommand="SELECT * FROM [TestTable]"
            UpdateCommand="UPDATE [TestTable] SET [f1] = @f1, [f2] = @f2  WHERE [id] = @original_id ">
            <UpdateParameters>
                <asp:Parameter Name="f1" Type="String" />
                <asp:Parameter Name="f2" Type="Int16" />
                <asp:Parameter Name="original_id" Type="Int16" />
            </UpdateParameters>           
            </asp:SqlDataSource>
    </div>
    </form>
</body>
Thanks, Evgeny
Princy
Top achievements
Rank 2
 answered on 07 Apr 2011
2 answers
149 views
I am trying to change the color of a disabled rad tree node to something other then the default.  I attempted the following

.Custom{
    color:red !important;
}
 
Protected Sub rtvNav_NodeDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadTreeNodeEventArgs) Handles rtvNav.NodeDataBound
        e.Node.Enabled = False
        e.Node.DisabledCssClass = "Custom"
    End Sub

but this did not override the color, i.e. the node is still gray.  I found the following post http://www.telerik.com/community/forums/aspnet-ajax/treeview/disabled-node-font-color.aspx but it is almost two years old and not sure if it still applies.  The solution is problematic for me as well.  The solution says to define 

.RadTreeView_Default .rtDisabled .rtIn
{
    color: black !important;
}

Problems:
1.  The user is allowed to select their own theme so I'd have to define this for all of Telerik's themes
2.  I only want to apply this to a specific tree in my application and not all the trees in my application.  There could be multiple trees on the same page, one with the new style, and multiple that should behave in the default way (i.e. disabled nodes grey).

What can I do to get disabled nodes to color differently in one situation and not the next?
Nikolay Tsenkov
Telerik team
 answered on 07 Apr 2011
2 answers
187 views
I'm seeing some weird behavior with the SelectedValue in the RadComboBox not being properly rendered as "selected" when the page is initially loaded.  Instead of the SelectedValue being shown in the dropdown menu, the first item in the RadComboBox is "selected."  Through debugging, I have verified that the SelectedValue propery *is* set correctly when the page loads.  Additionally, if I click on the combobox and click off, it scrolls down to the correct value and selects it.  Therefore, I don't think it's an issue with the SelectedValue property not getting set.  I think it's an issue with the HTML and java-script not rendering the control properly on the initial page load.

To give some context, this RadComboBox is inside of a User Control that gets dynamically loaded into a RadTabStrip/RadMultiPage at runtime.  The issue happens regardless of whether the RadComboBox is populated/bound directly on the ascx control or programatically on the code-behind for the control.

From the DOM inspector built into Firefox, here is the HTML source of the control when I first click on the tab for this page:

    <div id="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId" class="RadComboBox RadComboBox_Web20" skinspath="~/RadControls/ComboBox/Skins" style="width: 150px;">
    <table class="" summary="combobox" style="border-width: 0pt; border-collapse: collapse;">
        <tbody><tr>
            <td style="width: 100%;" class="rcbInputCell rcbInputCellLeft"><input autocomplete="off" name="ctl00$bodyContent$beneficiaryinfo$ddlJurisdictionId" class="rcbInput" id="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId_Input" value="(select one)" type="text"></td>
            <td class="rcbArrowCell rcbArrowCellRight"><a id="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId_Arrow" style="overflow: hidden; display: block; position: relative; outline: medium none;">select</a></td>
 
        </tr>
    </tbody></table>
    <div class="rcbSlide" style="z-index: 6000;"><div id="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId_DropDown" class="RadComboBoxDropDown RadComboBoxDropDown_Web20 " style="display: none;"><div class="rcbScroll rcbWidth" style="height: 100px; width: 100%;"><ul class="rcbList" style="list-style: none outside none; margin: 0pt; padding: 0pt;"><li class="rcbItem ">(select one)</li><li class="rcbItem ">None</li><li class="rcbItem ">Alabama</li><li class="rcbItem ">Alaska</li><li class="rcbItem ">Arizona</li><li class="rcbItem ">Arkansas</li><li class="rcbItem ">California</li><li class="rcbItem ">Colorado</li><li class="rcbItem ">Connecticut</li><li class="rcbItem ">Delaware</li><li class="rcbItem ">District of Columbia</li><li class="rcbItem ">Florida</li><li class="rcbItem ">Georgia</li><li class="rcbItem ">Hawaii</li><li class="rcbItem ">Idaho</li><li class="rcbItem ">Illinois</li><li class="rcbItem ">Indiana</li><li class="rcbItem ">Iowa</li><li class="rcbItem ">Kansas</li><li class="rcbItem ">Kentucky</li><li class="rcbItem ">Louisiana</li><li class="rcbItem ">Maine</li><li class="rcbItem ">Maryland</li><li class="rcbItem ">Massachusetts</li><li class="rcbItem ">Michigan</li><li class="rcbItem ">Minnesota</li><li class="rcbItem ">Mississippi</li><li class="rcbItem ">Missouri</li><li class="rcbItem ">Montana</li><li class="rcbItem ">Nebraska</li><li class="rcbItem ">Nevada</li><li class="rcbItem ">New Hampshire</li><li class="rcbItem ">New Jersey</li><li class="rcbItem ">New Mexico</li><li class="rcbItem ">New York</li><li class="rcbItem ">North Carolina</li><li class="rcbItem ">North Dakota</li><li class="rcbItem ">Ohio</li><li class="rcbItem ">Oklahoma</li><li class="rcbItem ">Oregon</li><li class="rcbItem ">Pennsylvania</li><li class="rcbItem ">Rhode Island</li><li class="rcbItem ">South Carolina</li><li class="rcbItem ">South Dakota</li><li class="rcbItem ">Tennessee</li><li class="rcbItem ">Texas</li><li class="rcbItem ">Utah</li><li class="rcbItem ">Vermont</li><li class="rcbItem ">Virginia</li><li class="rcbItem ">Washington</li><li class="rcbItem ">West Virginia</li><li class="rcbItem ">Wisconsin</li><li class="rcbItem ">Wyoming</li></ul></div></div></div><input value="{"logEntries":[],"value":"34","text":"(select one)","enabled":true}" autocomplete="off" id="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId_ClientState" name="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId_ClientState" type="hidden">
 
</div>


Here is the HTML source of the control if I simply click on the combobox and then click off (without selecting a new value):

    <div id="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId" class="RadComboBox RadComboBox_Web20" skinspath="~/RadControls/ComboBox/Skins" style="width: 150px;">
    <table class="" summary="combobox" style="border-width: 0pt; border-collapse: collapse;">
        <tbody><tr>
            <td style="width: 100%;" class="rcbInputCell rcbInputCellLeft"><input autocomplete="off" name="ctl00$bodyContent$beneficiaryinfo$ddlJurisdictionId" class="rcbInput" id="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId_Input" value="(select one)" type="text"></td>
            <td class="rcbArrowCell rcbArrowCellRight"><a id="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId_Arrow" style="overflow: hidden; display: block; position: relative; outline: medium none;">select</a></td>
 
        </tr>
    </tbody></table>
    <input value="{"logEntries":[],"value":"","text":"Nebraska","enabled":true}" autocomplete="off" id="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId_ClientState" name="ctl00_bodyContent_beneficiaryinfo_ddlJurisdictionId_ClientState" type="hidden">
</div>

Notice how "Nebraska" (the SelectedValue in this case) is properly selected as the state in the 2nd example.

Here is the code that is setting the SelectedValue:

if (ddlJurisdictionId.Items.FindItemByValue(JurisdictionId.ToString()) != null)
{
    ddlJurisdictionId.SelectedValue = JurisdictionId.ToString();
}
else
{
    ddlJurisdictionId.Items[0].Selected = true;
}

I am seeing this exact behavior in *every* browser I've tried (IE8, Firefox 3.6.8, Chrome 10.0.648.133).  I am developing using version 2011_1_315 of the RadControls.  If I use an asp.net DropDownList in place of the RadComboBox, this issue does *not* happen.

Any ideas what would cause this?
Dimitar Terziev
Telerik team
 answered on 07 Apr 2011
2 answers
121 views
Hi,
I'm having trouble with AJAX (yet again).
I have a RadAjaxManager on the master page which is meant to ajaxify a panel:
<telerik:RadAjaxManager ID="DarRadAjaxManager" DefaultLoadingPanelID="DarRadAjaxLoadingPanel" runat="server">       
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="MainPagePanel">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="MainPagePanel" />
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManager>

Inside the panel is a RadTabstrip which has a SiteMap as a Datasource:
<asp:Panel ID="MainPagePanel" CssClass="mainBody" runat="server">
    <telerik:RadTabStrip ID="DARRadTabStrip" runat="server" DataSourceID="ApplicationSiteMap" CausesValidation="false">
    </telerik:RadTabStrip>
 
    <asp:SiteMapDataSource ID="ApplicationSiteMap" runat="server"
                            SiteMapProvider="XmlSiteMapProvider"
                            ShowStartingNode="False" />
 
    <asp:ContentPlaceHolder id="MainContentPlaceHolder" runat="server">
    </asp:ContentPlaceHolder>
</asp:Panel>

It all works fine. There's just no ajax. A quick call to the IsAjaxRequest method of the RadAjaxManager proved that.

How can I get that working with Ajax?
David
Top achievements
Rank 1
 answered on 07 Apr 2011
14 answers
1.6K+ views
Hello,

I am using the 

telerik:RadAjaxManager

in my main.aspx page which, in turn, loads usercontrols. In my usercontrol I have a 

RadTabStrip

which also calls other usercontrols which i also want  AJAXified. So I'm trying the RadAjaxManagerProxy but as soon as I put in my user control I get this error message:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Collection was modified; enumeration operation may not execute.

Any clues?

Thank you

Bodevain Svensson
Top achievements
Rank 1
 answered on 07 Apr 2011
2 answers
249 views
Is it possible to add an event handler to the grid (e.g. for the RowSelected event) from the client-side javascript?

Example:

<telerik:RadGrid ID="grid" runat="server" ...>
    ...
    <ClientSettings>
        <ClientEvents OnGridCreated="gridCreated" />
    </ClientSettings>
</telerik:RadGrid>
...
<script>
function gridCreated(sender, eventArgs) {
    if (someCondition) {
        //
        Can I add function rowSelected() as a handler to
        the grid's OnRowSelected event?
        //
    }
}
 
function rowSelected(sender, eventArgs) {
    // do stuff
}

I tried calling the grid's add_rowSelected() function, but couldn't get it to work.
Thanks for your help.

-Martin
Martin
Top achievements
Rank 1
 answered on 07 Apr 2011
1 answer
118 views
What I have is a grid that I am loading questions with a asp radiobutton with a go or a no\go.  I have a set of questions and then some question might have sub questions that i load into the grid.  a nested radgrid with the main question and sub questions.  What I need to happen if a sub question radio button is picked as a no\go I need the main question button to automatically be changed to a no\go as well.  Is this possible with a nested grid.  Here is an example of my radgrid.  I also need to save all of them to a table with the question answer on a asp submit button, how do you itterate through the main and then sub tables to save the information.


<table width="100%">
                <tr>
                    <td align="center"><telerik:RadGrid ID="RadGrid2" runat="server" CellSpacing="0" GridLines="both" Skin="WebBlue" Width="90%" GroupingSettings-ShowUnGroupButton="false"  >
                        <MasterTableView AutoGenerateColumns="false" DataKeyNames="intQuestionID">
                            <Columns>
                                <telerik:GridBoundColumn DataField="strQuestion" HeaderText="Question" UniqueName="strQuestion" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Left" />
                                <telerik:GridTemplateColumn HeaderText="GO\NOGO" HeaderStyle-HorizontalAlign="Center" ShowSortIcon="True" Visible="True">
                                    <ItemTemplate>
                                        <asp:RadioButtonList ID="rblAnswer" runat="server" RepeatDirection="Horizontal" TextAlign="Right" CellPadding="5" >
                                            <asp:ListItem Value="0">GO</asp:ListItem>
                                            <asp:ListItem Value="1">NO\GO</asp:ListItem>
                                        </asp:RadioButtonList>
                                    </ItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn HeaderText="Data" HeaderStyle-HorizontalAlign="Center">
                                    <ItemTemplate>
                                        <telerik:RadTextBox runat="server" Width="100"></telerik:RadTextBox>
                                    </ItemTemplate>
                                </telerik:GridTemplateColumn>
                                 <telerik:GridTemplateColumn HeaderText="Remarks" HeaderStyle-HorizontalAlign="Center">
                                    <ItemTemplate>
                                        <telerik:RadTextBox ID="txtRemarks" runat="server" Width="100"></telerik:RadTextBox>
                                    </ItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridTemplateColumn HeaderText="Date" HeaderStyle-HorizontalAlign="Center">
                                      <ItemTemplate>
                                        <telerik:RadDatePicker ID="radDate" runat="server"></telerik:RadDatePicker>
                                      </ItemTemplate>
                                </telerik:GridTemplateColumn>
                            </Columns>
                            <DetailTables>
                                <telerik:GridTableView Name="RadGrid2Sub" runat="server" DataKeyNames="intsubQID" TableLayout="Fixed" AutoGenerateColumns="false">
                                    <ParentTableRelation>
                                        <telerik:GridRelationFields DetailKeyField="intQuestionID" MasterKeyField="intQuestionID" />
                                    </ParentTableRelation>
                                    <Columns>
                                        <telerik:GridBoundColumn DataField="strSubQ" HeaderText="Sub-Question" UniqueName="strSubQ" HeaderStyle-HorizontalAlign="Center" />
                                         <telerik:GridTemplateColumn HeaderText="GO\NOGO" HeaderStyle-HorizontalAlign="Center" ShowSortIcon="True" Visible="True">
                                            <ItemTemplate>
                                                <asp:RadioButtonList ID="rblAnswer2" runat="server" RepeatDirection="Horizontal" TextAlign="Right" CellPadding="5" >
                                                    <asp:ListItem Value="0">GO</asp:ListItem>
                                                    <asp:ListItem Value="1">NO\GO</asp:ListItem>
                                                </asp:RadioButtonList>
                                            </ItemTemplate>
                                        </telerik:GridTemplateColumn>
                                    </Columns>
                                    </telerik:GridTableView>
                            </DetailTables>
                        </MasterTableView>
                    </telerik:RadGrid></td>
                </tr>
            </table>
Marin
Telerik team
 answered on 07 Apr 2011
Narrow your results
Selected tags
Tags
+? more
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?