当前位置:编程学习 > C#/ASP.NET >>

获取access的数据到listview,遇到OleDbDataAdapter.Fill报错,什么问题???

获取access的数据到listview,遇到OleDbDataAdapter.Fill报错,什么问题???
 class Class1
    {
        
            public static OleDbConnection GreatConn()
            {
                string strConnection = "provider=Microsoft.ACE.OLEDB.12.0;data Source=" + Application.StartupPath + "/userdb.accdb;";
                OleDbConnection objCon = new OleDbConnection(strConnection);
                return objCon;
            }
            public static DataTable GetTabel(string strsql)
            {
                OleDbConnection Ocon = GreatConn();
                Ocon.Open();         //(access连接数据库的引擎问题,已解决,见文档说明部分)
                OleDbDataAdapter oda = new OleDbDataAdapter(strsql, Ocon);
                DataTable dt = new DataTable("uinfo");
                oda.Fill(dt);    //错误提示,No value given for one or more required parameters.  
                return dt;

            }
            public static void BindListView(ListView lv, DataTable dt) //将DataTable写入ListView
            {
                lv.Clear();
                lv.View = View.Details;
                lv.FullRowSelect = true;
                foreach (DataColumn dc in dt.Columns)
                {
                    lv.Columns.Add(dc.ColumnName);
                }
                foreach (DataRow dr in dt.Rows)
                {
                    ListViewItem lvi = new ListViewItem(dr[0].ToString());
                    lvi.SubItems.Add(dr[1].ToString());
                    lv.Items.Add(lvi);
                }
            }
        } --------------------编程问答-------------------- 根据提示错误应该是 参数没有赋值
补充:.NET技术 ,  C#
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,