codetoad.com
  ASP Shopping CartForum & BBS
  - all for $20 from CodeToad Plus!
  
  Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM 
Search Site:
Search Forums:
  Transfer of selected row data from 1 table to another table - Need help  chankl78 at 17:01 on Monday, June 12, 2006
 

I have a table called tblProducts. It contains these fields as below:
ItemID
ItemAltID
ItemDescription
Brand
Unit
MarketPrice
CatergoryID
PAcctID

I have another table called tblStockReceivedDetails. Inside the table, it contain following fields as below:
SRID
SRItemID
SRItemAltID
SRItemDescription
SRBrand
SRUnit
SRMarketPrice
SRCatergoryID
SRPAcctID

I am using Visual Web Developer (VWD) with access database. Here is the situation. I have a webpage called StockReceived. This is the page where my user is going to do a stock received every time when their stocks come in.

So everytime, when there are new stocks, they will click a "Add Items" button, it will pop out a mini webpage & contains all the product from the "tblProducts". The user will then check a checkbox beside if that is the particular stocks to be received. Until here, I can still able to do it by using a gridview with ItemTemplate (For the checkbox).

Now, from here, I do not know how to go about as I am still a newbie in Asp.net.
How to I based on the checkbox, transfer selected data from tblProducts to tblStockReceivedDetail below is the codes I have created for my 2 tables.

Someone kind enough to advice me. I am struck....
Smile & thanks








CodeToad Experts

Can't find the answer?
Our Site experts are answering questions for free in the CodeToad forums
//








Recent Forum Threads
•  jslider - paint track
•  Re: convert minutes into hours and minutes
•  File handle problem
•  Link Capture, help needed
•  Re: java app auto web update..
•  IE Only comeback
•  ` Error Code 64: Host not available ` - Error when accessing ASP Appln
•  Re: dynamic crystal report generation
•  Launch an app remotely through a website


Recent Articles
ASP GetTempName
Decode and Encode UTF-8
ASP GetFile
ASP FolderExists
ASP FileExists
ASP OpenTextFile
ASP FilesystemObject
ASP CreateFolder
ASP CreateTextFile
Javascript Get Selected Text


© Copyright codetoad.com 2001-2007