locked
请帮忙看看这个错误是怎么回事 RRS feed

  • 问题

  • 麻烦大家帮忙看看怎么老是显示这句错误: OleDbCommand cmd = new OleDbCommand(sqlstr, conn);提示信息是:无法从OleDbConnection 转换为system.data.oledb.oledb OleDbConnection

    using System;
    using System.Collections.Generic;
    using System.Data.OleDb;
    using System.Drawing;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;

    ……

    ……

    conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" +MapPath("App_Data /assumpsit.accdb)+"'");
                        conn.Open();
                        if (user_id == "" || user_password == "")
                        { Response.Redirect("login.aspx?mess=密码或工号必须填写"); }

                        try //检查是否合法用户
                        {

                            string sqlstr = "select * from teacher where 工号='" + user_id + "' and 密码='" + user_password + "'";
                            OleDbCommand cmd = new OleDbCommand(sqlstr, conn);
                            rs = cmd.ExecuteReader();

    2013年12月21日 12:30

答案

  • 你好,楼主

    看你代码应该没有什么问题,我照着你的程序写了个demo,跑起来ok. 楼主你试下我的代码呢:

    internal void Execute()
            {
    
                OleDbConnection objOleDbCon = null;
                OleDbCommand objOleDbCmd = new OleDbCommand();
                OleDbDataAdapter objOleDbDataAdapter = new OleDbDataAdapter();
    
                string xConnStr = "";
                //xConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
                xConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\v-minbao\\Desktop\\SQL\\S20132011.accdb";
    
    
                objOleDbCon = new OleDbConnection(xConnStr);
                objOleDbCon.Open();
                try
                {
                    objOleDbCmd = new OleDbCommand("SELECT * FROM tblBestemming2WNP", objOleDbCon);
                    objOleDbDataAdapter = new OleDbDataAdapter(objOleDbCmd);
                    DataTable dt = new DataTable();
                    objOleDbDataAdapter.Fill(dt);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally { objOleDbCon.Close(); }
            }
    文件换成你的文件,查询语句也换成你的就可以了.

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    2013年12月23日 3:36
    版主