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

[Solved] Inserting data into a radgrid inside a nestedviewtemplate

5 Answers 272 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Ken Miller
Top achievements
Rank 1
Ken Miller asked on 05 Mar 2010, 03:46 PM
I am trying to insert data into a radgrid that is nested inside another radgrid.  The problem I am having is getting the ID from the master table. the solution I tried looks like this:

 protected void ImagesLDS_Inserting(object sender, LinqDataSourceInsertEventArgs e)
    {
        Image i = (Image)e.NewObject;
        i.ItemID = Convert.ToInt32(ItemGrid.MasterTableView.DataKeyValues[0]["ItemID"]);
    }

I thought this was working, but it seems ItemGrid.MasterTableView.DataKeyValues[0]["ItemID"] is always equal to 1.

Here is the markup for the grids:
<telerik:RadGrid ID="ItemGrid" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" 
                AllowAutomaticUpdates="True" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" 
                DataSourceID="ItemsLDS" GridLines="None" Skin="WebBlue" AllowPaging="True"
                <MasterTableView AutoGenerateColumns="False" DataKeyNames="ItemID" DataSourceID="ItemsLDS" 
                    CommandItemDisplay="Top"
                    <RowIndicatorColumn> 
                        <HeaderStyle Width="20px"></HeaderStyle> 
                    </RowIndicatorColumn> 
                    <NestedViewTemplate> 
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("ItemID") %>' Visible="False"></asp:Label> 
                        <asp:LinqDataSource ID="ImagesLDS" runat="server" ContextTypeName="CatalystDataContext" 
                            TableName="Images" Where="ItemID == @ItemID" EnableDelete="True" EnableInsert="True" 
                            EnableUpdate="True" OnInserting="ImagesLDS_Inserting"
                            <WhereParameters> 
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" Type="Int32" /> 
                            </WhereParameters> 
                        </asp:LinqDataSource>                         
                        <table> 
                            <tr> 
                                <td valign="top"
                                    <telerik:RadGrid ID="ImagesGrid" runat="server" DataSourceID="ImagesLDS" GridLines="None" 
                                        AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" 
                                        AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" HorizontalAlign="Left" 
                                        Skin="WebBlue"
                                        <MasterTableView DataSourceID="ImagesLDS" AutoGenerateColumns="False" DataKeyNames="ImageID" 
                                            CommandItemDisplay="Bottom" EditMode="InPlace"
                                            <RowIndicatorColumn> 
                                                <HeaderStyle Width="20px" /> 
                                            </RowIndicatorColumn> 
                                            <ExpandCollapseColumn> 
                                                <HeaderStyle Width="20px" /> 
                                            </ExpandCollapseColumn> 
                                            <CommandItemSettings AddNewRecordText="Add New Image" /> 
                                            <Columns> 
                                                <telerik:GridBoundColumn DataField="ImageID" DataType="System.Int32" HeaderText="ImageID" 
                                                    ReadOnly="True" SortExpression="ImageID" UniqueName="ImageID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32" HeaderText="ItemID" 
                                                    SortExpression="ItemID" UniqueName="ItemID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridTemplateColumn DataField="ImageURL" HeaderText="Image" SortExpression="ImageURL" 
                                                    UniqueName="ImageURL"
                                                    <EditItemTemplate> 
                                                        <asp:TextBox ID="ImageURLTextBox" runat="server" Text='<%# Bind("ImageURL") %>'></asp:TextBox> 
                                                    </EditItemTemplate> 
                                                    <ItemTemplate> 
                                                        <asp:Image ID="Image1" runat="server" AlternateText='<%# Eval("Description") %>' 
                                                            Height="50px" ImageAlign="AbsMiddle" ImageUrl='<%# Eval("ImageURL") %>' Width="50px" /> 
                                                    </ItemTemplate> 
                                                </telerik:GridTemplateColumn> 
                                                <telerik:GridBoundColumn DataField="Description" HeaderText="Alt. Text" SortExpression="Description" 
                                                    UniqueName="Description"
                                                </telerik:GridBoundColumn> 
                                            </Columns> 
                                        </MasterTableView> 
                                    </telerik:RadGrid> 
                                </td> 
                                 
                            </tr> 
                        </table> 
                    </NestedViewTemplate> 

