参数化的模糊查询

1.定义参数并赋值

SqlParameter par=new SqlParameter("@keyWords",SqlDbType.NVarChar);

par.Value="%"+keyWords+"%";

2.参数化查询语句

select name,age,class

from Student

where name like @keyWords