📄 d.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="D.aspx.cs" Inherits="main_D" %>
<%@ Register TagPrefix="L" TagName="left" Src="../inc/left.ascx" %>
<%@ Register TagPrefix="H" TagName="Header" Src="../inc/Header.ascx" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<head>
<style type="text/css">
.style1
{
width: 469px;
}
.style2
{
width: 646px;
}
.style3
{
width: 91px;
}
.newStyle1
{
position: fixed;
}
.newStyle2
{
position: fixed;
top: 422px;
left: 794px;
}
.style4
{
width: 97%;
}
</style>
</head>
<script runat="server">
OleDbConnection Conn;
protected void Page_Load(Object Src, EventArgs E ) {
String Provider,DataBase,ConnStr,SQL;
Provider = "Microsoft.Jet.OLEDB.4.0;";
DataBase = Server.MapPath("wwwlink.mdb");
ConnStr = "Provider="+Provider+"Data Source="+DataBase;
Conn = new OleDbConnection(ConnStr);
}
public void button_click(Object Sender,EventArgs e)
{
string strSQL = "Insert Into finance(姓名,人数,住址,电话,描述,线路,时间)values("
+ "'" + 姓名.Text + "',"
+ "'" + 人数.Text + "',"
+ "'" + 住址.Text + "',"
+ "'" + 电话.Text + "',"
+ "'" + 描述.Text + "',"
+ "'" + grade.SelectedItem.Text + "',"
+ "'" + DateTime.Now + "')";
OleDbCommand cm = new OleDbCommand(strSQL, Conn);
Conn.Open();
try {
cm.ExecuteNonQuery();
message.Text = "<b>添加成功</b>";
}
catch (OleDbException de) {
message.Text = strSQL+de+"添加失败";
message.Style["color"]="red";
}
cm.Connection.Close();
}
</script>
<html>
<body background="../2007111617041626.gif">
<form id="Form1" runat="server">
<H:HEADER id="Header" runat="server" />
<TABLE id="Table1" style="HEIGHT: 252px; width: 90%;" cellSpacing="1"
cellPadding="1" align="center"
border="0">
<tr>
<td class="style3" >
<L:LEFT id="left" runat="server" />
</td>
<td class="style2">
<h4 align="center">用户预定线路</h4>
<center>
<table border="1" cellpading="2" cellspacing="0" class="style4">
<tr>
<td>用户姓名：</td>
<td class="style1"><asp:textbox id="姓名" runat="server" Width="248px"/>
<asp:RequiredFieldValidator id="Require1" ControlToValidate="姓名" ErrorMessage="必须输入您的姓名" Display="Static" runat="server" /></td>
</tr>
<tr>
<td>选择线路：</td>
<td class="style1">
<asp:dropdownlist id="grade" runat="server" DataSourceID="AccessDataSource1"
DataTextField="URL" DataValueField="URL">
</asp:dropdownlist >
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/wwwlink.mdb" SelectCommand="SELECT [URL] FROM [link]">
</asp:AccessDataSource>
</td>
</tr>
<tr>
<td>人数：</td>
<td class="style1"><asp:textbox id="人数" columns="40" runat="server"/>
<asp:RequiredFieldValidator id="RequiredFieldValidator1" ControlToValidate="人数" ErrorMessage="必须输入人数" Display="Static" runat="server" /></td>
</tr>
<tr>
<td>住址：</td>
<td class="style1"><asp:textbox id="住址" columns="40" runat="server"/>
<asp:RequiredFieldValidator id="RequiredFieldValidator2" ControlToValidate="住址" ErrorMessage="必须输入地址" Display="Static" runat="server" /></td>
</tr>
<tr>
<td>电话：</td>
<td class="style1"><asp:textbox id="电话" columns="40" runat="server"/>
<asp:RequiredFieldValidator id="RequiredFieldValidator3" ControlToValidate="电话" ErrorMessage="必须输入联系电话" Display="Static" runat="server" /></td>
</tr>
<tr>
<td>请填入选择的导游及车队：</td>
<td class="style1"><asp:textbox id="描述" columns="40" runat="server" Height="101px"
TextMode="MultiLine" Width="248px"/>
<asp:RequiredFieldValidator id="RequiredFieldValidator4" ControlToValidate="描述" ErrorMessage="必须输入选择" Display="Static" runat="server" /></td>
</tr>
<tr>
<td></td>
<td class="style1"><asp:button id="Enter" text=" 提 交 " onClick="button_click" runat="server"/></td>
</tr>
</table>
<asp:Label id="message" runat="server"/>
</center>
</td>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -