save multiple

SHALL I GET CODE?PLEASE

iSalesItemID     int  
iSalesID           int  
iItemID            int  
vItemCode       int  

iNos                int 
deRate            decimal(18, 2)  
deAmount        decimal(18, 2)  
vTea               int 
vCoffee          varchar(50)  
vMineral        varchar(50)  
vSoft           varchar(50)  
vPhoto        varchar(50)  
vFax           varchar(50) 
vGen           varchar(50)  
vMiscalla        varchar(50)   



not two values together at a time. i means one by one.


i want to save tea,coffee through single text box..how its possible in front end?in 2 tier ,sql 2005

PLEASE ANSWER ME SOON

CAN'T WE DO WITHOUT 5 TEXT BOXES?I NEED ONLY ONE  TEXT BOX

NO

WE NEED TO DESIGN CRYSTAL REPORT LIKE THIS
 DATE          TEA                 COFFEE          SOFT DRINKS       MINERAL WATER         FAX
            QUANTITY  RS     QUANTITY  RS     QUANTITY  RS       QUANTITY  RS   QUANTITY  RS
EXAMPLE
OUTPUT
12-SEP-13     5           50         5          50         5           50       5                50      5     50


THIS IS WRONG...BECAUSE I BOUGHT ONLY 5 TEA...THEN HOW IT COMES IN PRINT OUT...IS THE MISTAKES IN CODE OR CRYSTAL REPORT DESIGN?I MENTIONED IN DETAIL WHAT I WANT,OR GETTING NOW...IF YOU UNDER STAND PLEASE GIVE ANSWER

Table Item
    
             vTea           Varchar(50);
             vCoffee        Vrachar(50);
             vMineral       varchar(50);
             vFax            varchar(50);
             vSoftDrinks   varchar(50)



Design                                                                    
         ItemName              Rate              Nos                         Amount
         txtItem.Text          txtRate.text    txQty.text                txtAmount.text
         
           GRID

      Save   Edit   Search    Delete


we have to design crystal report,before that should insert tea,coffee,mineral.fax,soft drinks through txtItem.text.HOW TO GIVE CODE IN FRONT END?

hi,

still quesition is not cleared.
are you going to insert item one by one or you have all item and going to insert value of the item?

vtea,vcoffee,vfax,vsoft drinks these are the fields.but we have one text box.how to insert ina table tblitem...