LOAD DATA FROM SQL TABLE AND MULTIPLY QUNTY AND RATE

Question

i have table like(items and price)

 ITEMS

Sno     Items        Rate

1         Chips         4.5

2         Cake          10

3         Samosa      5

 i have front end like   below

 

Items           Qunty         Amount

label1            4               label4

label2            5               label5

label3            3               label6

 

label1,label2,label3 load data ITEMS COLOUM  from ITEMS TABLE

when i enter qunty in textbox .. LABEL4 DISPLAY  qunty multiply  rate in Items Table ( 4.5 * 2=9)

 

i want o/p like

 

Items          Qunty           Amount

Chips            2                  9

Cake             5                   50

Samosa        3                  15 

 

 

PLZ WRITE CSHARP CODE..................