OATest/UserWork/NewUserInfo.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 UserWork_NewUserInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Connection"]);
            con.Open();
            string sql = "select * from branch";
            SqlDataAdapter da = new SqlDataAdapter(sql, con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            Branch.DataSource = ds;
            Branch.DataTextField = "Branch";
            Branch.DataValueField = "Dutyid";
            Branch.DataBind();
            con.Close();
                SqlConnection con1 = new SqlConnection(ConfigurationManager.AppSettings["Connection"]);
                con1.Open();
                string sql1 = "select * from Employee where username='"+Session["UserName"].ToString()+"'";
                SqlCommand com1 = new SqlCommand(sql1, con1);
                SqlDataReader dr1 = com1.ExecuteReader();
                dr1.Read();    
                name.Text = dr1["name"].ToString();
                sex.Items.FindByValue(dr1["sex"].ToString()).Selected = true;
                Marry.Items.FindByValue(dr1["Marry"].ToString()).Selected = true;
                Branch.Items.FindByValue(dr1["Dutyid"].ToString()).Selected = true;
                Birthday.Text = dr1["Birthday"].ToString();
                Stature.Text = dr1["Stature"].ToString();
                Avoirdupois.Text = dr1["Avoirdupois"].ToString();
                cardtype.Text = dr1["cardtype"].ToString();
                cardid.Text = dr1["cardid"].ToString();
                Speciality.Text = dr1["Speciality"].ToString();
                workPhone.Text = dr1["workPhone"].ToString();
                movePhone.Text = dr1["movePhone"].ToString();
                HomePhone.Text = dr1["HomePhone"].ToString();
                xiaolingtong.Text = dr1["xiaolingtong"].ToString();
                Homeaddress.Text = dr1["Homeaddress"].ToString();
                Post.Text = dr1["Post"].ToString();
                url.Text = dr1["url"].ToString();
                Email.Text = dr1["Email"].ToString();
                qq.Text = dr1["qq"].ToString();
                msn.Text = dr1["msn"].ToString();

                con1.Close();