How to calculate Tax,Qty, total amount in c#

HI Jyothi,

My suggestion is ,

Create a product table which has columns, Product_Id,Product_Name,ProductShot_Name,TotalQty,prize ,Tax %..

Insert value for that tables like 1,Mazza,Mazza, 50,48,2

Select the "Mazza" in combobox and enter the no of qty in that.

Once enter these values automatically it want to be calculate , try the below code,

int productid=combobox1.selectedvalue();
int ProductPrize;
deimal Tax;
con.open();
slqcommand cmd=new sqlcommand("select Prize,tax from where prodcutid='"+productid+"'",con);
sqldatareader sdr=cmd.executereader();
while(sdr.hasrows)
{
ProductPrize=convert.toint32(getstring(0));
Tax=convert.toDecimal(getstring(1));
}
con.close();
ProductPrize.Text=convert.toint32(convert.toint32(qty.Text)*ProdcutPrize)
Tax.Text=convert.toDecimal(((ProductPrize)*(tax))/100);

2 Replies

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