我有个LABLE 和一个BUTTON 点BUTTON将LABLE的内容显示为数据库中的某一个字段的值
以下BUTTON内代码string backid = Request.QueryString["id"];
try
{
string getAnswer ="select Answer from MatchInfo where id='"+backid+"'";
string c = System.Configuration.ConfigurationManager.ConnectionStrings["FootBallConnectionString3"].ToString();
SqlConnection con = new SqlConnection(c);
con.Open();
SqlCommand com = new SqlCommand(getAnswer,con);
DataSet set = new DataSet ();
SqlDataAdapter da = new SqlDataAdapter (com);
da.Fill(set);
this.Lhert.Text = set.Tables[0].Rows[0].ToString();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
结果显示 System.Data.DataRow 为什么啊
以下BUTTON内代码string backid = Request.QueryString["id"];
try
{
string getAnswer ="select Answer from MatchInfo where id='"+backid+"'";
string c = System.Configuration.ConfigurationManager.ConnectionStrings["FootBallConnectionString3"].ToString();
SqlConnection con = new SqlConnection(c);
con.Open();
SqlCommand com = new SqlCommand(getAnswer,con);
DataSet set = new DataSet ();
SqlDataAdapter da = new SqlDataAdapter (com);
da.Fill(set);
this.Lhert.Text = set.Tables[0].Rows[0].ToString();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
结果显示 System.Data.DataRow 为什么啊
改
this.Lhert.Text = set.Tables[0].Rows[0][0].ToString();