?? 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 + -