Solved

Simple updates using grid and sql data source

Posted on 2010-09-02
3
233 Views
Last Modified: 2012-05-10
The code window shows an sql data source and a grid.
It also has the stored procedure used by the update command.

When I try and update a column it either blanks out all the columns I've not chosen to update or gives me an error message saying:
@original_Code is not a parameter for procedure UpdateAllEq.
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" SelectCommand="SELECT * FROM [AllEq]" UpdateCommand="UpdateAllEq" OldValuesParameterFormatString="original_{0}" UpdateCommandType="StoredProcedure">

                <DeleteParameters>

                    <asp:Parameter Name="original_Code" Type="String" />

                </DeleteParameters>

                <UpdateParameters>

                    <asp:Parameter Name="Code" Type="String" />

                    <asp:Parameter Name="NAME" Type="String" />

                    <asp:Parameter Name="GEOGN" Type="String" />

                    <asp:Parameter Name="Cov" Type="String" />

                    <asp:Parameter Name="TIME" Type="String" />

                </UpdateParameters>

            </asp:SqlDataSource>

        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"

            AutoGenerateColumns="False" DataKeyNames="Code" DataSourceID="SqlDataSource1"

            PageSize="20">

            <PagerSettings Mode="NextPreviousFirstLast" />

            <Columns>

                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />

                <asp:BoundField DataField="Code" HeaderText="Code" ReadOnly="True" SortExpression="Code" />

                <asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" />

                <asp:BoundField DataField="GEOGN" HeaderText="GEOGN" SortExpression="GEOGN" />

                <asp:BoundField DataField="COV" HeaderText="COV" SortExpression="COV" />

                <asp:BoundField DataField="TIME" HeaderText="TIME" SortExpression="TIME" />

            </Columns>

        </asp:GridView>

        <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"

            DataKeyNames="Code" DataSourceID="SqlDataSource1" Height="50px" Width="125px">

            <Fields>

                <asp:BoundField DataField="Code" HeaderText="Code" ReadOnly="True" SortExpression="Code" />

                <asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" />

                <asp:BoundField DataField="GEOGN" HeaderText="GEOGN" SortExpression="GEOGN" />

                <asp:BoundField DataField="COV" HeaderText="COV" SortExpression="COV" />

                <asp:BoundField DataField="TIME" HeaderText="TIME" SortExpression="TIME" />

            </Fields>

        </asp:DetailsView>



------------Stored Procedure

ALTER PROCEDURE [dbo].[UpdateAllEq]

(

@Code varchar(6) ,

@Name varchar(255),

@GEOGN varchar(255),

@Cov varchar(255),

@TIME varchar(255))



AS

UPDATE [AllEq] 

SET [NAME] = @NAME, 

[GEOGN] = @GEOGN, 

Cov = @Cov, 

[TIME] = @TIME

WHERE [Code] = @Code

Open in new window

0
Comment
Question by:AlHal2
  • 2
3 Comments
 

Author Comment

by:AlHal2
ID: 33587100
The main thing is that I want to know exactly what SQL was passed to the database.
0
 
LVL 29

Expert Comment

by:Kumaraswamy R
ID: 33615245
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" SelectCommand="SELECT * FROM [AllEq]" UpdateCommand="UpdateAllEq" OldValuesParameterFormatString="original_{0}" <UpdateCommandType="StoredProcedure">
             
                <UpdateParameters>
                    <asp:Parameter Name="Code" Type="String" />
                    <asp:Parameter Name="NAME" Type="String" />
                    <asp:Parameter Name="GEOGN" Type="String" />
                    <asp:Parameter Name="Cov" Type="String" />
                    <asp:Parameter Name="TIME" Type="String" />
                </UpdateParameters>
            </asp:SqlDataSource>

        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" DataKeyNames="Code" DataSourceID="SqlDataSource1"
            PageSize="20">
            <PagerSettings Mode="NextPreviousFirstLast" />
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                <asp:BoundField DataField="Code" HeaderText="Code" ReadOnly="True" SortExpression="Code" />
                <asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" />
                <asp:BoundField DataField="GEOGN" HeaderText="GEOGN" SortExpression="GEOGN" />
                <asp:BoundField DataField="COV" HeaderText="COV" SortExpression="COV" />
                <asp:BoundField DataField="TIME" HeaderText="TIME" SortExpression="TIME" />
            </Columns>
        </asp:GridView>
        <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
            DataKeyNames="Code" DataSourceID="SqlDataSource1" Height="50px" Width="125px">
            <Fields>
                <asp:BoundField DataField="Code" HeaderText="Code" ReadOnly="True" SortExpression="Code" />
                <asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" />
                <asp:BoundField DataField="GEOGN" HeaderText="GEOGN" SortExpression="GEOGN" />
                <asp:BoundField DataField="COV" HeaderText="COV" SortExpression="COV" />
                <asp:BoundField DataField="TIME" HeaderText="TIME" SortExpression="TIME" />
            </Fields>
        </asp:DetailsView>

0
 

Accepted Solution

by:
AlHal2 earned 0 total points
ID: 33615824
Thanks for this.  Would you be able to make it called stored procedures for the select and update statements?  I don't have any code for inserts or deletes, but could add some if necessary.

Raising points to 300
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

863 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now