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驱动的问题。