我有两个表Invoice, Invoice2
发票有许多列,如invoiceno,itemcode, itemrate等
而Invoice2只有一个列invoiceno,该列与Invoice表中的值相同
我想在两个表中显示具有相同invoiceno的数据库行
现在我想做的是只从Invoice表中检索那些只属于Invoice2表中'first' invoiceno的行
我正在创建first, next, previous, last按钮
所以当我第一次点击它应该显示属于第一个invoicno的行这在两个表中都是常见的
使用datagridview显示数据
windows窗体,c#
SqlDataAdapter adpt = new SqlDataAdapter("Select invoices.itemcode, invoices.itemname,invoices.quantity,invoices.itemrate from invoices, invoice where invoices.invoiceno= invoice.invoiceno ", con);
adpt.Fill(ds, "invoices");
if (ds.Tables[0].Rows.Count > 0)
{
DataRow row = new DataRow();
int i = 0;
row.Cells[0].Value = ds.Tables[0].Rows[i]["itemcode"].ToString();
row.Cells[1].Value = ds.Tables[0].Rows[i]["itemname"].ToString();
row.Cells[2].Value = ds.Tables[0].Rows[i]["itemrate"].ToString();
}
dataGridView2.DataSource = ds.Tables["invoices"];
你应该在你的查询中执行排序,然后
DataView view = new DataView(ds.Tables[0]);
DataTable distinctInvoiceNumbers = view.ToTable(true, "invoiceno");
//clear datagrid rows here
DataTable dt=new Datatable();
dt = ds.Tables[0].Clone();
int index=0;// zero if first is clicked, increase index for each next button click
foreach(datarow dr in ds.Tables[0].Rows)
{
if(distinctInvoiceNumbers.Rows[0][index].ToString()==dr[0].ToString())
{
dt.ImportRow(dr);//add matching rows to datatable
}
}
datagridview1.DataSource=dt;