📄 homeholdinfo.aspx.cs
字号:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class homeholdinfo : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Convert.ToString(Session["code"]) == "")
{
Response.Redirect("../login.aspx");
}
if (!IsPostBack)
{
this.bind();
}
}
protected void bind()
{
BaseClass bc = new BaseClass();
//下拉列表枢的数据绑定
//收集传递过来的值
string ownerID = Session["code"].ToString();
string strsql = "select * from homehold where code='" + ownerID + "'";
SqlDataReader sda = bc.ExecRead(strsql);
if (sda.Read())
{ //绑定数据
labname.Text = sda["Name"].ToString();
labntel.Text = sda["tel"].ToString();
labcontact.Text = sda["contact"].ToString();
labmobile.Text = sda["mobile"].ToString();
labemail.Text = sda["Email"].ToString();
labcardID.Text = sda["cardID"].ToString();
labroomID.Text = sda["roomID"].ToString();
labunit.Text = sda["unit"].ToString();
labmemo.Text = sda["memo"].ToString();
txtuser.Text = sda["uid"].ToString();
bc.Closeconn();//关闭数据库连接
}
else
{
Response.Write("没有相关的源行 ");
return;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -