Question

三层架构中 textBox显示数据库的内容 代码

Answer 1

UI层:
public void SearchStu()
{
StudentInfo studentinfo = StuSyBLL.StuManageBLL.SearchStuInfo();
lblSex.Text = "男";
if (studentinfo.s_Sex != true)
{
lblSex.Text = "女";
}
lblName.Text = studentinfo.s_Name;
lblStuNum.Text = studentinfo.s_StuNo;
lblNation.Text = studentinfo.s_Nation;
lblIdCard.Text = studentinfo.s_IdCard;
lblCome.Text = studentinfo.s_Birthplace;
lblBeginTime.Text = studentinfo.s_EntranTime.ToString();
lblBirthday.Text = studentinfo.s_Brithday.ToString();

}
你把Label 改成textbox的就OK了

BLL层：
public static StudentInfo SearchStuInfo()
{
string strSql = string.Format("select * from [StudentManage].[dbo].[StudentInfo] where s_StuNo='v094926421123'");
return StuSyDAL.StuManageDAL.SearchStuInfo(strSql);
}

DAL层：
public static StudentInfo SearchStuInfo(string strSql)
{
StudentInfo studentinfo = new StudentInfo();

SqlDataReader dr = SQLHelper.ExecuteReader(strSql);
while (dr.Read())
{

studentinfo.c_ID = int.Parse(dr["c_ID"].ToString());
studentinfo.s_Name = dr["s_Name"].ToString();
studentinfo.s_StuNo = dr["s_StuNo"].ToString();
studentinfo.s_Sex = Convert.ToBoolean(dr["s_Sex"]);
studentinfo.s_Brithday =Convert.ToDateTime(dr["s_Brithday"]);
studentinfo.s_Birthplace = dr["s_Birthplace"].ToString();
studentinfo.s_IdCard = dr["s_IdCard"].ToString();
studentinfo.s_Nation = dr["s_Nation"].ToString();
studentinfo.s_EntranTime = Convert.ToDateTime(dr["s_EntranTime"]);

}
return studentinfo;
}

Answer 2

string MySql=“sql语句”
SqlCommand SqlCom = new SqlCommand(MySql, "数据库连接");
SqlDataReader dr = SqlCom.ExecuteReader();
if (dr.Read())
{
this.textBox.Text = dr["列名"].ToString();
}
dr.Close();