使用Dropdownlist的查询问题（初学者）！

Question

mycommand1.paremeters["@fblb"]=aaa;
==>
mycommand1.paremeters["@aaa"]=aaa;或者不使用参数了：
string aaa=DropDownList.SelectItem.Text;
string listcmd="select * from fbdj where fblb='"+aaa+"'";
oledbcommand mycommand1=new oledbcommand(listcmd,oledbconnection);
oledbconnection.open();
oledateReader myReader=mycommand.Excutereader();

Answer 1

试一下：把这一句换成下面的：mycommand1.paremeters["@fblb"]=aaa;myCommand1.Parameters.Add(new SqlParameter("@aaa", SqlDbType.NVarChar, 50));
myCommand1.Parameters["@aaa"].Value=aaa;