我用的是ASP.NET+sqlserver,数据库在设计时余额字段的类型设置的是decimal,现在我想把它读出来,怎样读取数据库中Decimal类型的值并赋值给label控件显示在页面上呢?求大仙帮忙!!~ Session["UserName"] = "yiyi";
SqlConnection conn1 = new SqlConnection("Data Source="";Integrated Security=True");
conn1.Open();
string sqlstr = "select Account from UserInfo where UserName='" + Session["UserName"] + "'";
SqlCommand cmd = new SqlCommand(sqlstr, conn1);
cmd.ExecuteNonQuery();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Label2.Text = dr.GetString(Convert.ToString(dr.GetOrdinal("Account")));
}
else
{
Label2.Text = "";
}
错误:无法将类型为“System.Decimal”的对象强制转换为类型“System.String”。
SqlConnection conn1 = new SqlConnection("Data Source="";Integrated Security=True");
conn1.Open();
string sqlstr = "select Account from UserInfo where UserName='" + Session["UserName"] + "'";
SqlCommand cmd = new SqlCommand(sqlstr, conn1);
cmd.ExecuteNonQuery();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Label2.Text = dr.GetString(Convert.ToString(dr.GetOrdinal("Account")));
}
else
{
Label2.Text = "";
}
错误:无法将类型为“System.Decimal”的对象强制转换为类型“System.String”。
dr.getDecmial("Account").ToString();