帮忙看看这个是什么原因?
帮忙分析一下为什么,谢谢!
执行结果总是报出如下错误:Must declare the variable '@LName'
程序如下:
------------------------------
static void Main(string[] args)
{
bool ret = true;
string connString = @"Provider=SQLOLEDB;uid=sa;pwd=;server=localhost;database=NETDB";
OleDbConnection myConn = new OleDbConnection(connString);
string sqlCmd = " UPDATE Lists SET Name = @LName ,Description = @LDesc WHERE ID = @LID ";
OleDbCommand myCmd = new OleDbCommand(sqlCmd, myConn);
myCmd.Parameters.Add(new OleDbParameter("LName",OleDbType.VarChar,12));
myCmd.Parameters["LName"].Value = "EE";
myCmd.Parameters.Add(new OleDbParameter("LDescr",OleDbType.VarChar,50));
myCmd.Parameters["LDescr"].Value = "BB";
myCmd.Parameters.Add(new OleDbParameter("LID",OleDbType.Integer,4));
myCmd.Parameters["LID"].Value = 1;
myCmd.Connection.Open();
try
{
int rowcommit = myCmd.ExecuteNonQuery();
Console.WriteLine("Update Row is:{0}",rowcommit);
}
catch (OleDbException ems)
{
Console.WriteLine("Update Error is :{0}",ems.Message);
ret = false;
}
finally
{
myCmd.Connection.Close();
}
}