Satyapriya Nayak

Satyapriya Nayak

  • NA
  • 39.3k
  • 13.3m

How to solve it plz help me?

Apr 30 2010 5:37 AM

Hi
 
Suppose there is a table named product
Its columns are
1.e_date
2.e_name
3.quantity
4.Total
Its values are suppose
e_date      e_name          quantity  Total
1/1/2000    Toys                   1        10
1/1/2000    books                 1        10
1/1/2000    furniture             1        10

2/1/2000    Music system      2        20
2/1/2000    Telivision             2        20
2/1/2000    computer            2        20

3/1/2000    Chocolate           3        30
3/1/2000    Softdrinks           3        30
3/1/2000    Icecream            3        30
4/1/2000    pen                    4        40
4/1/2000    pencil                 4        40
4/1/2000    rubber               4        40

My question is when i choose the date from  (1/1/2000 to 2/1/2000)
Then the result output will be as below shown:
e_date      e_name                                        quantity       Total
1/1/2000   Toys,books,furniture                        1                10
2/1/2000   Music system,Telivision,computer     2                20

We can give the input two dates in two textboxs and output will be show in gridview or table.There is a button when clicked the output will be show in respective gridview or table.
 
 
Thanks in Advance

Answers (7)