Telerik Forums / UI for ASP.NET AJAX
This is a migrated thread and some comments may be shown as answers.

[Solved] Grid and Web User Control - Update & Insert

2 Answers 161 Views
Grid
This is a migrated thread and some comments may be shown as answers.
grand lorie
Top achievements
Rank 1
grand lorie asked on 15 Mar 2010, 07:22 PM
Hi

I have a Grid VIew with 2 Web User Controls for updating and inserting  the records, everything is working fine except when update or insert all what i got is just Null Values in the Database.

any idea?

Thanks

Items.aspx
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Items.aspx.vb" Inherits="Items" %>

<%@ Register Assembly="System.Web.Entity, Version=3.5.0.0, Culture=neutral,
    Namespace="System.Web.UI.WebControls" TagPrefix="asp" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
    <script type="text/javascript">
    
      function pageLoad() {
      }
    
    </script>
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
        <table class="style1">
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True"
                        AllowPaging="True" AllowSorting="True" AutoGenerateDeleteColumn="True"
                        AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1"
                        GridLines="None" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
                        AllowAutomaticUpdates="True">
<MasterTableView AutoGenerateColumns="False" DataKeyNames="ItemID" DataSourceID="SqlDataSource1"
                            CommandItemDisplay="Top" EditMode="PopUp">
    <Columns>
        <telerik:GridBoundColumn DataField="ItemID" DataType="System.Int32"
            DefaultInsertValue="" HeaderText="ID" ReadOnly="True" SortExpression="ItemID"
            UniqueName="ItemID">
        </telerik:GridBoundColumn>
        
        <telerik:GridBoundColumn  UniqueName="DivisionName" DataField="DivisionName" HeaderText="Division"
                        HeaderStyle-Width="130px">
                        <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxDivision" Width="130" DataSourceID="SqlDataSource2" DataTextField="DivisionName"
                                DataValueField="DivisionName" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("DivisionName").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="DivisionIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">

                                <script type="text/javascript">
                                    function DivisionIndexChanged(sender, args) {
                                        var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                        tableView.filter("DivisionName", args.get_item().get_value(), "EqualTo");

                                    }
                                </script>

                            </telerik:RadScriptBlock>
                        </FilterTemplate>

<HeaderStyle Width="130px"></HeaderStyle>
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn UniqueName="CategoryName" DataField="CategoryName" HeaderText="Category" HeaderStyle-Width="250px">
                        <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxCategory" Width="250" DataSourceID="SqlDataSource3" DataTextField="CategoryName"
                                DataValueField="CategoryName" Height="400px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("CategoryName").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="CategoryIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server">

                                <script type="text/javascript">
                                    function CategoryIndexChanged(sender, args) {
                                        var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                        tableView.filter("CategoryName", args.get_item().get_value(), "EqualTo");
                                    }
                                </script>

                            </telerik:RadScriptBlock>
                        </FilterTemplate>

<HeaderStyle Width="250px"></HeaderStyle>
                    </telerik:GridBoundColumn>
                             
        
        <telerik:GridBoundColumn UniqueName="TypeNAme" DataField="TypeNAme" HeaderText="TypeNAme" HeaderStyle-Width="250px">
                        <FilterTemplate>
                            <telerik:RadComboBox ID="RadComboBoxType" Width="250" DataSourceID="SqlDataSource4" DataTextField="TypeNAme"
                                DataValueField="TypeNAme" Height="400px" AppendDataBoundItems="true" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("TypeNAme").CurrentFilterValue %>'
                                runat="server" OnClientSelectedIndexChanged="TypeIndexChanged">
                                <Items>
                                    <telerik:RadComboBoxItem Text="All" />
                                </Items>
                            </telerik:RadComboBox>
                            <telerik:RadScriptBlock ID="RadScriptBlock3" runat="server">

                                <script type="text/javascript">
                                    function TypeIndexChanged(sender, args) {
                                        var tableView = $find("<%# TryCast(Container,GridItem).OwnerTableView.ClientID %>");
                                        tableView.filter("TypeNAme", args.get_item().get_value(), "EqualTo");
                                    }
                                </script>

                            </telerik:RadScriptBlock>
                        </FilterTemplate>

