使用AJAX来处理学生数据
一,题目
请根据如下Universtiy.mdb数据库,使用AJAX来处理学生数据的查询、新增、修改、删除数据的页面功能(mdb数据库会另外提供):
二,涉及知识
AJAX
数据库
用Access数据库,添加数据库文件即可。
正常使用数据库语句!
三,运行截图
增:
查:
改:
删:
四,代码实现
html
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="1-sutdent.aspx.cs" Inherits="homework7._1_sutdent" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<div align="center" style="border: medium groove #800080; padding: 2px; margin: auto;">
<p align="center" style="font-family: Cambria, Cochin, Georgia, Times, 'Times New Roman', serif; font-size: larger; font-weight: bolder; color: #800080">Student's Information</p>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" ChildrenAsTriggers="True">
<ContentTemplate>
<table runat="server" id="table1">
<tr>
<td class="auto-style2">StdSSN:</td>
<td>
<asp:TextBox ID="StdSSN_text" runat="server" Width="400px" Enabled="False"></asp:TextBox>
</td>
<td rowspan="10">
<asp:Button ID="Button_MoveFirst" runat="server" Text="Move First" Width="156px" OnClick="Button_MoveFirst_Click" /><br />
<asp:Button ID="Button_MovePrevious" runat="server" Text="Move Previous" Width="156px" OnClick="Button_MovePrevious_Click" /><br />
<asp:Button ID="Button_MoveNext" runat="server" Text="Move Next" Width="156px" OnClick="Button_MoveNext_Click" /><br />
<asp:Button ID="Button_MoveLast" runat="server" Text="Move Last" Width="156px" OnClick="Button_MoveLast_Click" />
</td>
</tr>
<tr>
<td class="auto-style2">StdFirstName:</td>
<td>
<asp:TextBox ID="StdFirstName_text" runat="server" Width="400px"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style2">StdLastName:</td>
<td>
<asp:TextBox ID="StdLastName_text" runat="server" Width="400px"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style2">StdCity:</td>
<td>
<asp:TextBox ID="StdCity_text" runat="server" Width="400px"></asp:TextBox>
</td>
</tr>
<tr>
<td class="auto-style2">StdState:</td>
<td>
<asp:TextBox ID="