更新时间2018-05-04 12:40:06
string sql = "SELECT * FROM XM WHERE CPM LIKE 'F*'";
SqlConnection conn = new SqlConnection(connStr);
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
DataSet ds=new DataSet();
sda.Fill(ds,"XM");
DataTable dt = ds.Tables["XM"];
txt_count_chazhao.Text = dt.Rows[0]["CPM"].ToString();
数据库XM表的CPM项是FS,为什么我运行后显示错误并提示0行没有数据?请大神帮帮忙
标准的SQL语言的LIKE通配符是%不是*