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

Question

如题所述

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