📄 butiankedan.aspx
字号:
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<body text="#ffffff" bgColor="#339933">
<% @ Page Language="C#" %>
<script runat="server">
private void submit_button2(object sender, System.EventArgs e)
{
Response.Redirect("WebForm2.aspx");
}
SqlConnection Conn;
protected void Page_Load(Object Src, EventArgs E ) {
Conn=new SqlConnection("server=HWADEE-1G30;database=HTserverData;uid=sa;pwd='' ");
Conn.Open();
if (!IsPostBack) BindGrid();
}
public void updata_Click(Object sender, EventArgs E) {
// String sex=lstAddr.SelectedItem.Value;
String strSQL = "insert into CustData (CustName,CustSex,CustAge,CustID,RoomNum,CustIC,PreM) Values ('"+Name.Text+"','"+lstAddr.SelectedItem.Value+"','"+Age.Text+"','"+CID.Text+"','"+RN.Text+"','"+IC.Text+"',' "+PM.Text+"')" ;
SqlCommand Comm=new SqlCommand(strSQL,Conn);
try {
Comm.ExecuteNonQuery();
Message.InnerHtml="<b>补填成功</b>";
Message.Style["color"]="blue";
}
catch (SqlException) {
Message.InnerHtml="<b>补填失败</b>";
Message.Style["color"]="red";
}
Conn.Close();
BindGrid();
}
public void BindGrid() {
SqlDataAdapter da = new SqlDataAdapter("select * from CustData",Conn);
DataSet ds = new DataSet();
da.Fill(ds);
dg.DataSource=ds;
dg.DataBind();
}
</script>
<h2>
补填客单</h2>
<hr>
<form id="Form1" runat="server">
<asp:button id="Button2" onclick="submit_button2" runat="server" Width="54px" Text="返回"></asp:button>
<table width="95%">
<tr>
<td vAlign="top">
<table style="FONT: 8pt verdana">
<tr>
<td bgColor="#aaaadd" colSpan="2">补填客单：
</td>
</tr>
<tr>
<td noWrap>姓名:</td>
<td><asp:textbox id="Name" runat="server"></asp:textbox></td>
</tr>
<tr>
<td noWrap>性别:</td>
<td><asp:dropdownlist id="lstAddr" runat="server" AutoPostBack="True">
<asp:ListItem value="男" selected="true">男</asp:ListItem>
<asp:ListItem value="女">女</asp:ListItem>
</asp:dropdownlist></td>
</tr>
<tr>
<td noWrap>年龄:</td>
<td><asp:textbox id="Age" runat="server"></asp:textbox></td>
</tr>
<tr>
<td noWrap>身份证号:</td>
<td><asp:textbox id="CID" runat="server"></asp:textbox></td>
</tr>
<tr>
<td noWrap>房间号:</td>
<td><asp:textbox id="RN" runat="server"></asp:textbox></td>
</tr>
<tr>
<td noWrap>IC卡号:</td>
<td><asp:textbox id="IC" runat="server"></asp:textbox></td>
</tr>
<tr>
<td noWrap>预付金:</td>
<td><asp:textbox id="PM" runat="server"></asp:textbox></td>
</tr>
<tr>
<td align="center" colSpan="2"><asp:button id="Button1" onclick="updata_Click" runat="server" text="补填"></asp:button></td>
</tr>
<tr>
<td align="center" colSpan="2"><span id="Message" runat="server" MaintainState="false"></span></td>
</tr>
</table>
</td>
<td vAlign="top"><asp:datagrid id="dg" runat="server" MaintainState="false" AutoGenerateColumns="false" HeaderStyle-BackColor="#aaaadd"
Font-Size="8pt" Font-Name="Verdana" CellSpacing="0" CellPadding="3" ShowFooter="false" BorderColor="black"
BackColor="#ccccff" Width="400">
<Columns>
<asp:BoundColumn HeaderText="姓名" DataField="CustName" />
<asp:BoundColumn HeaderText="性别" DataField="CustSex" />
<asp:BoundColumn HeaderText="年龄" DataField="CustAge" />
<asp:BoundColumn HeaderText="身份证号" DataField="CustID" />
<asp:BoundColumn HeaderText="房间号" DataField="RoomNum" />
<asp:BoundColumn HeaderText="IC卡号" DataField="CustIC" />
<asp:BoundColumn HeaderText="预付金" DataField="PreM" />
</Columns>
</asp:datagrid></td>
</tr>
</table>
</form>
<FONT face="宋体"> </FONT>
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -