Question

C# 连接Access数据库时出错；错误提示：标致表达式中数据类型不匹配

sqlcmd.ExecuteReader();执行时出错， 错误提示：标致表达式中数据类型不匹配 程序代码： string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;"; strConnection += @"Data Source=C:\Users\xiaodong2\Desktop\PathAna\PathAna\32.mdb"; OleDbConnection objConnection = new OleDbConnection(strConnection); objConnection.Open(); string sql = "SELECT [Id] FROM [load] WHERE [begin] = @begin"; OleDbParameter oleParam = new OleDbParameter("begin", "A"); sqlcmd = new OleDbCommand(sql, objConnection); sqlcmd.Parameters.Add(oleParam); reader = sqlcmd.ExecuteReader();

Answer 1

提示已经很明显了,请自行检查下sql语句中参数和类型是否匹配 在NET中执行sQL语句出错一般都是语法或者类型的错误，多注意就OK了