查询语句如下:
string sql = "select * from xsxxb1 where xsxh='"+Selecttext.Text+"'";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.ExecuteNonQuery();
我要如何才能将查询到的结果输出到SC.text中呢?因为xsxxb1中有xsxh,xsxm,xsxb,等字段
谢谢
string sql = "select * from xsxxb1 where xsxh='"+Selecttext.Text+"'";
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.ExecuteNonQuery();
我要如何才能将查询到的结果输出到SC.text中呢?因为xsxxb1中有xsxh,xsxm,xsxb,等字段
谢谢
也就是:SQLDataReader myreader;
DataSet ds=new DataSet();
string sql = "select * from xsxxb1 where xsxh='"+Selecttext.Text+"'";
SqlCommand cmd = new SqlCommand(sql, cn);
myreader=cmd.ExecuteReader();
myreader.Fill(ds);
SC.text=ds.tables[0].Rows[0].ToString();
上面代码有问题