可以用程序绑定啊
for(int i=0 ;i<dataset.Table[0].Rows.Count;++i)
{
for(int j=0;j<dataset.Table[0].Column.Count;++j)
listView.Items.Add("dataset.Table[0].Rows[i][j].ToString()");
}
for(int i=0 ;i<dataset.Table[0].Rows.Count;++i)
{
for(int j=0;j<dataset.Table[0].Column.Count;++j)
listView.Items.Add("dataset.Table[0].Rows[i][j].ToString()");
}
http://www.akadia.com/services/dotnet_listview_sort_dataset.html
for(int i=0;i<this.listView1.items.count;i++)
{
DataRow row= this.MyDataSet.Tables[0].NewRow();
row["列1"]=this.listView1.items[i].SubItems["列1"].Text.Trim();
row["列2"]=this.listView1.items[i].SubItems["列2"].Text.Trim();
row["列3"]=this.listView1.items[i].SubItems["列3"].Text.Trim();
.
.
.}
private void button2_Click(object sender, System.EventArgs e)
{
SqlConnection cmicCn=new SqlConnection("server=ym\\ymsql;database=pubs;uid=sa;pwd=111023");
cmicCn.Open();
SqlDataAdapter cmicDa=new SqlDataAdapter("select * from sales ",cmicCn);
DataSet cmicDs=new DataSet();
cmicDa.Fill(cmicDs);
BindingsListView(cmicDs,this.listView1);
}
private void BindingsListView(DataSet sDs,ListView sLV)
{
sLV.View=View.Details;
sLV.GridLines=true;
if(sDs.Tables.Count!=0)
{
DataTable cmicDt=sDs.Tables[0];
foreach(DataColumn sDc in cmicDt.Columns)
{
sLV.Columns.Add(sDc.ColumnName,80,HorizontalAlignment.Center);
}
foreach(DataRow sDr in cmicDt.Rows)
{
ListViewItem cmicItem=new ListViewItem();
cmicItem.Text= cmicDt.Columns[0].ToString();
for(int i=1;i<cmicDt.Columns.Count;i++)
{
cmicItem.SubItems.Add(cmicDt.Columns[i].ToString());
}
sLV.Items.Add(cmicItem);
}
}
else
{
return;
}
}
dv.RowFilter = "归口单位编号 = " + this.treeView1.SelectedNode.Tag.ToString();//归口单位编号
foreach(DataRowView drv in dv)
{
string[] item = new string[3];
// item[0] = drv["使用单位编码"].ToString();
item[0] = UserConfig.GetStrCode(int.Parse(drv["使用单位编码"].ToString()),3);
item[1] = drv["使用单位名称"].ToString();
item[2] = drv["归口单位名称"].ToString();
ListViewItem it = new ListViewItem(item);
it.Tag = drv["使用单位编号"].ToString();
this.listView1.Items.Add(it);
}