当前位置: 代码迷 >> ASP.NET >> 数据库获取的值比较,该怎么处理
  详细解决方案

数据库获取的值比较,该怎么处理

热度:3469   发布时间:2013-02-25 00:00:00.0
数据库获取的值比较
string st = "Data Source=.;Initial Catalog=master;User ID=sa;password=123;";
  SqlConnection sjconn = new SqlConnection(st);
  //string sql = "Select * from Table1 where id='" + id + "'";
  string sql = "Select * from Table1 where yname='admin'";
  SqlCommand comm = new SqlCommand(sql, sjconn);
  sjconn.Open();
  SqlDataReader dr = comm.ExecuteReader();
  if (dr.Read())
  {
  if (dr["zeng"].ToString() == "否")
  {
  Response.Write("123");
  }
  }


这样比较有问题吗? 着急啊?问题就是不能比较啊

------解决方案--------------------------------------------------------
类型对不?
if (dr["zeng"].ToString().Trim() == "否")
 

------解决方案--------------------------------------------------------
string st = "Data Source=.;Initial Catalog=master;User ID=sa;password=123;";
SqlConnection sjconn = new SqlConnection(st);
string sql = "Select * from Table1 where yname='admin'";
SqlCommand comm = new SqlCommand(sql, sjconn);
sjconn.Open();
SqlDataReader dr = comm.ExecuteReader();
if(dr.Read())
{
if (dr["zeng"].ToString().Trim() == "否")
{
Response.Write("123");
}
 }
  相关解决方案