hi, i am badly stuck with the simplest thing. I have created a simple gridview for users to update info. however, as soon as the user clicked the "update" button, the info just got lost to nowhere. i have recreated the code over and over again and cannot see why. please advise. many thx in advance.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="1.aspx.vb" Inherits="DataEntry_1" %>
<!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 id="Head1" runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="gfPerformances" runat="server" AutoGenerateColumns="true" DataKeyNames="PortfolioID,SeriesID,Date"
DataSourceID="adsPerformances" AutoGenerateEditButton="true" >
<Columns>
</Columns>
</asp:GridView>
<div>
<asp:AccessDataSource ID="adsPerformances" runat="server" DataFile="~/DB/WebsiteAdmin.mdb"
SelectCommand="SELECT * FROM [tblSeriesPerformances] ORDER BY [Date] DESC, [SeriesID]"
UpdateCommand="UPDATE tblSeriesPerformances SET EndMonthNAV = @EndMonthNAV WHERE PortfolioID = @PortfolioID and SeriesID = @SeriesID and [Date] = @Date">
</asp:AccessDataSource>
</div>
</form>
</body>
</html>