There are other grids and LinqDataSources that have the dame issue. I would like to use the Label1 but I am not sure how to access it.


5 Answers, 1 is accepted

Sort by
0
Ken Miller
Top achievements
Rank 1
answered on 05 Mar 2010, 06:57 PM
I have tried to use the insert parameter on the datasource:
<NestedViewTemplate> 
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("ItemID") %>' Visible="False"></asp:Label> 
                        <asp:LinqDataSource ID="ImagesLDS" runat="server" ContextTypeName="CatalystDataContext" 
                            TableName="Images" Where="ItemID == @ItemID" EnableDelete="True" EnableInsert="True" 
                            EnableUpdate="True" OnInserting="ImagesLDS_Inserting1"
                            <WhereParameters> 
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" Type="Int32" /> 
                            </WhereParameters> 
                            <InsertParameters> 
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" Type="Int32" /> 
                            </InsertParameters> 
                        </asp:LinqDataSource> 
But this fails.  If I add a default value, it works. but that obviously isn't helpful
0
Princy
Top achievements
Rank 2
answered on 09 Mar 2010, 07:41 AM
Hi,

Please take a look at how I have implemented a similar scenario. I have set the Insert Parameter as the label .

ASPX:
 <asp:LinqDataSource ID="ProductLDS" runat="server" ContextTypeName="DataClassesDataContext" 
            TableName="Products" Select="new (ProductId, Name, Descn)"
        </asp:LinqDataSource> 
        <telerik:RadGrid ID="RadGrid1" DataSourceID="ProductLDS" AllowSorting="True" GridLines="None" 
            runat="server"
            <MasterTableView DataKeyNames="ProductId" TableLayout="Fixed" DataSourceID="ProductLDS"  Name="Master" Width="100%"
                <NestedViewTemplate> 
                    <asp:Label ID="Label1" runat="server" Style="display: none;" Text='<%#Eval("ProductId") %>'></asp:Label> 
                    <asp:LinqDataSource ID="ItemLDS" runat="server" ContextTypeName="DataClassesDataContext" 
                        TableName="Items" Where="ProductId == @ProductId" EnableDelete="True" EnableInsert="True" 
                        EnableUpdate="True"  > 
                        <WhereParameters> 
                            <asp:ControlParameter ControlID="Label1" Name="ProductId" PropertyName="Text" /> 
                        </WhereParameters> 
                        <InsertParameters> 
                            <asp:ControlParameter ControlID="Label1" Name="ProductId" PropertyName="Text" /> 
                        </InsertParameters> 
                    </asp:LinqDataSource> 
                    <telerik:RadGrid AutoGenerateColumns="false" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" AllowAutomaticDeletes="true" ID="RadGrid2" DataSourceID="ItemLDS" runat="server"
                        <MasterTableView CommandItemDisplay="Top" TableLayout="Fixed" Width="100%"
                        <Columns> 
                        <telerik:GridBoundColumn DataField="ItemId"></telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="ListPrice"></telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="Name"></telerik:GridBoundColumn> 
                        </Columns> 
                        </MasterTableView> 
                    </telerik:RadGrid> 
                </NestedViewTemplate> 
            </MasterTableView> 
        </telerik:RadGrid> 


Hope this helps.

