Question

C#连接数据库查询语句.关于使用变量

如String in=so.ToString();
…"SELECT * FROM article WHERE 接变量";
怎么弄？我还是新手，望好心说通俗点！

Answer 1

//先申明变量string name;//Sql语句string sql="select * from table_name where coum_name='"+name+"'";//类同string sql=format.toString("select * from table_name where coum_name='{0}'",name);//执行Sql语句sqlconnection con =new sqlconnection(连接数据库);sqlAdapter dapt=new SqlAdapter(sql,con);Dataset ds=new Dataset();dapt.fill(ds);return ds.table[0];

Answer 2

查询数据库有好多种方法，就按你这个思路的话就这样(假设in是你的变量)："SELECT * FROM article WHERE price >" + in

Answer 3

SELECT * FROM article WHERE 字段=条件SELECT * FROM article WHERE 字段='"+id+"';