?
Solved

How to insert a new record into an empty ACCESS table using GirdView and AccessDataSource

Posted on 2012-03-16
2
Medium Priority
?
591 Views
Last Modified: 2012-03-16
Hi:

We're creating some web application using VS 2010 with Visual Basic.

We try to insert a new record (the 1st record) into an empty ACCESS table, using gridView and AccessDataSource.

We configure GridView to bind with the AccessDataSource and also configure the AccessDataSource for SELECT, INSERT, UPDATE, and DELETE statements.

The problem is that when we run the web page, because the ACCESS table is empty, the GridView does not show up in the page. We could not do anything with GridView because it is invisible.

(NOTES: we can retrieve data from ACCESS table correctly - the GridView displays the data if some rows exist in the table)

If you've some idea how to do this: insert the 1st record into an empty table, using GridView and AccessDataSource, please help.
(We could do it using OleDbConnection, DataSet, and OleDbDataAdapter, ... - we now want to use GridView and AccessDataSource for the sake of code consistence)

Thanks a lot for any help,

Somits
0
Comment
Question by:somits
  • 2
2 Comments
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 2000 total points
ID: 37731300
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 37731303
Delete your other duplicate question.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question