Please help footer fields are now showing despite enabling show footer.
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="StudentSearch.aspx.vb" Inherits="SMIS2022WEB.StudentSearch" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<script src="../Scripts/jquery-1.8.3.min.js"></script>
<script src="ASPSnippets_Pager.min.js"></script>
<script type="text/javascript">
$(function () {
GetCustomers(1);
});
$("[id*=txtSearch]").live("keyup", function () {
GetCustomers(parseInt(1));
});
$(".Pager .page").live("click", function () {
GetCustomers(parseInt($(this).attr('page')));
});
function SearchTerm() {
return jQuery.trim($("[id*=txtSearch]").val());
};
function GetCustomers(pageIndex) {
$.ajax({
type: "POST",
url: "StudentSearch.aspx/GetCustomers",
data: '{searchTerm: "' + SearchTerm() + '", pageIndex: ' + pageIndex + '}',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: OnSuccess,
failure: function (response) {
alert(response.d);
},
error: function (response) {
alert(response.d);
}
});
}
var row;
function OnSuccess(response) {
var xmlDoc = $.parseXML(response.d);
var xml = $(xmlDoc);
var customers = xml.find("Customers");
if (row == null) {
row = $("[id*=SearchGrid] tr:last-child").clone(true);
}
$("[id*=SearchGrid] tr").not($("[id*=SearchGrid] tr:first-child")).remove();
if (customers.length > 0) {
$.each(customers, function () {
var customer = $(this);
$("td", row).eq(0).html($(this).find("ADMNO").text());
$("td", row).eq(1).html($(this).find("Name").text());
$("td", row).eq(2).html($(this).find("Class").text());
$("td", row).eq(3).html($(this).find("Stream").text());
$("td", row).eq(4).html($(this).find("Sex").text());
$("td", row).eq(5).html($(this).find("Status").text());
$("td", row).eq(6).html($(this).find("studenttype").text());
$("[id*=SearchGrid]").append(row);
row = $("[id*=SearchGrid] tr:last-child").clone(true);
});
var pager = xml.find("Pager");
$(".Pager").ASPSnippets_Pager({
ActiveCssClass: "current",
PagerCssClass: "pager",
PageIndex: parseInt(pager.find("PageIndex").text()),
PageSize: parseInt(pager.find("PageSize").text()),
RecordCount: parseInt(pager.find("RecordCount").text())
});
$(".Name").each(function () {
var searchPattern = new RegExp('(' + SearchTerm() + ')', 'ig');
$(this).html($(this).text().replace(searchPattern, "<span class = 'highlight'>" + SearchTerm() + "</span>"));
});
} else {
var empty_row = row.clone(true);
$("td:first-child", empty_row).attr("colspan", $("td", row).length);
$("td:first-child", empty_row).attr("align", "center");
$("td:first-child", empty_row).html("No records found for the search criteria.");
$("td", empty_row).not($("td:first-child", empty_row)).remove();
$("[id*=SearchGrid]").append(empty_row);
}
};
</script>
<body style="background-color: #FFFFFF">
<form id="form1" runat="server">
<div>
<asp:Panel ID="Panel1" runat="server" style="background-color: #FFFFFF" Height="600px" BorderColor="#6699FF" BorderStyle="Double" Font-Size="Medium">
<table class="auto-style1">
<tr>
<td class="auto-style18" colspan="1" rowspan="1">
<table border="1" cellpadding="2" class="auto-style15">
<tr>
<td class="auto-style23">Student Name</td>
<td class="auto-style25">Class</td>
<td class="auto-style24">Stream</td>
<td class="auto-style26">Sex</td>
<td class="auto-style27">Status</td>
<td class="auto-style28">Student Type</td>
<td class="auto-style28">Account</td>
</tr>
<tr>
<td class="auto-style23">
<asp:TextBox ID="StudentName" runat="server" Width="149px"></asp:TextBox>
</td>
<td class="auto-style25">
<asp:DropDownList ID="Classt" runat="server" DataSourceID="Classdt" DataTextField="CLASS" DataValueField="CLASS">
</asp:DropDownList>
<asp:SqlDataSource ID="Classdt" runat="server" ConnectionString="<%$ ConnectionStrings:SMIS2022ConnectionString %>" SelectCommand="SELECT [CLASS] FROM [CLASS]"></asp:SqlDataSource>
</td>
<td class="auto-style24">
<asp:DropDownList ID="Streamd" runat="server" DataSourceID="Streamdatad" DataTextField="Stream" DataValueField="Stream">
</asp:DropDownList>
<asp:SqlDataSource ID="Streamdatad" runat="server" ConnectionString="<%$ ConnectionStrings:SMIS2022ConnectionString %>" SelectCommand="SELECT [Stream] FROM [Streamdata]"></asp:SqlDataSource>
</td>
<td class="auto-style26">
<asp:DropDownList ID="Sexd" runat="server" DataSourceID="Sexddd" DataTextField="TYPE" DataValueField="TYPE">
</asp:DropDownList>
<asp:SqlDataSource ID="Sexddd" runat="server" ConnectionString="<%$ ConnectionStrings:SMIS2022ConnectionString %>" SelectCommand="SELECT [TYPE] FROM [SEX]"></asp:SqlDataSource>
</td>
<td class="auto-style27">
<asp:TextBox ID="Status" runat="server" Width="77px"></asp:TextBox>
</td>
<td class="auto-style28">
<asp:DropDownList ID="SudentType" runat="server">
<asp:ListItem></asp:ListItem>
<asp:ListItem>BOARDER</asp:ListItem>
<asp:ListItem>DAY</asp:ListItem>
</asp:DropDownList>
</td>
<td class="auto-style28">
<asp:TextBox ID="account" runat="server" Width="77px"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="auto-style33" colspan="1">
<table border="1" class="auto-style19">
<tr>
<td class="auto-style20">Search Name</td>
<td> </td>
</tr>
<tr>
<td class="auto-style29">
<asp:TextBox ID="txtSearch" runat="server" style="margin-left: 0px" Width="155px"></asp:TextBox>
</td>
<td class="auto-style30">
<asp:Button ID="Button1" runat="server" Text="Save Data" />
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="auto-style32" style="background-color: #FFFFFF">
<asp:GridView ID="SearchGrid" runat="server" AutoGenerateColumns="False" ItemStyle-Width="Auto" PageSize="25" ShowFooter="True" ShowHeaderWhenEmpty="True" Width="650px">
<Columns>
<asp:TemplateField HeaderText="Account">
<EditItemTemplate>
<asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("ADMNO") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="account0" runat="server" Text='<%# Bind("ADMNO") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Student Name">
<EditItemTemplate>
<asp:TextBox ID="Names" runat="server"></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="Namesf" runat="server" Text='<%# Eval("Name") %>'></asp:TextBox>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="Name" runat="server" Text='<%# Eval("Name") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Class">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Class") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="Classtf" runat="server" DataSourceID="Classdt" DataTextField="CLASS" DataValueField="CLASS">
</asp:DropDownList>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="Class" runat="server" Text='<%# Bind("Class") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Stream">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Stream") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="Streamdf" runat="server" DataSourceID="Streamdatad" DataTextField="Stream" DataValueField="Stream">
</asp:DropDownList>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="Stream" runat="server" Text='<%# Bind("Stream") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sex">
<EditItemTemplate>
<asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Sex") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="Sexdf" runat="server" DataSourceID="Sexddd" DataTextField="TYPE" DataValueField="TYPE">
</asp:DropDownList>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="colour" runat="server" Text='<%# Bind("Sex") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Status">
<EditItemTemplate>
<asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("Status") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Status0" runat="server" Text='<%# Bind("Status") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sudent Type" SortExpression="studenttype">
<EditItemTemplate>
<asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("studenttype") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="SudentType0" runat="server">
<asp:ListItem></asp:ListItem>
<asp:ListItem>BOARDER</asp:ListItem>
<asp:ListItem>DAY</asp:ListItem>
</asp:DropDownList>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("studenttype") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:ButtonField CommandName="Staff" HeaderText="Select" Text="Select" />
</Columns>
</asp:GridView>
</td>
</tr>
</table>
</asp:Panel>
</div>
</form>
</body>
</html>
