📄 add.aspx

📁 旅游网站系统：在线统计人数
💻 ASPX
字号:
<%@ Register TagPrefix="L" TagName="left" Src="../inc/left1.ascx" %>
<%@ Register TagPrefix="H" TagName="Header" Src="../inc/Header.ascx" %>
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<head>
    <style type="text/css">
        .style1
        {
            width: 397px;
        }
        .style2
        {
            width: 646px;
        }
        .style3
        {
            width: 91px;
        }
        .newStyle1
        {
            position: fixed;
        }
        .newStyle2
        {
            position: fixed;
            top: 422px;
            left: 794px;
        }
    </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 link(sitename,URL,intro,grade,submit_date)values("
         +"'" +sitename.Text+"',"
         +"'" +URL.Text+"',"
          + "'" +intro.Text + "',"
         + Convert.ToInt32(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="../2007111617333560.jpg">
<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="left1" runat="server" />
				</td>
				<td class="style2">
	<h4 align="center">添加线路</h4>
	<center>
	<form runat="server">
	<table border="1" width="80%" cellpading="2" cellspacing="0">
		<tr>
			<td>行程时间：</td>
			<td class="style1"><asp:textbox id="sitename" runat="server" Width="249px"/>
			<asp:RequiredFieldValidator id="Require1" ControlToValidate="sitename" ErrorMessage="必须输入名称" Display="Static" runat="server" /></td>
		</tr>
		<tr>
			<td>线路：</td>
			<td class="style1"><asp:textbox id="URL" columns="40"  runat="server"/>
			<asp:RequiredFieldValidator id="Require2" ControlToValidate="URL" ErrorMessage="必须输入地址" Display="Static" runat="server" /></td>
		</tr>
		<tr>
			<td>导游，BUS：</td>
			<td class="style1"><asp:textbox id="intro" textmode="multiline" columns="40" rows="4" 
                    runat="server" Width="250px"/></td>
		</tr>
		<tr>
			<td>推荐评分：</td>
			<td class="style1">
			<asp:dropdownlist id="grade" runat="server">
				<asp:listitem>1</asp:listitem>
				<asp:listitem>2</asp:listitem>
				<asp:listitem selected="True">3</asp:listitem>
				<asp:listitem>4</asp:listitem>
				<asp:listitem>5</asp:listitem>
			</asp:dropdownlist >
			</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"/>
	                        <img alt="" class="newStyle2" src="../untitled.bmp" /></form>
	</center>
</td></body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -