?
Solved

Simple updates using grid and sql data source

Posted on 2010-09-02
3
Medium Priority
?
239 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
Loops Section Overview
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month16 days, 9 hours left to enroll

862 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