送分拉~~~~~问个参数问题
private void Button1_Click(object sender, System.EventArgs e)
{
string con="Provider=sqloledb;database=BBS_base;server=localhost;uid=sa";
string sql="select * from dic_jg where jgname=@jgname";
OleDbConnection conn=new OleDbConnection(con);
OleDbCommand dc=new OleDbCommand(sql,conn);
dc.CommandType=CommandType.Text;
dc.Parameters.Add(new OleDbParameter("@jgname",OleDbType.VarChar,20));
dc.Parameters["@jgname"].Value="阿爸啊啊啊啊";
Response.Write(dc.CommandText);
}
为什么运行之后还是select * from dic_jg where jgname=@jgname,这个@jgname如何才能被替换呢?