The scenario is :- I use a table in sql server for customer records in which columns are like - common thing which are included in a clothing bill..quantity,price,total amount.
I need to multiply these colums with certain amount of quantity which a customer takes..like if he purchases two pants of 600Rs,and a shirt of 800,it should be calulated and given to the total Amount Column..from which it is to be printed..
ANy Line of code to be written?is preffered..Plz Help...
Now,I hope you understand my deluge..Plz Help.
Vijaya KadiyalaPosted Jun 25, 2008, 2:35 PM
HI,
Strong the computed columns in database is aganist to the Normalization. In the near future this may eases your code but on long run this will create a problem, if you want to update old data.
Thanks -- Vj
http://dotnetvj.blogspot.com
Gaurav TomarPosted May 27, 2008, 5:40 AM
For this problem, I would prefer you an article on c-sharpcorner.com, This article gives you the basic idea to solve your problem.
http://www.dotnetheaven.com/UploadFile/rahul4_saxena/TotalofDataGrid06082007030102AM/TotalofDataGrid.aspx
Just click on the above link.