First time setting up a gridview to update and everything seems to work except the final execution of the update query. Maybe my SQL update query is off?
This is a TableAdapter in my Dataset:
SET dtDisplay=@dtDisplay, lastdisplay=@lastdisplay
WHERE propID = @propID
dtDisplay and lastdisplay are column names. The gridview displays all the records correctly, and when you click on the "edit" button for any record those values in the row become text boxes you can edit. However, once you edit them and then click on "update" they revert back to their former values. I'm sure I'm missing something really obvious here.
<%@ Page Title="" Language="C#" MasterPageFile="~/cms/cms.Master" AutoEventWireup="true" CodeBehind="featured_properties.aspx.cs" Inherits="Maine_Innkeeper_Site_2010.cms.pub.featured_properties" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
<h3>Manage Featured Properties</h3>
<asp:GridView ID="GridView1" runat="server" AllowSorting="True"
View Complete Post