SQLDAL:
private const string SQL_SELECT_JBXX = "select jbxx_xm from TdrSys_jbxx where jbxx_sfzh=@sfzh"; public IList<TdrSys_jbxx> searchjbxxBySfzh(string sfzh)
{
IList<TdrSys_jbxx> XinXi = new List<TdrSys_jbxx>();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["link"].ConnectionString);
cn.Open();
SqlCommand cmd = new SqlCommand(SQL_SELECT_JBXX, cn);
cmd.Parameters.AddWithValue("@sfzh", sfzh);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow myDataRow in dt.Rows)
{
var obj = new TdrSys_jbxx();
XinXi.Add(obj);
}
return XinXi;
}
aspx.cs:
if (!IsPostBack)
{
IList<TdrSys_jbxx> list = new List<TdrSys_jbxx>();
string Num = Session["sfzh"].ToString();
BTdrSys_jbxx UserID = new BTdrSys_jbxx();
list = UserID.searchjbxxBySfzh(Num);
foreach(TdrSys_jbxx xx in list)
{
xm.Text += xx.jbxx_xm;
}
}为啥xm这个lable得不到值,帮我看看,帮我改一下,感激不尽!
private const string SQL_SELECT_JBXX = "select jbxx_xm from TdrSys_jbxx where jbxx_sfzh=@sfzh"; public IList<TdrSys_jbxx> searchjbxxBySfzh(string sfzh)
{
IList<TdrSys_jbxx> XinXi = new List<TdrSys_jbxx>();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["link"].ConnectionString);
cn.Open();
SqlCommand cmd = new SqlCommand(SQL_SELECT_JBXX, cn);
cmd.Parameters.AddWithValue("@sfzh", sfzh);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow myDataRow in dt.Rows)
{
var obj = new TdrSys_jbxx();
XinXi.Add(obj);
}
return XinXi;
}
aspx.cs:
if (!IsPostBack)
{
IList<TdrSys_jbxx> list = new List<TdrSys_jbxx>();
string Num = Session["sfzh"].ToString();
BTdrSys_jbxx UserID = new BTdrSys_jbxx();
list = UserID.searchjbxxBySfzh(Num);
foreach(TdrSys_jbxx xx in list)
{
xm.Text += xx.jbxx_xm;
}
}为啥xm这个lable得不到值,帮我看看,帮我改一下,感激不尽!
这个类中重的初始化的代码,拿出来看看
public interface ITdrSys_jbxx
{
/// <summary>
/// 通过身份证号(主键)查找对应的一条信息,返回该条信息中所有字段的内容。
/// </summary>
/// <param name="sfzh">身份证号</param>
/// <returns>返回一个TdrSys_Jbxx数据模型的实例。</returns>
IList<TdrSys_jbxx> searchjbxxBySfzh(string sfzh); }
MODEL:
{
/// <summary>
/// 实现对报名信息操作的业务实体
/// </summary>
[Serializable] public class TdrSys_jbxx
{
// 声明字段
private string jbxx_Sfzh;
private string jbxx_Xm;
private string jbxx_Xb;
private string jbxx_Nl;
/// <summary>
/// 构造函数
/// </summary>
public TdrSys_jbxx() { } /// <summary>
/// 构造函数2
/// </summary>
/// <param name="Jbxx_sfzh">身份证号</param>
/// <param name="Jbxx_xm">报考专业号</param>
/// <param name="Jbxx_xb">考场号</param>
/// <param name="Jbxx_nl">座位号</param> public TdrSys_jbxx(string Jbxx_sfzh, string Jbxx_xm, string Jbxx_xb, string Jbxx_nl)
{
this.jbxx_Sfzh = Jbxx_sfzh;
this.jbxx_Xm = Jbxx_xm;
this.jbxx_Xb = Jbxx_xb;
this.jbxx_Nl = Jbxx_nl;
}
//实现属性
public string jbxx_sfzh
{
get { return jbxx_Sfzh; }
set { jbxx_Sfzh = value; }
}
public string jbxx_xm
{
get { return jbxx_Xm; }
set { jbxx_Xm = value;}
}
public string jbxx_xb
{
get { return jbxx_Xb; }
set { jbxx_Xb = value; }
}
public string jbxx_nl
{
get { return jbxx_Nl; }
set { jbxx_Nl = value; }
}
}
}