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 }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)