save multiple

Question

how to save multiple entries using single text box in UI layer.means there are 10 items in invoice form..ONLY ONE TEXT BOX NAMED txtItemname.text each should save in corresponding fields..how?GIVE CODE IN 2 TIER IN C# SOON....

Maneesh A N · Answer

SHALL I GET CODE?PLEASE

Suthish Nair · Answer

Add a grid view below your text box design and add the categories one by one into grid view. Later one button to insert all grid view data into table by doing a for loop.

Maneesh A N · Answer

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 teacoffee through single text box..how its possible in front end?in 2 tier sql 2005

Suthish Nair · Answer

Issue Resolved?

Maneesh A N · Answer

PLEASE ANSWER ME SOON

Maneesh A N · Answer

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

Maneesh A N · Answer

NO

Suthish Nair · Answer

You need to have 5 more text boxes for each categories..

Maneesh A N · Answer

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 WANTOR GETTING NOW...IF YOU UNDER STAND PLEASE GIVE ANSWER

Maneesh A N · 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 reportbefore that should insert teacoffeemineral.faxsoft drinks through txtItem.text.HOW TO GIVE CODE IN FRONT END?

Jignesh Trivedi · Answer

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?

Maneesh A N · Answer

vteavcoffeevfaxvsoft drinks these are the fields.but we have one text box.how to insert ina table tblitem...

Jignesh Trivedi · Answer

Hi we are not getting your quesition. please refer http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html http://www.dotnetspark.com/kb/643-how-to-editupdatedelete-gridview.aspx are you looking this type solution?