<HeaderStyle Width="250px"></HeaderStyle>
                    </telerik:GridBoundColumn>
                             
        
        <telerik:GridBoundColumn DataField="CodeName" DefaultInsertValue=""
            HeaderText="Code" SortExpression="CodeName" UniqueName="CodeName">
            <HeaderStyle Width="50px" Font-Bold="False" Font-Italic="False"
                Font-Overline="False" Font-Strikeout="False" Font-Underline="False"
                HorizontalAlign="Left" Wrap="True" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="FullCode" DefaultInsertValue=""
            HeaderText="Full Code" SortExpression="FullCode" UniqueName="FullCode">
            <HeaderStyle Width="250px" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="SectionName" DefaultInsertValue=""
            HeaderText="Section" SortExpression="SectionName" UniqueName="SectionName">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="VersionName" DefaultInsertValue=""
            HeaderText="Version" SortExpression="VersionName" UniqueName="VersionName">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="PagesNumber" DataType="System.Int32"
            DefaultInsertValue="" HeaderText="# of Pages" SortExpression="PagesNumber"
            UniqueName="PagesNumber" Visible="False">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="UnitCost" DataType="System.Decimal"
            DefaultInsertValue="" HeaderText="Unit Cost" SortExpression="UnitCost"
            UniqueName="UnitCost" Visible="False">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ItemCost" DataType="System.Decimal"
            DefaultInsertValue="" HeaderText="Item Cost" ReadOnly="True"
            SortExpression="ItemCost" UniqueName="ItemCost" DataFormatString="{0:c2}">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ReleaseDate" DataType="System.DateTime"
            DefaultInsertValue="" HeaderText="Release Date" SortExpression="ReleaseDate"
            UniqueName="ReleaseDate" DataFormatString="{0:d}">
        </telerik:GridBoundColumn>
        <telerik:GridCheckBoxColumn DataField="Discontinued" DataType="System.Boolean"
            DefaultInsertValue="False" HeaderText="Discontinued" SortExpression="Discontinued"
            UniqueName="Discontinued">
        </telerik:GridCheckBoxColumn>
        
    </Columns>
    <EditFormSettings EditFormType="WebUserControl"
        UserControlName="ItemsEdit.ascx">
        <PopUpSettings Width="800px" />
    </EditFormSettings>
