on page 364 there is, in the update command querystring, "@original_CustomerID"

where, what and how does "original_" fit in?

my real question is that i'm having problems updating ... in my where clause, i can't specify it to anything non-hard coded that isn't an editable text field when in edit mode. yet, i do not want the ID to be an editable field, even if i don't update it in the querystring ... what am i missing here?



here's my code:
****************************




<asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:MoviesConnectionString %>"
        ProviderName="<%$ ConnectionStrings:MoviesConnectionString.ProviderN ame %>"
        SelectCommand="SELECT * FROM [All Movies]"
        UpdateCommand="UPDATE tblMovies SET [fldFind] = @fldFind where (fldID = @origional_fldID)"
        >
        <UpdateParameters>
            <asp:Parameter Type="String" Name="fldFind" />
        </UpdateParameters>

        </asp:SqlDataSource>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" AutoGenerateDeleteButton="True" DataKeyNames="fldID"
            DataSourceID="SqlDataSource1" EnableSortingAndPagingCallbacks="True" AutoGenerateEditButton="True" CellPadding="4" ForeColor="#333333" GridLines="None">
            <Columns>

                <asp:BoundField DataField="fldID" HeaderText="fldID" Visible=False InsertVisible="False"
                    SortExpression="fldID" />
                <asp:BoundField DataField="fldFind" HeaderText="fldFind" SortExpression="fldFind" />
                <asp:BoundField DataField="fldID" HeaderText="OK" />
                <asp:BoundField DataField="fldFind2" HeaderText="fldFind2" SortExpression="fldFind2" />
                <asp:BoundField DataField="fldFind3" HeaderText="fldFind3" SortExpression="fldFind3" />
                <asp:BoundField DataField="fldName" HeaderText="fldName" SortExpression="fldName" />
                <asp:BoundField DataField="fldType" HeaderText="fldType" SortExpression="fldType" />
                <asp:BoundField DataField="fldDescription" HeaderText="fldDescription" SortExpression="fldDescription" >
                    <HeaderStyle Width="500px" />
                </asp:BoundField>
                <asp:BoundField DataField="fldDate" HeaderText="fldDate" SortExpression="fldDate" />
                <asp:BoundField DataField="fldActors" HeaderText="fldActors" SortExpression="fldActors" />
                <asp:BoundField DataField="fldRating" HeaderText="fldRating" SortExpression="fldRating" />
                <asp:BoundField DataField="fldComments" HeaderText="fldComments" SortExpression="fldComments" />
                <asp:BoundField DataField="fldPersonalRating" HeaderText="fldPersonalRating" SortExpression="fldPersonalRating" />
                <asp:BoundField DataField="fldLanguage" HeaderText="fldLanguage" SortExpression="fldLanguage" />
                <asp:BoundField DataField="fldSubTitles" HeaderText="fldSubTitles" SortExpression="fldSubTitles" />
                <asp:BoundField DataField="fldPicture" HeaderText="fldPicture" SortExpression="fldPicture" />
                <asp:BoundField DataField="fldFormat" HeaderText="fldFormat" SortExpression="fldFormat" />
            </Columns>
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <EditRowStyle BackColor="#999999" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        </asp:GridView>

Hi, I‘m afraid that this code is based on Beta 2. You should set SqlDataSource.OldValuesParameterFormatString property to “original_{0}” to solve this problem. It was the default value of that property in Beta 2. You can find more info here - http://www.asp.net/QuickStart/aspnet...x#updatedelete.

i'm not sure i understand. i re-wrote the page 3 times and just cannot figure out how to update a row without saying "where fldID = 1".

"where fldID = @fldID" does not work.

i'm not writing any vb or C# code ... you're supposed to be able to do it without any code in asp.net 2.0

here's my new code ... it's very short. could someone fix it for me?:



************


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

