Hi All,
Ok well I have a gridview which updates fine when I use it outside a master page, but when I put it in the master page the update doesn't work at all... have you got any ideas what I might be missing??
here is the code...
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Admin.aspx.cs" enableEventValidation="false" viewStateEncryptionMode ="Never" MasterPageFile="~/Main.master" Inherits="Admin" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<!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>
<title>Untitled Page</title>
<link href="Styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body>
<form id="form1">
<div>
<asp:GridView ID="AdminGridView" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical" DataSourceID="EventDataSource" DataKeyNames="PriKey">
<Columns>
<asp:BoundField DataField="PriKey" HeaderText="ID No" />
<asp:BoundField DataField="Typage" HeaderText="Type" />
<asp:BoundField DataField="UserName" HeaderText="UserName" />
<asp:BoundField DataField="BookedFrom" HeaderText="From" />
<asp:BoundField DataField="BookedUntill" HeaderText="Untill" />
<asp:BoundField DataField="Setup" HeaderText="Set Up?" />
<asp:BoundField DataField="TimeStamp" HeaderText="Time Stamp" />
<asp:BoundField DataField="Approved" HeaderText="Approved?" />
<asp:BoundField DataField="ModelNo" HeaderText="Model No" />
<asp:BoundField DataField="Projector" HeaderText="Projector" />
<asp:BoundField DataField="Status" HeaderText="Status" />
<asp:BoundField DataField="AssignedBy" HeaderText="AssignedBy" />
<asp:BoundField DataField="BookedIn" HeaderText="Booked In" />
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowDeleteButton ="True" />
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#CCCCCC" />
</asp:GridView>
<asp:SqlDataSource ID="EventDataSource" runat="server" ConnectionString="<%$ appsettings:ConnectionString %>"
ConflictDetection="CompareAllValues" SelectCommand="SELECT * FROM [book]" DeleteCommand="DELETE FROM [book] WHERE PriKey = @PriKey" InsertCommand="INSERT INTO [book] ([PriKey], [Typage], [Username], [BookedFrom], [BookedUntill], [SetUp], [TimeStamp], [Approved], [ModelNo], [Projector], [Status], [AssignedBy], [BookedIn]) VALUES (@PriKey, @Typage, @username, @BookedFrom, @BookedUntill, @SetUp, @Approved, @ModelNo, @Projector, @Status, @AssignedBy, @BookedIn)" UpdateCommand="UPDATE [book] SET [PriKey] = @PriKey, [Typage] = @Typage, [Username] = @username, [BookedFrom] = @BookedFrom, [BookedUntill] = @BookedUntill, [SetUp] = @SetUp, [TimeStamp] = @TimeStamp, [Approved] = @Approved, [ModelNo] = @ModelNo, [Projector] = @Projector, [Status] = @Status, [AssignedBy] = @AssignedBy, [BookedIn] = @BookedIn WHERE [PriKey] = @PriKey">
<DeleteParameters>
<asp
arameter Name="PriKey" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp
arameter Name="PriKey" Type="Int32" />
<asp
arameter Name="Typage" Type="String" />
<asp
arameter Name="Username" Type="String" />
<asp
arameter Name="BookedFrom" Type="String" />
<asp
arameter Name="BookedUntill" Type="String" />
<asp
arameter Name="SetUp" Type="String" />
<asp
arameter Name="TimeStamp" Type="String" />
<asp
arameter Name="Approved" Type="String" />
<asp
arameter Name="ModelNo" Type="String" />
<asp
arameter Name="Projector" Type="String" />
<asp
arameter Name="Status" Type="String" />
<asp
arameter Name="AssignedBy" Type="String" />
<asp
arameter Name="BookedIn" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp
arameter Name="PriKey" Type="Int32" />
<asp
arameter Name="Typage" Type="String" />
<asp
arameter Name="Username" Type="String" />
<asp
arameter Name="BookedFrom" Type="String" />
<asp
arameter Name="BookedUntill" Type="String" />
<asp
arameter Name="SetUp" Type="String" />
<asp
arameter Name="TimeStamp" Type="String" />
<asp
arameter Name="Approved" Type="String" />
<asp
arameter Name="ModelNo" Type="String" />
<asp
arameter Name="Projector" Type="String" />
<asp
arameter Name="Status" Type="String" />
<asp
arameter Name="AssignedBy" Type="String" />
<asp
arameter Name="BookedIn" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
</asp:Content>
Cheers,
Stelly
Ok well I have a gridview which updates fine when I use it outside a master page, but when I put it in the master page the update doesn't work at all... have you got any ideas what I might be missing??
here is the code...
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Admin.aspx.cs" enableEventValidation="false" viewStateEncryptionMode ="Never" MasterPageFile="~/Main.master" Inherits="Admin" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<!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>
<title>Untitled Page</title>
<link href="Styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body>
<form id="form1">
<div>
<asp:GridView ID="AdminGridView" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical" DataSourceID="EventDataSource" DataKeyNames="PriKey">
<Columns>
<asp:BoundField DataField="PriKey" HeaderText="ID No" />
<asp:BoundField DataField="Typage" HeaderText="Type" />
<asp:BoundField DataField="UserName" HeaderText="UserName" />
<asp:BoundField DataField="BookedFrom" HeaderText="From" />
<asp:BoundField DataField="BookedUntill" HeaderText="Untill" />
<asp:BoundField DataField="Setup" HeaderText="Set Up?" />
<asp:BoundField DataField="TimeStamp" HeaderText="Time Stamp" />
<asp:BoundField DataField="Approved" HeaderText="Approved?" />
<asp:BoundField DataField="ModelNo" HeaderText="Model No" />
<asp:BoundField DataField="Projector" HeaderText="Projector" />
<asp:BoundField DataField="Status" HeaderText="Status" />
<asp:BoundField DataField="AssignedBy" HeaderText="AssignedBy" />
<asp:BoundField DataField="BookedIn" HeaderText="Booked In" />
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowDeleteButton ="True" />
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#CCCCCC" />
</asp:GridView>
<asp:SqlDataSource ID="EventDataSource" runat="server" ConnectionString="<%$ appsettings:ConnectionString %>"
ConflictDetection="CompareAllValues" SelectCommand="SELECT * FROM [book]" DeleteCommand="DELETE FROM [book] WHERE PriKey = @PriKey" InsertCommand="INSERT INTO [book] ([PriKey], [Typage], [Username], [BookedFrom], [BookedUntill], [SetUp], [TimeStamp], [Approved], [ModelNo], [Projector], [Status], [AssignedBy], [BookedIn]) VALUES (@PriKey, @Typage, @username, @BookedFrom, @BookedUntill, @SetUp, @Approved, @ModelNo, @Projector, @Status, @AssignedBy, @BookedIn)" UpdateCommand="UPDATE [book] SET [PriKey] = @PriKey, [Typage] = @Typage, [Username] = @username, [BookedFrom] = @BookedFrom, [BookedUntill] = @BookedUntill, [SetUp] = @SetUp, [TimeStamp] = @TimeStamp, [Approved] = @Approved, [ModelNo] = @ModelNo, [Projector] = @Projector, [Status] = @Status, [AssignedBy] = @AssignedBy, [BookedIn] = @BookedIn WHERE [PriKey] = @PriKey">
<DeleteParameters>
<asp

</DeleteParameters>
<UpdateParameters>
<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

</UpdateParameters>
<InsertParameters>
<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

<asp

</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
</asp:Content>
Cheers,
Stelly