小弟现在想取DataSet中Address字段中的值,SelectMember只返回一条记录,求教还有这条记录如何在aspx页面中显示,不用<%# DataBinder.Eval(Container,"DataItem.Address")%>
public void MemberDetailsBind(){
datalist1.DataSource = MemberManage.DisplayMemberDetails(int.Parse(Request["id"].ToString()));
datalist1.DataBind();
}public DataSet DisplayMemberDetails(int uid)
{
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "SelectMember";
cmdToExecute.CommandType = CommandType.StoredProcedure;
DataSet toReturn = new DataSet();
cmdToExecute.Connection = dbConnecion();
cmdToExecute.Parameters.Add(new SqlParameter("@id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,"U_Id",DataRowVersion.Proposed,uid));
SqlDataAdapter adapter = new SqlDataAdapter(cmdToExecute);
adapter.Fill(toReturn,"U_Id");
adapter.Dispose();
return toReturn;
}
public void MemberDetailsBind(){
datalist1.DataSource = MemberManage.DisplayMemberDetails(int.Parse(Request["id"].ToString()));
datalist1.DataBind();
}public DataSet DisplayMemberDetails(int uid)
{
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "SelectMember";
cmdToExecute.CommandType = CommandType.StoredProcedure;
DataSet toReturn = new DataSet();
cmdToExecute.Connection = dbConnecion();
cmdToExecute.Parameters.Add(new SqlParameter("@id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,"U_Id",DataRowVersion.Proposed,uid));
SqlDataAdapter adapter = new SqlDataAdapter(cmdToExecute);
adapter.Fill(toReturn,"U_Id");
adapter.Dispose();
return toReturn;
}
解决方案 »
- 把表对象存放在Application对象中好吗?
- 2个ASP.NET(C#)网站登录的嵌入
- GRIDVIEW的一个疑问~速度揭贴~
- ☆☆☆ie7页面打开后怎样可以移出屏幕
- window.open导致Cookie丢失?
- 如果将datalist其中一列用图片显示?
- 请问如何在asp.net中调用传统的com 组件呢?
- 嵌套多次引用的正则式如何写 UBB的QUOTE功能
- 哪里有收POP3的组件???
- vs2019无法启用调试,按F5启动后出现闪退现象
- 怎样 截取 DataBinder.Eval(Container.DataItem,"review") 的前 5个字符呢?
- System.Environment.TickCount????
DataSet a = MemberManage.DisplayMemberDetails(int.Parse(Request["id"].ToString()));
DataSet b = MemberManage.DisplayMember(int.Parse(Request["id"].ToString()));