我有三个lable
protected System.Web.UI.HtmlControls.HtmlGenericControl sort;
protected System.Web.UI.HtmlControls.HtmlGenericControl name;
protected System.Web.UI.HtmlControls.HtmlGenericControl price;然后从数据库找到一条记录
int m_id=Convert.ToInt32(Request.QueryString["m_id"]);
SqlConnection part=new SqlConnection("server=.;uid=user;pwd=password;database=pubs;");
part.Open(); SqlCommand s=new SqlCommand("select * from merchandise where m_id="+m_id+"",part);
SqlDataReader sd=s.ExecuteReader();
然后将找到的记录的字段值分别在三个lable中显示 该怎样写
protected System.Web.UI.HtmlControls.HtmlGenericControl sort;
protected System.Web.UI.HtmlControls.HtmlGenericControl name;
protected System.Web.UI.HtmlControls.HtmlGenericControl price;然后从数据库找到一条记录
int m_id=Convert.ToInt32(Request.QueryString["m_id"]);
SqlConnection part=new SqlConnection("server=.;uid=user;pwd=password;database=pubs;");
part.Open(); SqlCommand s=new SqlCommand("select * from merchandise where m_id="+m_id+"",part);
SqlDataReader sd=s.ExecuteReader();
然后将找到的记录的字段值分别在三个lable中显示 该怎样写
sort.Text =sd["字段1"].ToString();
name.Text =sd["字段2"].ToString();
price.Text=sd["字段3"].ToString();
异常详细信息: System.InvalidOperationException: 在没有任何数据时进行无效的读取尝试。 这样的错误.不知道是不是我的sql语句有问题,我改成SqlCommand s=new SqlCommand("select * from merchandise where m_id='"+m_id+"'",part);错语也是一样的.