Question

无法从"System.Data.OleDb.OleDbConnection"转换为"System.Data.SqlClient.SqlConnection"

用C#连接Access 2010 有个错误 无法从"System.Data.OleDb.OleDbConnection"转换为"System.Data.SqlClient.SqlConnection"
CDataBase.cs
public static bool UpdateDB(string sqlStr)
{
conn.Open();
OleDbCommand myCmd = new OleDbCommand(sqlStr, conn);
myCmd.CommandType = CommandType.Text;
myCmd.ExecuteNonQuery();
conn.Close();
return true;
界面代码
SqlCommand cmd = new SqlCommand(sqlStr, CDataBase.conn);
SqlDataReader sdr = cmd.ExecuteReader();

Answer 1

SqlCommand需要的是SqlConnection,而你传值的时候用的是OleDbCommand（CDataBase.conn）