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>