获取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#