<!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>
</head>
<body>
    <form id="form1" runat="server">
    <div>
       <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" AutoGenerateEditButton="True" DataKeyNames="fldID" DataSourceID="AccessDataSource1" PageSize="2">
           <Columns>
               <asp:BoundField DataField="fldFind" HeaderText="fldFind" SortExpression="fldFind" />
               <asp:BoundField DataField="fldName" HeaderText="fldName" SortExpression="fldName" />
           </Columns>
        </asp:GridView>
        <br />
        <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="c:\inetpub\wwwroot\movies\movies.mdb"
            SelectCommand="SELECT * FROM [All Movies]"
            updatecommand="update tblMovies set fldName = @fldName where fldID = @fldID"
            >
            <UpdateParameters>
            <asp:Parameter Type="String" Name="fldName" />
            </UpdateParameters>
            </asp:AccessDataSource>
    </div>
    </form>
</body>
</html>

As Jan said the code changed between the beta and the final release. The Data Source will keep track of the original values for you so that you can use them to perform various logical operations between the old and new values if you need. In early releases, the Data Source object defaulted to using the prefix Original_{0} as t he Parameter prefix for those values, but in the final release this value was made configurable via the OldValueParameterFormatString attribute on the Data Source object.

The following code worked for me in the release version. All I did was add the OldValueParameterFormatString attribute to the Data Source, and then added the Parameter to the Update Parameters:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
     <title>Untitled Page</title>
</head>
<body>
     <form id="form1" runat="server">
     <div>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
            AllowSorting="True" AutoGenerateColumns="False" AutoGenerateEditButton="True"
            DataKeyNames="fldID" DataSourceID="AccessDataSource1" PageSize="2">
            <Columns>
                <asp:BoundField DataField="fldFind" HeaderText="fldFind" SortExpression="fldFind" />
                <asp:BoundField DataField="fldName" HeaderText="fldName" SortExpression="fldName" />
            </Columns>
         </asp:GridView>

         <br />

         <asp:AccessDataSource ID="AccessDataSource1" runat="server"
             DataSourceMode="DataSet"
             OldValuesParameterFormatString="original_{0}"
             DataFile="c:\inetpub\wwwroot\movies\movies.mdb"
             SelectCommand="SELECT * FROM [All Movies]"
             UpdateCommand="UPDATE [tblMovies] SET [fldName] = @fldName WHERE [fldID] = @fldID">
             <UpdateParameters>
                <asp:Parameter Type="String" Name="fldName" />
                <asp:Parameter Type="String" Name="original_fldID" />
             </UpdateParameters>
         </asp:AccessDataSource>
     </div>
     </form>
</body>
</html>

ok, i see, this makes sense now.

the line: OldValuesParameterFormatString="original_{0}"

could you explain the "0" further? ... for example. what would 1 or 2 reference? ... if you edited and changed a row 3 times ... would all the changes be stored somewhere? if so, is it the hidden field? ... so many questions huh? ... ha ha.

is there a place where i could get a listing of all the properties and methods explained in detail for any object in the final .NET 2.0 framework?

i visited http://www.asp.net/QuickStart/ but i cannot find my answer there ... maybe i don't know how to find my answer because i don't know enough about what i'm doing. i did find the AccessDataSource under the Data Controls ... but the information is only a few lines ... very limited.

{0} is just standard string formatter notation...basically like saying original_foo. Think of {0} as simply a placeholder in the string literal that can be replaced by a real value at runtime. I would guess that MSFT uses String.Format() (or somthing similar) to create the final string.

String.Format works like this:

You can see that I have specified several different "variables" in the string, and then I just supply the values I want for those variables as the final three argument. The OldValueParameterFormatString is doing the same basic thing.

Make sense?

As far as documentation, the best place i can point you is the MSDN help. You can either use the built in VS help, or I sometimes use Google. Simply type in the object name you want info about, then add "site:msdn2.microsoft.com" to your query to tell Google to restrict its search results to the MSDN documentation website.

Devin

pefect, i have a whole new confidence with this .NET stuff, thanks.

I had a similar problem and I resolved it listing EXACTLY the same field inside the <columns> label and in the UPDATE sentence.

I hope it helps...