master files c#

Don
Joined
5 Oct 2005
Posts
11,239
Location
Liverpool
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:Parameter Name="PriKey" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="PriKey" Type="Int32" />
<asp:Parameter Name="Typage" Type="String" />
<asp:Parameter Name="Username" Type="String" />
<asp:Parameter Name="BookedFrom" Type="String" />
<asp:Parameter Name="BookedUntill" Type="String" />
<asp:Parameter Name="SetUp" Type="String" />
<asp:Parameter Name="TimeStamp" Type="String" />
<asp:Parameter Name="Approved" Type="String" />
<asp:Parameter Name="ModelNo" Type="String" />
<asp:Parameter Name="Projector" Type="String" />
<asp:Parameter Name="Status" Type="String" />
<asp:Parameter Name="AssignedBy" Type="String" />
<asp:Parameter Name="BookedIn" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="PriKey" Type="Int32" />
<asp:Parameter Name="Typage" Type="String" />
<asp:Parameter Name="Username" Type="String" />
<asp:Parameter Name="BookedFrom" Type="String" />
<asp:Parameter Name="BookedUntill" Type="String" />
<asp:Parameter Name="SetUp" Type="String" />
<asp:Parameter Name="TimeStamp" Type="String" />
<asp:Parameter Name="Approved" Type="String" />
<asp:Parameter Name="ModelNo" Type="String" />
<asp:Parameter Name="Projector" Type="String" />
<asp:Parameter Name="Status" Type="String" />
<asp:Parameter Name="AssignedBy" Type="String" />
<asp:Parameter Name="BookedIn" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
</asp:Content>

Cheers,

Stelly
 
Back
Top Bottom