Thanks,
Princy
0
Ken Miller
Top achievements
Rank 1
answered on 09 Mar 2010, 04:06 PM
This does not work for me.  Here is the code I tried, maybe someone can find what I'm doing wrong.
<MasterTableView AutoGenerateColumns="False" DataKeyNames="ItemID" DataSourceID="ItemsLDS" 
                    CommandItemDisplay="Top"
                    <RowIndicatorColumn> 
                        <HeaderStyle Width="20px"></HeaderStyle> 
                    </RowIndicatorColumn> 
                    <NestedViewTemplate> 
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("ItemID") %>'></asp:Label> 
                        <asp:LinqDataSource ID="ImagesLDS" runat="server" ContextTypeName="CatalystDataContext" 
                            TableName="Images" Where="ItemID == @ItemID" EnableDelete="True" EnableInsert="True" 
                            EnableUpdate="True"
                            <WhereParameters> 
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" Type="Int32" /> 
                            </WhereParameters> 
                            <InsertParameters> 
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" /> 
                            </InsertParameters> 
                        </asp:LinqDataSource> 
                        <asp:LinqDataSource ID="ItemChoiceLDS" runat="server" ContextTypeName="CatalystDataContext" 
                            TableName="ItemChoices" Where="ItemID == @ItemID" EnableDelete="True" EnableInsert="True" 
                            EnableUpdate="True" OnInserting="ItemChoiceLDS_Inserting"
                            <WhereParameters> 
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" Type="Int32" /> 
                            </WhereParameters> 
                        </asp:LinqDataSource> 
                        <asp:LinqDataSource ID="OptionLDS" runat="server" ContextTypeName="CatalystDataContext" 
                            EnableDelete="True" EnableInsert="True" EnableUpdate="True" TableName="Options" 
                            Where="ItemID == @ItemID" OnInserting="OptionLDS_Inserting"
                            <WhereParameters> 
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" Type="Int32" /> 
                            </WhereParameters> 
                        </asp:LinqDataSource> 
                        <asp:LinqDataSource ID="PriceBreakLDS" runat="server" ContextTypeName="CatalystDataContext" 
                            EnableDelete="True" EnableInsert="True" EnableUpdate="True" TableName="PriceBreaks" 
                            Where="ItemID == @ItemID" OnInserting="PriceBreakLDS_Inserting"
                            <WhereParameters> 
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" Type="Int32" /> 
                            </WhereParameters> 
                        </asp:LinqDataSource> 
                        <asp:LinqDataSource ID="SubcategoryLDS" runat="server" ContextTypeName="CatalystDataContext" 
                            EnableDelete="True" EnableInsert="True" EnableUpdate="True" TableName="ItemSubCategories" 
                            Where="ItemID == @ItemID" OnInserting="SubcategoryLDS_Inserting"
                            <WhereParameters> 
                                <asp:ControlParameter ControlID="Label1" Name="ItemID" PropertyName="Text" Type="Int32" /> 
                            </WhereParameters> 
                        </asp:LinqDataSource> 
                        <asp:LinqDataSource ID="ChoiceLDS" runat="server" ContextTypeName="CatalystDataContext" 
                            EnableDelete="True" EnableInsert="True" EnableUpdate="True" TableName="Choices" 
                            Where="ItemChoiceID == @ItemChoiceID"
                            <WhereParameters> 
                                <asp:Parameter Name="ItemChoiceID" Type="Int32" /> 
                            </WhereParameters> 
                        </asp:LinqDataSource> 
                        <table> 
                            <tr> 
                                <td valign="top"
                                    <telerik:RadGrid ID="ImagesGrid" runat="server" DataSourceID="ImagesLDS" GridLines="None" 
                                        AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" 
                                        AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" HorizontalAlign="Left" 
                                        Skin="WebBlue"
                                        <MasterTableView DataSourceID="ImagesLDS" AutoGenerateColumns="False" DataKeyNames="ImageID" 
                                            CommandItemDisplay="Bottom" EditMode="InPlace"
                                            <RowIndicatorColumn> 
                                                <HeaderStyle Width="20px" /> 
                                            </RowIndicatorColumn> 
                                            <ExpandCollapseColumn> 
                                                <HeaderStyle Width="20px" /> 
                                            </ExpandCollapseColumn> 
                                            <CommandItemSettings AddNewRecordText="Add New Image" /> 
                                            <Columns> 
                                                <telerik:GridBoundColumn DataField="ImageID" DataType="System.Int32" HeaderText="ImageID" 
                                                    ReadOnly="True" SortExpression="ImageID" UniqueName="ImageID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32" HeaderText="ItemID" 
                                                    SortExpression="ItemID" UniqueName="ItemID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridTemplateColumn DataField="ImageURL" HeaderText="Image" SortExpression="ImageURL" 
                                                    UniqueName="ImageURL"
                                                    <EditItemTemplate> 
                                                        <asp:TextBox ID="ImageURLTextBox" runat="server" Text='<%# Bind("ImageURL") %>'></asp:TextBox> 
                                                    </EditItemTemplate> 
                                                    <ItemTemplate> 
                                                        <asp:Image ID="Image1" runat="server" AlternateText='<%# Eval("Description") %>' 
                                                            Height="50px" ImageAlign="AbsMiddle" ImageUrl='<%# Eval("ImageURL") %>' Width="50px" /> 
                                                    </ItemTemplate> 
                                                </telerik:GridTemplateColumn> 
                                                <telerik:GridBoundColumn DataField="Description" HeaderText="Alt. Text" SortExpression="Description" 
                                                    UniqueName="Description"
                                                </telerik:GridBoundColumn> 
                                            </Columns> 
                                        </MasterTableView> 
                                    </telerik:RadGrid> 
                                </td> 
                                <td valign="top"
                                    <telerik:RadGrid ID="ItemChoiceGrid" runat="server" DataSourceID="ItemChoiceLDS" 
                                        GridLines="None" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" 
                                        AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" HorizontalAlign="Left" 
                                        Skin="WebBlue"
                                        <MasterTableView DataSourceID="ItemChoiceLDS" AutoGenerateColumns="False" DataKeyNames="ItemChoiceID" 
                                            CommandItemDisplay="Bottom" EditMode="InPlace"
                                            <RowIndicatorColumn> 
                                                <HeaderStyle Width="20px" /> 
                                            </RowIndicatorColumn> 
                                            <DetailTables> 
                                                <telerik:GridTableView runat="server" AutoGenerateColumns="False" CommandItemDisplay="Bottom" 
                                                    DataKeyNames="ChoiceID" DataSourceID="ChoiceLDS" EditMode="InPlace"
                                                    <RowIndicatorColumn> 
                                                        <HeaderStyle Width="20px" /> 
                                                    </RowIndicatorColumn> 
                                                    <ParentTableRelation> 
                                                        <telerik:GridRelationFields DetailKeyField="ItemChoiceID" MasterKeyField="ItemChoiceID" /> 
                                                    </ParentTableRelation> 
                                                    <CommandItemSettings AddNewRecordText="Add New" /> 
                                                    <ExpandCollapseColumn> 
                                                        <HeaderStyle Width="20px" /> 
                                                    </ExpandCollapseColumn> 
                                                    <Columns> 
                                                        <telerik:GridBoundColumn DataField="Name" HeaderText="Name" UniqueName="column1"
                                                        </telerik:GridBoundColumn> 
                                                        <telerik:GridTemplateColumn DataField="ImageURL" HeaderText="Image" UniqueName="column"
                                                            <EditItemTemplate> 
                                                                <asp:TextBox runat="server" ID="TextBox1" Text='<%# Bind("ImageURL") %>'></asp:TextBox> 
                                                            </EditItemTemplate> 
                                                            <ItemTemplate> 
                                                                <asp:Image ID="Image2" runat="server" ImageUrl='<%# Eval("ImageURL") %>' Height="20" 
                                                                    Width="20" ImageAlign="AbsMiddle" /> 
                                                            </ItemTemplate> 
                                                        </telerik:GridTemplateColumn> 
                                                    </Columns> 
                                                </telerik:GridTableView> 
                                            </DetailTables> 
                                            <CommandItemSettings AddNewRecordText="Add New Choice" /> 
                                            <ExpandCollapseColumn Visible="True"
                                            </ExpandCollapseColumn> 
                                            <Columns> 
                                                <telerik:GridBoundColumn DataField="ItemChoiceID" DataType="System.Int32" HeaderText="ItemChoiceID" 
                                                    ReadOnly="True" SortExpression="ItemChoiceID" UniqueName="ItemChoiceID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32" HeaderText="ItemID" 
                                                    SortExpression="ItemID" UniqueName="ItemID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridBoundColumn DataField="Name" HeaderText="Choice" SortExpression="Name" 
                                                    UniqueName="Name"
                                                </telerik:GridBoundColumn> 
                                            </Columns> 
                                        </MasterTableView> 
                                    </telerik:RadGrid> 
                                </td> 
                                <td valign="top"
                                    <telerik:RadGrid ID="OptionGrid" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" 
                                        AllowAutomaticUpdates="True" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" 
                                        DataSourceID="OptionLDS" GridLines="None" Skin="WebBlue"
                                        <MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Bottom" DataKeyNames="OptionID" 
                                            DataSourceID="OptionLDS" EditMode="InPlace"
                                            <RowIndicatorColumn> 
                                                <HeaderStyle Width="20px" /> 
                                            </RowIndicatorColumn> 
                                            <CommandItemSettings AddNewRecordText="Add New Option" /> 
                                            <ExpandCollapseColumn> 
                                                <HeaderStyle Width="20px" /> 
                                            </ExpandCollapseColumn> 
                                            <Columns> 
                                                <telerik:GridBoundColumn DataField="OptionID" DataType="System.Int32" HeaderText="OptionID" 
                                                    ReadOnly="True" SortExpression="OptionID" UniqueName="OptionID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32" HeaderText="ItemID" 
                                                    SortExpression="ItemID" UniqueName="ItemID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridBoundColumn DataField="Name" HeaderText="Option" SortExpression="Name" 
                                                    UniqueName="Name"
                                                </telerik:GridBoundColumn> 
                                            </Columns> 
                                        </MasterTableView> 
                                    </telerik:RadGrid> 
                                </td> 
                                <td valign="top"
                                    <telerik:RadGrid ID="PriceBreakGrid" runat="server" AllowAutomaticDeletes="True" 
                                        AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AutoGenerateDeleteColumn="True" 
                                        AutoGenerateEditColumn="True" DataSourceID="PriceBreakLDS" GridLines="None" Skin="WebBlue"
                                        <MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Bottom" DataKeyNames="PriceBreakID" 
                                            DataSourceID="PriceBreakLDS" EditMode="InPlace"
                                            <RowIndicatorColumn> 
                                                <HeaderStyle Width="20px" /> 
                                            </RowIndicatorColumn> 
                                            <CommandItemSettings AddNewRecordText="Add New Price Break" /> 
                                            <ExpandCollapseColumn> 
                                                <HeaderStyle Width="20px" /> 
                                            </ExpandCollapseColumn> 
                                            <Columns> 
                                                <telerik:GridBoundColumn DataField="PriceBreakID" DataType="System.Int32" HeaderText="PriceBreakID" 
                                                    ReadOnly="True" SortExpression="PriceBreakID" UniqueName="PriceBreakID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32" HeaderText="ItemID" 
                                                    SortExpression="ItemID" UniqueName="ItemID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridBoundColumn DataField="Quantity" DataType="System.Int32" HeaderText="Quantity" 
                                                    SortExpression="Quantity" UniqueName="Quantity"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridBoundColumn DataField="Price" DataFormatString="{0:c}" DataType="System.Decimal" 
                                                    HeaderText="Price" SortExpression="Price" UniqueName="Price"
                                                </telerik:GridBoundColumn> 
                                            </Columns> 
                                        </MasterTableView> 
                                    </telerik:RadGrid> 
                                </td> 
                                <td valign="top"
                                    <telerik:RadGrid ID="SubcategoryGrid" runat="server" AllowAutomaticDeletes="True" 
                                        AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AutoGenerateDeleteColumn="True" 
                                        DataSourceID="SubcategoryLDS" GridLines="None" Skin="WebBlue"
                                        <MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Bottom" DataKeyNames="ItemID,SubCategoryID" 
                                            DataSourceID="SubcategoryLDS" EditMode="InPlace"
                                            <CommandItemSettings AddNewRecordText="Add New Subcategory" /> 
                                            <Columns> 
                                                <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32" HeaderText="ItemID" 
                                                    ReadOnly="True" SortExpression="ItemID" UniqueName="ItemID" Visible="False"
                                                </telerik:GridBoundColumn> 
                                                <telerik:GridTemplateColumn DataField="SubCategoryID" DataType="System.Int32" HeaderText="Subcategory" 
                                                    SortExpression="SubCategoryID" UniqueName="SubCategoryID"
                                                    <EditItemTemplate> 
                                                        <telerik:RadComboBox ID="RadComboBox2" runat="server" DataSourceID="SubcategoriesLDS" 
                                                            DataTextField="Name" DataValueField="SubCatgegoryID" SelectedValue='<%# Bind("SubCategoryID") %>' 
                                                            Skin="WebBlue"
                                                        </telerik:RadComboBox> 
                                                    </EditItemTemplate> 
                                                    <ItemTemplate> 
                                                        <asp:Label ID="SubCategoryIDLabel" runat="server" Text='<%# Eval("SubCategory.Name") %>'></asp:Label> 
                                                    </ItemTemplate> 
                                                </telerik:GridTemplateColumn> 
                                            </Columns> 
                                        </MasterTableView> 
                                    </telerik:RadGrid> 
                                </td> 
                            </tr> 
                        </table> 
                    </NestedViewTemplate> 
                    <CommandItemSettings AddNewRecordText="Add New Item" /> 
                    <ExpandCollapseColumn Visible="True"
                    </ExpandCollapseColumn> 
                    <Columns> 
                        <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32" HeaderText="ItemID" 
                            ReadOnly="True" SortExpression="ItemID" UniqueName="ItemID"
                        </telerik:GridBoundColumn> 
                        <telerik:GridBoundColumn DataField="Name" HeaderText="Name" SortExpression="Name" 
                            UniqueName="Name"
                        </telerik:GridBoundColumn> 
                        <telerik:GridTemplateColumn DataField="Description" HeaderText="Description" SortExpression="Description" 
                            UniqueName="Description"
                            <EditItemTemplate> 
                                <telerik:RadEditor ID="RadEditor1" runat="server" Content='<%# Bind("Description") %>' 
                                    Skin="WebBlue"
                                    <Content> 
                                    </Content> 
                                </telerik:RadEditor> 
                            </EditItemTemplate> 
                            <ItemTemplate> 
                                <asp:Label ID="DescriptionLabel" runat="server" Text='<%# Eval("Description") %>'></asp:Label> 
                            </ItemTemplate> 
                        </telerik:GridTemplateColumn> 
                        <telerik:GridCheckBoxColumn DataField="HasMascot" DataType="System.Boolean" HeaderText="HasMascot" 
                            SortExpression="HasMascot" UniqueName="HasMascot"
                        </telerik:GridCheckBoxColumn> 
                        <telerik:GridBoundColumn DataField="FactoryID" HeaderText="Item #" SortExpression="FactoryID" 
                            UniqueName="FactoryID"
                        </telerik:GridBoundColumn> 
                        <telerik:GridTemplateColumn DataField="CategoryID" DataType="System.Int32" HeaderText="Category" 
                            SortExpression="CategoryID" UniqueName="CategoryID"
                            <EditItemTemplate> 
                                <telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="CategoriesLDS" 
                                    DataTextField="Name" DataValueField="CategoryID" SelectedValue='<%# Bind("CategoryID") %>' 
                                    Skin="WebBlue"
                                </telerik:RadComboBox> 
                            </EditItemTemplate> 
                            <ItemTemplate> 
                                <asp:Label ID="CategoryIDLabel" runat="server" Text='<%# Eval("Category.Name") %>'></asp:Label> 
                            </ItemTemplate> 
                        </telerik:GridTemplateColumn> 
                    </Columns> 
                </MasterTableView> 

0
Princy
Top achievements
Rank 2
answered on 10 Mar 2010, 06:27 AM
Hi,

Could you  try removing the   Type="Int32"  from the declarartion and see if that helps.

ASPX:
 <WhereParameters> 
<asp:ControlParameter ControlID="Label1" Name="ProductId" PropertyName="Text"    /> 
</WhereParameters> 


Thanks,
Princy
0
Ken Miller
Top achievements
Rank 1
answered on 10 Mar 2010, 06:49 PM

Operator '==' incompatible with operand types 'Int32' and 'String'

Tags
Grid
Asked by
Ken Miller
Top achievements
Rank 1
Answers by
Ken Miller
Top achievements
Rank 1
Princy
Top achievements
Rank 2
Share this question
or