📄 xiugaikehuxinxi.aspx
字号:
<%@ Page Language="c#" CodeBehind="xiugaikehuxinxi.aspx.cs" AutoEventWireup="false" Inherits="software.xiugaikehuxinxi" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<body text="#ffffff" bgColor="#339933">
<script runat="server">
private void submit_button2(object sender, System.EventArgs e)
{
Response.Redirect("WebForm2.aspx");
}
void submit_Click1(Object sender,EventArgs e) {
SqlConnection Conn1;
Conn1=new
SqlConnection("server=HWADEE-1G30;database=HTserverData;uid=sa;pwd=''");
Conn1.Open();
string sql="select CustID,CustName,CustSex,CustAge,CustIC,RoomNum,PreM from CustData";
if (kehu.Text!="")
sql="select CustID,CustName,CustSex,CustAge,CustIC,RoomNum,PreM from CustData where CustID ='"+kehu.Text+"'";
SqlCommand Comm1=new SqlCommand(sql,Conn1);
SqlDataReader dr=Comm1.ExecuteReader();
dg.DataSource=dr;
dg.DataBind();
Conn1.Close();
}
void submit_Click(Object sender,EventArgs e) {
SqlConnection Conn;
Conn=new
SqlConnection("server=HWADEE-1G30;database=HTserverData;uid=sa;pwd=''");
Conn.Open();
String strSQL="select * from CustData";
if(shenfenzheng.Text!=""&&name.Text!=""&&sex.Text!=""&&age.Text!=""&&iccard.Text!=""&&roomno.Text!=""&&yufujin.Text!="")
strSQL="UPDATE CustData SET CustID='"+shenfenzheng.Text+"',CustName='"+name.Text+"',CustSex='"+sex.Text+"',CustAge='"+age.Text+"',CustIC='"+iccard.Text+"',RoomNum='"+roomno.Text+"',PreM='"+yufujin.Text+"' where CustID='"+kehu.Text+"'";
SqlCommand Comm=new SqlCommand(strSQL,Conn);
Comm.ExecuteNonQuery();
Conn.Close();
Response.Write("操作成功！");
}
</script>
<P><FONT face="宋体">请输入要查询的客户身份证号：
<form id="Form1" name="myform" runat="server">
<asp:textbox id="kehu" runat="server" size="20"></asp:textbox>
<asp:button id="Button1" onclick="submit_Click1" runat="server" Text="查询"></asp:button>
</FONT>
<asp:datagrid id="dg" runat="server"></asp:datagrid></P>
<P><FONT face="宋体"></FONT> </P>
<P><FONT face="宋体">身份证号：</FONT>
<asp:textbox id="shenfenzheng" runat="server" size="20"></asp:textbox><FONT face="宋体"><BR>
</FONT><FONT face="宋体">姓 名：</FONT>
<asp:textbox id="name" runat="server" size="20"></asp:textbox><BR>
<FONT face="宋体">性 别：</FONT>
<asp:textbox id="sex" runat="server" size="5"></asp:textbox><BR>
<FONT face="宋体">年 龄：</FONT>
<asp:textbox id="age" runat="server" size="4"></asp:textbox><BR>
<FONT face="宋体">IC 卡：</FONT>
<asp:textbox id="iccard" runat="server" size="10"></asp:textbox><BR>
<FONT face="宋体">房 号：</FONT>
<asp:textbox id="roomno" runat="server" size="4"></asp:textbox><FONT face="宋体"><BR>
预付金额： <asp:textbox id="yufujin" runat="server" size="6"></asp:textbox>
<asp:button id="Button2" onclick="submit_button2" runat="server" Text="返回" Width="72px" Height="28px"></asp:button></FONT><BR>
</FONT><asp:button id="submit" onclick="submit_Click" runat="server" Text="修改"></asp:button><BR>
</P>
</FORM>
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -