如何动态添加Gridview行 [英] How To Add Gridview Rows Dynamically

问题描述

我从数据表中读取数据但我不知道在gridview中添加如果你知道请帮助我



我的代码是

  string  qry =  选择不同的类别，发票，tot，型号，价格，数量，税，总计，grandtoal，折扣，说明，来自Client_Bill_TB的taxamount，其中invoice = '48 / 072014'; 
 dt = cbbal.GetData（qry）;  //   cbbbal是执行数据表的方法 
  foreach （DataRow Drow  in  dt.Rows）
 {
 txtcategory.Text = Drow.ItemArray [ 0 ]的ToString（）; 
 tot.Text = Drow.ItemArray [ 7 ]。ToString（）; 
 txtdescrip.Text = Drow.ItemArray [ 10 ]。ToString（）; 
 txtPrice.Text = Drow.ItemArray [ 4 ]。ToString（）; 
 txtQuantity.Text = Drow.ItemArray [ 5 ]。ToString（）; 
 txtdiscount.Text = Drow.ItemArray [ 9 ]。ToString（）; 
 txtInvoice.Text = Drow.ItemArray [ 1 ]。ToString（）; 
 txttaxamt.Text = Drow.ItemArray [ 11 ]。ToString（）; 
 txtTotal.Text = Drow.ItemArray [ 7 ]。ToString（）; 
 lblGrandTotal.Text = Drow.ItemArray [ 8 ]。ToString（）; 
 dt.Rows.Add（卓尔）;  //  错误 
} 

如果我有两行exec那个查询但是这段代码只显示最后一行它在gridview中



如何才能解决这个问题

解决方案

有一些错误。



DataTable dt = new DataTable（）;



DataTable dt1 = cbbal.GetData（qry）;



foreach（dt1.Rows中的DataRow dr）

{

DataRow dr1 = dt.NewRow（）;

dr1 [Name] = dr [Name]。ToString（）;

dt.Rows.Add（dr1）;

}



如果您有任何疑惑，那么您可以询问我

Hi,

I read the data from data table but i dont know to add in gridview if u know kindly help me

My Code Is

 string qry = "select distinct category,invoice,tot,model,price,quantity,tax,total,grandtoal,discount,discription,taxamount from Client_Bill_TB where invoice='48/072014'";
                dt = cbbal.GetData(qry); //cbbbal is method to exec data table
foreach (DataRow Drow in dt.Rows)
               {
                   txtcategory.Text = Drow.ItemArray[0].ToString();
                   tot.Text = Drow.ItemArray[7].ToString();
                   txtdescrip.Text = Drow.ItemArray[10].ToString();
                   txtPrice.Text = Drow.ItemArray[4].ToString();
                   txtQuantity.Text = Drow.ItemArray[5].ToString();
                   txtdiscount.Text = Drow.ItemArray[9].ToString();
                   txtInvoice.Text = Drow.ItemArray[1].ToString();
                   txttaxamt.Text = Drow.ItemArray[11].ToString();
                   txtTotal.Text = Drow.ItemArray[7].ToString();
                   lblGrandTotal.Text = Drow.ItemArray[8].ToString();
                   dt.Rows.Add(Drow); //Error
               }

if i have two rows when exec that query but this code display last row only where its in gridview

How Can solve this problem

解决方案

There is some mistakes.

DataTable dt = new DataTable();

DataTable dt1 = cbbal.GetData(qry);

foreach(DataRow dr in dt1.Rows)
{
DataRow dr1 = dt.NewRow();
dr1["Name"] = dr["Name"].ToString();
dt.Rows.Add(dr1);
}

If you have any confusion then you can ask me.

这篇关于如何动态添加Gridview行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！