急急急急急急急急急急急急!ListView要绑定Access数据库并显示里面的东西 请问各位大仙如何对ListView绑定Access数据库,并且显示里面的两栏内容!!!!!!!!!谢谢谢谢listviewaccess数据库 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1.读取ACCESS OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " + _Global.ConnectStrOfAccess + "test.mdb"); conn.Open(); string sqlString = "select * from t "; OleDbCommand oleDbCommand1 = new OleDbCommand(sqlString, conn); oleDbCommand1.CommandText = sqlString; OleDbDataReader reader = oleDbCommand1.ExecuteReader();//执行查询 if (reader.Read()) { } else { } 2.绑定listview DataTable dt= getdt(); this.LVData.Columns.Add("aaa", 70, HorizontalAlignment.Left); this.LVData.Columns.Add("bbb",100, HorizontalAlignment.Left); this.LVData.Columns.Add("ccc", 100, HorizontalAlignment.Left); this.LVData.Columns.Add("ddd", 140, HorizontalAlignment.Left); LVData.View = View.Details; string[] str = new string[4]; if (dt.Rows.Count != 0) { foreach (DataRow dr in dt.Rows) { str[0] = dr["autoID"].ToString(); str[1] = dr["PName"].ToString(); str[2] = dr["PEName"].ToString(); str[3] = dr["PComment"].ToString(); ListViewItem item = new ListViewItem(str, 0); LVData.Items.Add(item); } } ListView绑定不了数据 只能添加查询出数据后 一个单元格一个单元格的添加或是 New ListViewItem(string[] value) 请教一个office COM接口转换失败的问题 vs编译好使,浏览器访问iis虚拟目录,就无法访问数据库... 新手问题 有关于数据绑定的! Remoting事件问题 如何开发MSN插件 C#程序如何制作安装时可以打包安装一个sql桌面引擎? Winform自定义控件自定义属性显示问题 怎样重新组合字符串 问题很怪 在.net中能够扑获数据库的错误代码吗?就如在pb中。 C#CPU使用过高,求大神 c#鼠标绘制多边形
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " + _Global.ConnectStrOfAccess + "test.mdb");
conn.Open();
string sqlString = "select * from t ";
OleDbCommand oleDbCommand1 = new OleDbCommand(sqlString, conn); oleDbCommand1.CommandText = sqlString;
OleDbDataReader reader = oleDbCommand1.ExecuteReader();//执行查询
if (reader.Read())
{
}
else
{
}
DataTable dt= getdt(); this.LVData.Columns.Add("aaa", 70, HorizontalAlignment.Left);
this.LVData.Columns.Add("bbb",100, HorizontalAlignment.Left);
this.LVData.Columns.Add("ccc", 100, HorizontalAlignment.Left);
this.LVData.Columns.Add("ddd", 140, HorizontalAlignment.Left);
LVData.View = View.Details;
string[] str = new string[4];
if (dt.Rows.Count != 0)
{
foreach (DataRow dr in dt.Rows)
{
str[0] = dr["autoID"].ToString();
str[1] = dr["PName"].ToString();
str[2] = dr["PEName"].ToString();
str[3] = dr["PComment"].ToString();
ListViewItem item = new ListViewItem(str, 0);
LVData.Items.Add(item);
}
}
查询出数据后 一个单元格一个单元格的添加
或是 New ListViewItem(string[] value)