Working with access and typed data set

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I have experienced a strange erro while using with Access 2007. Here is the
problem :

I have a simple table with a AutoIncrement field as primary key and two text
fields.

I generate typed dataset at visual studio by using datasource wizard. It
asked me to include the access file into the project and I said yes. when I
look the project's folder I see the access file copied to the project's
folder and debug folder.

I created an insert query by using visual datasource editor and name the
function as "create (string, string)". It takes two string parameters mapped
to two text field on the table.

I wrote the code that inserts some rows to the table like this :

UsersTableAdapter adp = new UsersTableAdapter();

usersadp.create (txtUserName.Text, txtPassword.Text);

After tihs when I check the access file in the project folder I can't see
any row inserted but the file in the debug folder contains inserted rows.
OK, nevermind but after some arbitrary period I activate the access and see
a messagebox saying invalid bookmark. After this all inserted rows
disappeared permanently.

I cannot figure out the problem, please help me if you have an idea.

Thanks in advance.


.

Relevant Pages

  • Re: Working with access and typed data set
    ... database files that are included in the project are overlaid in the Debug folders on each execution until you deploy the application. ... It asked me to include the access file into the project and I said yes. ... when I look the project's folder I see the access file copied to the project's folder and debug folder. ... After tihs when I check the access file in the project folder I can't see any row inserted but the file in the debug folder contains inserted rows. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VB6 and Windows Media Player
    ... within the My Music Folder. ... Private Declare Function ShellExecute Lib "shell32.dll" Alias ... "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal ... the folder Documents and Settings eg:- C:\Documents and Settings? ...
    (microsoft.public.vb.general.discussion)
  • Re: File Input Question
    ... To have a user select a folder, not a file, I use the below. ... pszDisplayName As String 'Address of a buffer to receive the display name of the folder ... Alias "SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) As Long ... Private Declare Function GetWindowRect Lib "user32" ...
    (microsoft.public.excel.programming)
  • Re: Execute macro for all documents in the folder
    ... It is simple enough to batch process a single folder. ... Dim strFileName As String ... It seems as though the below macro from an earlier posting was put ...
    (microsoft.public.word.docmanagement)
  • Re: Execute macro for all documents in the folder
    ... It is simple enough to batch process a single folder. ... Dim strFileName As String ... It seems as though the below macro from an earlier posting was put ...
    (microsoft.public.word.docmanagement)