参数只能用在查询、插入、删除、值中,不能用在表名、字段名上
using(sqlcommand cmd=new sqlCommand())
{
cmd.commandtext="select * form a where a1=@a1 and a2=@a2";
cmd.parameters.add(new sqlparameter(@a1,"aa"));
cmd.parameters.add(new sqlparameter(@a2,"bb"));
}
参数只能用在查询、插入、删除、值中,不能用在表名、字段名上
using(sqlcommand cmd=new sqlCommand())
{
cmd.commandtext="select * form a where a1=@a1 and a2=@a2";
cmd.parameters.add(new sqlparameter(@a1,"aa"));
cmd.parameters.add(new sqlparameter(@a2,"bb"));
}