数据库增加记录的问题

[zclzy520]

conn.Open();
string sql="insert into resumeBasicInfo(UserID,myName,NameSecrecy)values(@UserID,@myName,@NameSecrecy);
OleDbCommand MyCommand = new OleDbCommand(sql,conn);

MyCommand.Parameters.Add(new OleDbParameter("@UserID",OleDbType.Integer));
MyCommand.Parameters["@UserID"].Value=Session["UserID"];

MyCommand.Parameters.Add(new OleDbParameter("@myName",OleDbType.VarChar));
MyCommand.Parameters["@myName"].Value=Request["myName"];

MyCommand.Parameters.Add(new OleDbParameter("@NameSecrecy",OleDbType.VarChar));
if(Request["NameSecrecy"]=="1")
{
MyCommand.Parameters["@NameSecrecy"].Value=1;
}
else
{
MyCommand.Parameters["@NameSecrecy"].Value=0;
}
MyCommand.ExecuteNonQuery();

总是提示我必须声明变量 '@UserID'
请帮忙帮我解决一下好吗？

[LoveCherry]

进行一下类型转换
MyCommand.Parameters.Add(new OleDbParameter("@UserID",OleDbType.Integer));
MyCommand.Parameters["@UserID"].Value=Convert.ToInt16(Session["UserID"]);

MyCommand.Parameters.Add(new OleDbParameter("@myName",OleDbType.VarChar));
MyCommand.Parameters["@myName"].Value=Request["myName"].ToString();

[zclzy520]

To LoveCherry(最讨厌你们这些要代码的了,一点技术含量都灭有)
已经转换了啊，还是不行啊

[athossmth]

MyCommand.Parameters["@UserID"].Value=Session["UserID"];
========〉
MyCommand.Parameters["@UserID"].Value=ConvertTo.Int32(Session["UserID"].ToString());

[doubon]

string sql="insert into resumeBasicInfo(UserID,myName,NameSecrecy)values(@UserID,@myName,@NameSecrecy);

-->
string sql="insert into resumeBasicInfo(UserID,myName,NameSecrecy)values(@UserID,@myName,@NameSecrecy)";

少个引号“"”

[SeeSunSet]

string sql="insert into resumeBasicInfo(UserID,myName,NameSecrecy)values(@UserID,@myName,@NameSecrecy)";

[WillSmart]

Session["UserID"]数据类型要转换一下

[ycy589]

@UserID变量,是不是要写在存储过程里?

http://community.csdn.net/Expert/topic/3648/3648607.xml?temp=.465481

[安德鲁飞机]

在存储过程里面声明