</MasterTableView>
                        <ClientSettings>
                            <Selecting AllowRowSelect="True" />
                        </ClientSettings>
                    </telerik:RadGrid>
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
        </table>
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
        DeleteCommand="DELETE FROM [Item] WHERE [ItemID] = @ItemID"
        InsertCommand="INSERT INTO [Item] ([DivisionID], [CategoryID], [TypeID], [CodeID], [FullCode], [SectionID], [VersionID], [PagesNumber], [UnitCost], [ReleaseDate], [Discontinued], [ItemDescription]) VALUES (@DivisionID, @CategoryID, @TypeID, @CodeID, @FullCode, @SectionID, @VersionID, @PagesNumber, @UnitCost, @ReleaseDate, @Discontinued, @ItemDescription)"
        SelectCommand="SELECT Item.ItemID, Division.DivisionName, Category.CategoryName, Type.TypeName, Code.CodeName, Item.FullCode, Section.SectionName, Version.VersionName, Item.PagesNumber, Item.UnitCost, Item.ItemCost, Item.ReleaseDate, Item.Discontinued, Item.ItemDescription, Item.DivisionID, Item.CategoryID, Item.TypeID, Item.CodeID, Item.SectionID, Item.VersionID FROM Item INNER JOIN Category ON Item.CategoryID = Category.CategoryID INNER JOIN Code ON Item.CodeID = Code.CodeID INNER JOIN Division ON Item.DivisionID = Division.DivisionID INNER JOIN Section ON Item.SectionID = Section.SectionID INNER JOIN Type ON Item.TypeID = Type.TypeID INNER JOIN Version ON Item.VersionID = Version.VersionID ORDER BY Category.CategoryName"
        UpdateCommand="UPDATE [Item] SET [DivisionID] = @DivisionID, [CategoryID] = @CategoryID, [TypeID] = @TypeID, [CodeID] = @CodeID, [FullCode] = @FullCode, [SectionID] = @SectionID, [VersionID] = @VersionID, [PagesNumber] = @PagesNumber, [UnitCost] = @UnitCost, [ReleaseDate] = @ReleaseDate, [Discontinued] = @Discontinued, [ItemDescription] = @ItemDescription WHERE [ItemID] = @ItemID">
        <DeleteParameters>
            <asp:Parameter Name="ItemID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="DivisionID" Type="Int32" />
            <asp:Parameter Name="CategoryID" Type="Int32" />
            <asp:Parameter Name="TypeID" Type="Int32" />
            <asp:Parameter Name="CodeID" Type="Int32" />
            <asp:Parameter Name="FullCode" Type="String" />
            <asp:Parameter Name="SectionID" Type="Int32" />
            <asp:Parameter Name="VersionID" Type="Int32" />
            <asp:Parameter Name="PagesNumber" Type="Int32" />
            <asp:Parameter Name="UnitCost" Type="Decimal" />
            <asp:Parameter DbType="Date" Name="ReleaseDate" />
            <asp:Parameter Name="Discontinued" Type="Boolean" />
            <asp:Parameter Name="ItemDescription" Type="String" />
            <asp:Parameter Name="ItemID" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="DivisionID" Type="Int32" />
            <asp:Parameter Name="CategoryID" Type="Int32" />
            <asp:Parameter Name="TypeID" Type="Int32" />
            <asp:Parameter Name="CodeID" Type="Int32" />
            <asp:Parameter Name="FullCode" Type="String" />
            <asp:Parameter Name="SectionID" Type="Int32" />
            <asp:Parameter Name="VersionID" Type="Int32" />
            <asp:Parameter Name="PagesNumber" Type="Int32" />
            <asp:Parameter Name="UnitCost" Type="Decimal" />
            <asp:Parameter DbType="Date" Name="ReleaseDate" />
            <asp:Parameter Name="Discontinued" Type="Boolean" />
            <asp:Parameter Name="ItemDescription" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
 
    <asp:SqlDataSource ID="SqlDataSource2" runat="server"
        ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
        SelectCommand="SELECT [DivisionID], [DivisionName] FROM [Division] ORDER BY [DivisionName]">
    </asp:SqlDataSource>
    
    <asp:SqlDataSource ID="SqlDataSource3" runat="server"
        ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
        
        SelectCommand="SELECT DISTINCT [CategoryID], [CategoryName] FROM [Category] ORDER BY [CategoryName]">
    </asp:SqlDataSource>
    
    <asp:SqlDataSource ID="SqlDataSource4" runat="server"
        ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
        
        
        SelectCommand="SELECT [TypeID], [TypeName] FROM [Type] ORDER BY [TypeName]"
        DeleteCommand="DELETE FROM [Type] WHERE [TypeID] = @TypeID"
        InsertCommand="INSERT INTO [Type] ([TypeName]) VALUES (@TypeName)"
        UpdateCommand="UPDATE [Type] SET [TypeName] = @TypeName WHERE [TypeID] = @TypeID">
        <DeleteParameters>
            <asp:Parameter Name="TypeID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="TypeName" Type="String" />
            <asp:Parameter Name="TypeID" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="TypeName" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
    
    </form>
</body>
</html>
-------------------------------------------------------------------------------------------------
ItemsInsert.ascx
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="ItemsInsert.ascx.vb" Inherits="ItemsUpdIns" %>
<style type="text/css">
    .style1
    {
        width: 100%;
    }
    .style2
    {
        font-weight: bold;
        text-align: right;
    }
    .style3
    {
        font-weight: bold;
        text-align: right;
        height: 24px;
    }
    .style4
    {
        height: 24px;
    }
    .style5
    {
        font-weight: bold;
    }
    .style6
    {
        text-align: right;
    }
    .style7
    {
        height: 24px;
        text-align: right;
    }
