我是想用listview把放在DataTable里面的东西显示出来,
我用dataGrid这样就可以了
Data myData = new Data(); //引用DATA.CS里面的
dataGrid1.SetDataBinding(myData.GetDataSet(),"dtproperties");
但我不知道用ListView怎么搞??我是用了几个层的,
用SQL.CS专门做底层是数据库连接的,主要代码是这样:
public OleDbConnection OpenConn()
{
string strConn = "调用数据库";
myConn = new OleDbConnection(strConn);
myConn.Open();
return myConn; }
还有的一个DATA.CS是逻辑层,用来操作数据库的,代码大概这样:
public DataSet GetDataSet()
{
DataSet myData = new DataSet();
Sql mySql = new Sql();
OleDbConnection myConn = mySql.OpenConn();
string strSql = "SELECT * FROM dtproperties";
OleDbDataAdapter myAdapter = new OleDbDataAdapter(strSql,myConn);
myAdapter.Fill(myData,"dtproperties");
myAdapter.Dispose();
mySql.CloseConn();
return myData;
}
}
各位达人能够给小弟说说怎么用listview显示数据吗???(最好有代码) 谢谢~~~
我用dataGrid这样就可以了
Data myData = new Data(); //引用DATA.CS里面的
dataGrid1.SetDataBinding(myData.GetDataSet(),"dtproperties");
但我不知道用ListView怎么搞??我是用了几个层的,
用SQL.CS专门做底层是数据库连接的,主要代码是这样:
public OleDbConnection OpenConn()
{
string strConn = "调用数据库";
myConn = new OleDbConnection(strConn);
myConn.Open();
return myConn; }
还有的一个DATA.CS是逻辑层,用来操作数据库的,代码大概这样:
public DataSet GetDataSet()
{
DataSet myData = new DataSet();
Sql mySql = new Sql();
OleDbConnection myConn = mySql.OpenConn();
string strSql = "SELECT * FROM dtproperties";
OleDbDataAdapter myAdapter = new OleDbDataAdapter(strSql,myConn);
myAdapter.Fill(myData,"dtproperties");
myAdapter.Dispose();
mySql.CloseConn();
return myData;
}
}
各位达人能够给小弟说说怎么用listview显示数据吗???(最好有代码) 谢谢~~~
foreach (DataRow dr in dt.Rows)
{
ListViewItem lvi = new ListViewItem(new string[] {dr[0].ToString(),
dr[1].ToString(),
dr[2].ToString(),
................}, -1);
this.listView1.Items.Add(lvi);
}