OleDBConnection连接SQL Server表时，OleDbCommand在使用Update语句时，使用参数出错

 

System.Data.OleDb. OleDBConnection OleDbCNN;

System.Data.OleDb. OleDbCommand OleDbCMD ;

string cs;

cs = "Provider=sqloledb;Data Source=XMH//mySQL;Initial Catalog=DataSql; Integrated Security=SSPI;"

OleDbCNN = new System.Data.OleDb. OleDBConnection(CNNStr);

cs = "UPDATE TabSql set XM=@name, XB=@sex where zkzh= ’ 0640240101 ’ "

OleDbCMD = new System.Data.OleDb. OleDbCommand();

OleDbCMD.CommandType = CommandType.Text;

OleDbCMD.Connection = OleDbCNN;

OleDbCMD.CommandText = cs;

OleDbCMD.Parameters.Add( "@name", OleDbType.VarChar);

OleDbCMD.Parameters[ "@name"].Value = " 张山";

OleDbCMD.Parameters.Add( "@name", OleDbType. VarChar);

OleDbCMD.Parameters[ "@sex"].Value = " 男";

OleDbCNN.Open();

OleDbCMD.ExecuteNonQuery();

       运行时出现“ @name变量未声明”错误。使用System.Data.SqlClient. SqlConnection、 SqlCommand、SqlDataReader时则不存在此问题。

估计是 SqlOleDb驱动的问题。