</style>
<table class="style1" width="750">
    <tr>
        <td class="style2" width="150">
            &nbsp;</td>
        <td width="300">
            &nbsp;</td>
        <td width="150" class="style2">
            &nbsp;</td>
        <td width="150">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Division</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox1" Runat="server"
                DataSourceID="SqlDataSource1"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.DivisionID" ) %>' DataTextField="DivisionName"
                DataValueField="DivisionID" Width="160px" Skin="Sunset">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Number of pages</td>
        <td width="150">
            <telerik:RadNumericTextBox ID="RadNumericTextBox1" Runat="server"
                Culture="English (United Kingdom)"
                Text='<%# DataBinder.Eval( Container, "DataItem.PagesNumber" ) %>' Value="0"
                Width="75px" ShowSpinButtons="True">
            </telerik:RadNumericTextBox>
        </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Category</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox3" Runat="server"
                DataSourceID="SqlDataSource2"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.CategoryID" ) %>' DataTextField="CategoryName"
                DataValueField="CategoryID" Width="250px" Skin="Sunset" Height="400px">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Unit Cost</td>
        <td width="150">
            <telerik:RadNumericTextBox ID="RadNumericTextBox2" Runat="server"
                Culture="English (United Kingdom)" Text='<%# DataBinder.Eval( Container, "DataItem.UnitCost" ) %>' ShowSpinButtons="True" Type="Currency"
                Value="0" Width="75px">
            </telerik:RadNumericTextBox>
        </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Item Type</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox4" Runat="server"
                DataSourceID="SqlDataSource3"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.TypeID" ) %>' DataTextField="TypeName"
                DataValueField="TypeID" Width="250px" Skin="Sunset" Height="400px">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Item Cost</td>
        <td width="150">
            £
            <asp:Label ID="Label1" runat="server" Text='<%# DataBinder.Eval( Container, "DataItem.ItemCost" ) %>'></asp:Label>
        </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            &nbsp;</td>
        <td width="300">
            &nbsp;</td>
        <td width="150" class="style2">
            &nbsp;</td>
        <td width="150">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Section</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox5" Runat="server"
                DataSourceID="SqlDataSource4"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.SectionID" ) %>' DataTextField="SectionName"
                DataValueField="SectionID" Width="100px" Skin="Sunset" Height="400px">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Release Date</td>
        <td width="150">
            <telerik:RadDatePicker ID="RadDatePicker1" Text='<%# DataBinder.Eval( Container, "DataItem.ReleaseDate" ) %>' Runat="server"
                Culture="English (United Kingdom)" SelectedDate="2010-03-15" Width="150px">
<Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x"></Calendar>

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

<DateInput DisplayDateFormat="dd/MM/yyyy" DateFormat="dd/MM/yyyy" SelectedDate="2010-03-15"></DateInput>
            </telerik:RadDatePicker>
        </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Version</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox6" Runat="server"
                DataSourceID="SqlDataSource5"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.VersionID" ) %>' DataTextField="VersionName"
                DataValueField="VersionID" Width="150px" Skin="Sunset" Height="400px">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Discontinued</td>
        <td width="150">
            <asp:CheckBox ID="CheckBox1" Checked='<%# DataBinder.Eval( Container, "DataItem.Discontinued" ) %>' runat="server" />
        </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            &nbsp;</td>
        <td width="300">
            &nbsp;</td>
        <td width="150" class="style2">
            &nbsp;</td>
        <td width="150">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Code</td>
        <td width="300">
            <telerik:RadComboBox ID="RadComboBox7" Runat="server"
                DataSourceID="SqlDataSource6"
                SelectedValue='<%# DataBinder.Eval( Container, "DataItem.CodeID" ) %>' DataTextField="CodeName"
                DataValueField="CodeID" Width="75px" Skin="Sunset" Height="400px">
            </telerik:RadComboBox>
        </td>
        <td width="150" class="style2">
            Full Code</td>
        <td width="150">
            <asp:TextBox id="TextBox3" runat="server"
Text='<%# DataBinder.Eval( Container, "DataItem.FullCode" ) %>' Width="200px"></asp:textbox>
        </td>
    </tr>
    <tr>
        <td class="style3" width="150">
            </td>
        <td width="300" class="style4">
            &nbsp;</td>
        <td width="150" class="style7">
            </td>
        <td width="150" class="style4">
            </td>
    </tr>
    <tr>
        <td class="style2" width="150">
            Item Description</td>
        <td width="300">
            <asp:TextBox id="TextBox4" runat="server"
