要实现点击listview任一行,一listview其中一个关键字查出数据,然后把查出的数据显示在datagridview中,填充datagridview的代码不太会写,谢谢 DataSet ds = new DataSet();
ds = bll.GetDataSetTmpBill();
DataTable dt = ds.Tables["tb_tmpwheatloader"];
if (this.lvwTempBill.SelectedItems.Count > 0)
{
DataRow[] rows=dt.Select("ordernum='"+ this.lvwTempBill.SelectedItems[0].SubItems[0].Text.ToString() +"'");
for (int i = 0; i < rows.Length; i++)
{
//frmintostorage.dgvdTempBill.Rows.Add(rows[i]["ordernum"].ToString());
//frmintostorage.dgvdTempBill.Rows.Add(rows[i]["inboundnum"].ToString());
frmintostorage.dgvdTempBill.Rows.Add(rows);
//这里把查询出的数据显示到datagridview里,不怎么到怎么写
}
}
ds = bll.GetDataSetTmpBill();
DataTable dt = ds.Tables["tb_tmpwheatloader"];
if (this.lvwTempBill.SelectedItems.Count > 0)
{
DataRow[] rows=dt.Select("ordernum='"+ this.lvwTempBill.SelectedItems[0].SubItems[0].Text.ToString() +"'");
for (int i = 0; i < rows.Length; i++)
{
//frmintostorage.dgvdTempBill.Rows.Add(rows[i]["ordernum"].ToString());
//frmintostorage.dgvdTempBill.Rows.Add(rows[i]["inboundnum"].ToString());
frmintostorage.dgvdTempBill.Rows.Add(rows);
//这里把查询出的数据显示到datagridview里,不怎么到怎么写
}
}
datagridview.datasource=dataset1.Tables[0];
//或者
//一行一行读取放在arraylist
datagridview.datasource=arraylist1;
if (this.lvwTempBill.SelectedItems.Count > 0)
{
DataRow[] rows = dt.Select("ordernum='" + this.lvwTempBill.SelectedItems[0].SubItems[0].Text.ToString() + "'");
for (int i = 0; i < rows.Length; i++)
{
frmintostorage.dgvdTempBill.Rows.Add(1); //新建一个空白行
int rowindex = frmintostorage.dgvdTempBill.Rows - 1;
frmintostorage.dgvdTempBill.Rows[rowindex].Cells["Column1"].Value = rows[i]["ordernum"].ToString();
frmintostorage.dgvdTempBill.Rows[rowindex].Cells["Column2"].Value = rows[i]["inboundnum"].ToString();
//..............等等
//前提是在DataGridView的Columns属性里创建了列
}
}
{
DataGridViewRow row = new DataGridViewRow();
row.Cells[0].Value =dt[""].ToString();
row.Cells[1].Value = dt[""].ToString();
this.dataGridView1.Rows.Add(row);
}
或
DataGridViewRow dr = dataGridView1.Rows[dataGridView1.NewRowIndex];
dataGridView1.Rows.Add(dr);