Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Trouble Setting Insert Parameters in DataGrid View in ASP.Net

Posted on 2010-08-12
2
259 Views
Last Modified: 2012-05-10
I am trying to code an Insert from a DataGridView and I'm not setting the Insert Parameters correctly and can't figure out why.  The way it is currently coded, the new record is being added but not with the data that I entered (it is blank).  When debugging, the data is in the fields that I am using to set the parameters.  Here is the code and GridView Definition.  Any help is appreciated.
DataGridView
================
                <asp:Panel ID="Panel1" runat="server" CssClass="left_padding15">
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
                        AutoGenerateColumns="False" CellPadding="5" CellSpacing="5" 
                        DataKeyNames="StaffID" DataSourceID="StaffDataSource" ShowFooter="True">
                        <Columns>
                            <asp:TemplateField HeaderText="Sort Order" SortExpression="SortOrder">
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("SortOrder") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <FooterTemplate>
                                    <asp:TextBox ID="newSortOrderTB" runat="server"></asp:TextBox>
                                </FooterTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("SortOrder") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Position" SortExpression="StaffPosition">
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("StaffPosition") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <FooterTemplate>
                                    <asp:TextBox ID="NewStaffPositionTB" runat="server" Width="212px"></asp:TextBox>
                                </FooterTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("StaffPosition") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Staff Member" SortExpression="StaffMember">
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("StaffMember") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <FooterTemplate>
                                    <asp:TextBox ID="NewStaffMemberTB" runat="server" Width="227px"></asp:TextBox>
                                </FooterTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("StaffMember") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="StaffID" HeaderText="StaffID" InsertVisible="False" 
                                ReadOnly="True" SortExpression="StaffID" Visible="False" />
                            <asp:TemplateField ShowHeader="False">
                                <EditItemTemplate>
                                    <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" 
                                        CommandName="Update" Text="Update"></asp:LinkButton>
                                    &nbsp;<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" 
                                        CommandName="Cancel" Text="Cancel"></asp:LinkButton>
                                </EditItemTemplate>
                                <FooterTemplate>
                                    <asp:Button ID="AddNew" runat="server" CausesValidation="false"
                                        CommandName="Insert" Text="Add New"  OnClick="AddNew_Click"></asp:Button>
                                </FooterTemplate>
                                <ItemTemplate>
                                    <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" 
                                        CommandName="Edit" Text="Edit"></asp:LinkButton>
                                    &nbsp;<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" 
                                        CommandName="Delete" Text="Delete"></asp:LinkButton>
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                    </asp:GridView>
                    <asp:AccessDataSource ID="StaffDataSource" runat="server" 
                        DataFile="~/App_Data/ABVM.mdb" 
                        DeleteCommand="DELETE FROM [Staff] WHERE [StaffID] = ?" 
                        InsertCommand="INSERT INTO [Staff] ([SortOrder], [StaffPosition], [StaffMember]) VALUES (?, ?, ?)" 
                        SelectCommand="SELECT [SortOrder], [StaffPosition], [StaffMember], [StaffID] FROM [Staff] ORDER BY [SortOrder]" 
                        UpdateCommand="UPDATE [Staff] SET [SortOrder] = ?, [StaffPosition] = ?, [StaffMember] = ? WHERE [StaffID] = ?">
                        <DeleteParameters>
                            <asp:Parameter Name="StaffID" Type="Int32" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="SortOrder" Type="Int16" />
                            <asp:Parameter Name="StaffPosition" Type="String" />
                            <asp:Parameter Name="StaffMember" Type="String" />
                            <asp:Parameter Name="StaffID" Type="Int32" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="NewSortOrder" Type="Int16" />
                            <asp:Parameter Name="NewStaffPosition" Type="String" />
                            <asp:Parameter Name="NewStaffMember" Type="String" />
                        </InsertParameters>
                    </asp:AccessDataSource>
                </asp:Panel>

CODE
=======
    Protected Sub StaffDataSource_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEventArgs) Handles StaffDataSource.Inserting
        Dim SO As TextBox = GridView1.FooterRow.FindControl("NewSortOrderTB")
        Dim SP As TextBox = GridView1.FooterRow.FindControl("NewStaffPositionTB")
        Dim SM As TextBox = GridView1.FooterRow.FindControl("NewStaffMemberTB")

        StaffDataSource.InsertParameters("NewSortOrder").DefaultValue = CInt(SO.Text)
        StaffDataSource.InsertParameters("NewStaffPosition").DefaultValue = SP.Text
        StaffDataSource.InsertParameters("NewStaffMember").DefaultValue = SM.Text
        StaffDataSource.DataBind()

    End Sub

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        StaffDataSource.Insert()
    End Sub

Open in new window

0
Comment
Question by:dyarosh
2 Comments
 
LVL 41

Accepted Solution

by:
guru_sami earned 500 total points
ID: 33424567
Try:
         e.Command.Paramters("NewSortOrder").Value  =CInt(SO.Text)

similarly others.
0
 

Author Closing Comment

by:dyarosh
ID: 33425195
Thank you.  That did it.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question