//个人信息 public Teacher_list SelfInfo(string id) { Teacher_list t = new Teacher_list(); conn = new SqlConnection(str); comd = new SqlCommand(String.Format(@"select teacherid,teaname,password from dbo.Teacher_list where teacherid='{0}'", id), conn); try { conn.Open(); SqlDataReader dr = comd.ExecuteReader(); if (dr.Read()) { t.name = dr["teaname"].ToString(); t.id = dr["teacherid"].ToString(); t.pwd = dr["password"].ToString(); } dr.Close(); } finally { conn.Close(); }; return(t); }
public void FormTeacher_Load(object sender, EventArgs e) { t = db.SelfInfo(Pass.passData); button2.BackgroundImage = Online_examination_system.Properties.Resources.QQ图片201912091545612; string lastname = t.name.ToString(); Lab_Prompt.Text = "尊敬的" + lastname.Substring(0, 1) + "老师,欢迎使用本系统!!"; DGV_Test.DataSource = db.TestManger().Tables["Examination_list"]; DGV_Topic.DataSource = db.TopicManger().Tables["TheQuestionBank"]; DGV_Result.DataSource = db.TestManger().Tables["Examination_list"]; DGV_CheckTest.DataSource = db.CheckTestManger().Tables["EndExamSocre"]; this.Com_Subject.DataSource = db.Subject().Tables["class_schedule"]; this.Com_Subject.DisplayMember = "coursename"; }