Need to stock register in ms access

Asked By Joseph K Carpenter 50 points N/A Posted on - 03/24/2013

Hi,

I have a website which is based on shop management. I need to entry products details in the database. How i can stock data register in ms access database?

• Status: Open
• Question Views: 862
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Stella T Finley 10 points N/A #191649

Need to stock register in ms access

Assuming you have your web.config file set with the proper accdb connection string, then you'll need to create a SQL data source link to it from your form.  Then you can use the handy wizard for generating the SQL statements.  If in configuring your form you convert your bound fields that are converting to  template fields it will automatically create the edit, delete, update and insert buttons for you.  If you want something more complicated that happens behind the scenes (so the user isn't the one clicking all those buttons) then use a button click event and run the SQL statements in your code behind with a "submit" subroutine Or you can also fire the SQL statements in the Page Load sub so that the user never even knows what's happening behind the scenes. You can use Environment. Username in your code behind to get their windows login username to save into or compare to the database username field.  Make sure that your are putting the Imports system. Environment in the top of your code behind.

About Stella T Finley

Questions
32

Answers
32

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 04/18/2013
• Question Category: MS Excel