I did it with following statments; Ole Db Connection conn = null; conn = new Ole Db Connection("Provider=Microsoft. OLEDB.4.0; " "Data Source=C:\Development\White Plains DB\Data\White Plains.mdb;"); conn.
I need to store a data table, that will get adding rows, deleting rows, and rows modified.which brings me to the problem of it being inserted, everytime it runs it just appends all the records to the bottom The rows in "DTable" decide what happens with the corresponding row in the a row in "DTable" has status "is New" then the row will be inserted, if the status is "modified" the db-table will be updated.
For Data Adapter to work as you expect, you must SELECT the record into the datatable, update it, then dataadapter will recognize the record as an update.
This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hi, This is here my first post, I hope you can help me. Item("RECORDS") end if end if Next 'PART3: Update origenal access DB Should work, but doesn't work...
NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions.
Data Sets only hold data and do not interact with a data source.