how to add discount column in gridview c# windows form

Jyoti Jodha

how to add discount column in gridview c# windows application

decimal Qty = Convert.ToDecimal(txtqty.Text);

decimal Unit_Price = Convert.ToDecimal(qtytxtprice.Text);

decimal Tax = Convert.ToDecimal(txttax.SelectedValue);

decimal Amount = (Qty * Unit_Price);

decimal PercentageAmount = ((Amount * Tax) / 100);

decimal TotalAmount = Amount + PercentageAmount;

public void CalculateTotalAmount()

{

decimal taxtotal=0;

decimal totalamount=0;

for(int i=0;i

{

decimal TotalAmount = (Convert.ToDecimal(dataGridView.Rows[i].Cells[4].Value) * Convert.ToDecimal(dataGridView.Rows[i].Cells[6].Value));

taxtotal = taxtotal + ((Convert.ToDecimal(dataGridView.Rows[i].Cells[7].Value)*TotalAmount)/100); totalamount=totalamount+ TotalAmount;

}

TotalTaxtxt.Text=taxtotal.ToString();

totalamounttxt.Text=totalamount.ToString();

_subTotal = taxtotal + totalamount;

txtNewTotal.Text = (_subTotal).ToString();

Subtxt.Text = (_subTotal).ToString();

CalcDiscountShopCost();

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
you can calculate discount as shown below

decimal discount=TotalAmount+( (TotalAmount*Convert.ToDouble(discountperc.Text))/100)

then send this value to your grid as sending total amount
0
Rajkiran Swain9y ago
https://www.infragistics.com/help/winforms/wincalcmanager-creating-a-calculated-column-in-the-datagridview-control
0
Karthi Keyan9y ago
@jodha,

how you are calculating the discount by units or percentage? units means directly add that value to the discount column in grid. if percentage, calculate the amount and add that to the grid.
0