Text='<%# DataBinder.Eval( Container, "DataItem.ItemDescription" ) %>' Width="290px"
                Height="50px" TextMode="MultiLine"></asp:textbox>
        </td>
        <td width="150" class="style2">
            &nbsp;</td>
        <td width="150">
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style2" width="150">
            &nbsp;</td>
        <td width="300">
            &nbsp;</td>
        <td width="150" class="style6">
            <asp:Button ID="btnUpdate" runat="server"
                            CommandName='<%# IIf( DataBinder.Eval(Container, "OwnerTableView.IsItemInserted"), "PerformInsert", "Update") %>'
                            Text='<%# IIf( DataBinder.Eval(Container, "OwnerTableView.IsItemInserted"), "Insert", "Update") %>'
                            Width="150px" />
        </td>
        <td width="150">
            <asp:Button ID="btnCancel" runat="server" Text="Cancel" Width="150px" CausesValidation="false"
                        CommandName="Cancel"></asp:Button>
        </td>
    </tr>
    </table>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Division] WHERE [DivisionID] = @DivisionID"
    InsertCommand="INSERT INTO [Division] ([DivisionName]) VALUES (@DivisionName)"
    SelectCommand="SELECT [DivisionID], [DivisionName] FROM [Division] ORDER BY [DivisionName]"
    UpdateCommand="UPDATE [Division] SET [DivisionName] = @DivisionName WHERE [DivisionID] = @DivisionID">
    <DeleteParameters>
        <asp:Parameter Name="DivisionID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="DivisionName" Type="String" />
        <asp:Parameter Name="DivisionID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="DivisionName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Category] WHERE [CategoryID] = @CategoryID"
    InsertCommand="INSERT INTO [Category] ([CategoryName]) VALUES (@CategoryName)"
    SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Category] ORDER BY [CategoryName]"
    UpdateCommand="UPDATE [Category] SET [CategoryName] = @CategoryName WHERE [CategoryID] = @CategoryID">
    <DeleteParameters>
        <asp:Parameter Name="CategoryID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="CategoryName" Type="String" />
        <asp:Parameter Name="CategoryID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="CategoryName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>


<asp:SqlDataSource ID="SqlDataSource3" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Type] WHERE [TypeID] = @TypeID"
    InsertCommand="INSERT INTO [Type] ([TypeName]) VALUES (@TypeName)"
    SelectCommand="SELECT [TypeID], [TypeName] FROM [Type] ORDER BY [TypeName]"
    UpdateCommand="UPDATE [Type] SET [TypeName] = @TypeName WHERE [TypeID] = @TypeID">
    <DeleteParameters>
        <asp:Parameter Name="TypeID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="TypeName" Type="String" />
        <asp:Parameter Name="TypeID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="TypeName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>



<asp:SqlDataSource ID="SqlDataSource4" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Section] WHERE [SectionID] = @SectionID"
    InsertCommand="INSERT INTO [Section] ([SectionName]) VALUES (@SectionName)"
    SelectCommand="SELECT [SectionID], [SectionName] FROM [Section] ORDER BY [SectionName]"
    UpdateCommand="UPDATE [Section] SET [SectionName] = @SectionName WHERE [SectionID] = @SectionID">
    <DeleteParameters>
        <asp:Parameter Name="SectionID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="SectionName" Type="String" />
        <asp:Parameter Name="SectionID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="SectionName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource5" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Version] WHERE [VersionID] = @VersionID"
    InsertCommand="INSERT INTO [Version] ([VersionName]) VALUES (@VersionName)"
    SelectCommand="SELECT [VersionID], [VersionName] FROM [Version] ORDER BY [VersionName]"
    UpdateCommand="UPDATE [Version] SET [VersionName] = @VersionName WHERE [VersionID] = @VersionID">
    <DeleteParameters>
        <asp:Parameter Name="VersionID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="VersionName" Type="String" />
        <asp:Parameter Name="VersionID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="VersionName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource6" runat="server"
    ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
    DeleteCommand="DELETE FROM [Code] WHERE [CodeID] = @CodeID"
    InsertCommand="INSERT INTO [Code] ([CodeName]) VALUES (@CodeName)"
    SelectCommand="SELECT [CodeID], [CodeName] FROM [Code] ORDER BY [CodeName]"
    UpdateCommand="UPDATE [Code] SET [CodeName] = @CodeName WHERE [CodeID] = @CodeID">
    <DeleteParameters>
        <asp:Parameter Name="CodeID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="CodeName" Type="String" />
        <asp:Parameter Name="CodeID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="CodeName" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>




2 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 16 Mar 2010, 11:08 AM
Hi,

Could you try defining the format for the primary key value parameter for the update and  insert  using the  OldValuesParameterFormatString .

ASPX:

<asp:SqlDataSource runat="server" ID="areanoticeds" ConnectionString="<%$ ConnectionStrings:RD %>" CancelSelectOnNullParameter="false" OldValuesParameterFormatString="original_{0}"    
     DeleteCommand="DELETE FROM [RCAreaNotices] WHERE [id]=@original_id">  
<DeleteParameters> 
                <asp:Parameter Name="original_id" Type="Int32" /> 
</DeleteParameters> 

Thanks,
Princy

0
grand lorie
Top achievements
Rank 1
answered on 16 Mar 2010, 05:31 PM
Thanks Princy

I ll try that and let you know.

Once again thanks
Tags
Grid
Asked by
grand lorie
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
grand lorie
Top achievements
Rank 1
Share this question
or