how to update access database without sql


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: how to update access database without sql

  1. #1
    Join Date
    Apr 2006
    Posts
    4

    how to update access database without sql

    I have a courseework, that prohibits usage of sql within the code.
    I have objects in array list. I have a connection to the Access table. How can i store the data from my arraylist into the table in Access.
    I tried the following but it didn't work:

    dataset.Tenant.Clear() ' tenant is the name of the table in access

    For i = 0 To tenantList.Count - 1
    dataset.Tenant.Item(i).tenantId = tenantList.Item(i).tenantno
    dataset.Tenant.Item(i).firstName = tenantList.Item(i).tenantfname
    dataset.Tenant.Item(i).lastName = tenantList.Item(i).tenantlname
    dataset.Tenant.Item(i).tenantType = tenantList.Item(i).tenanttype

    Next
    adapterTen.Update(dataset.Tenant)

    the following does not work either:

    for i = 0 to tenantList.Count - 1
    dataset.Tenant.AddTenantRow(tenantList.Item(i).tenantfname, tenantList.Item(i).tenantlname, tenantList.Item(i).tenantno, tenantList.Item(i).tenanttype)
    next

    can anybody help me?

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    What do you mean by "doesn't work"? Do you get an error?

    BTW, the DataAdapter InsertCommand property will require a SQL INSERT statement if you want to add data to the table in your database.
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Apr 2006
    Posts
    4
    By "does not work" I mean that the data in the Access table remain unchanged. I know that insert statement is required here. The point of our coursework is not to use SQL to bind textboxes to dataset's tables. For this purpose we need first to load the data from the table into arraylist and then after manipulation, upload it back. For uploading we can use SQL, but it still does not work (does not upload the data). Maybe I have some errors in my code or smth is missing. Maybe you know any tutorials on this topic, where i can learn the steps, how to load/upload data in a right way, cause I am using only one book professional VB.Net. and ther is no sufficient information on this topic.

  4. #4
    Join Date
    Dec 2003
    Posts
    2,750
    There are a number of ways to do this. The following MS KB article may help:

    How to use Microsoft Visual Basic .NET to connect to a Microsoft Access database and to retrieve data
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

Similar Threads

  1. find version & service packs
    By rperez in forum Database
    Replies: 5
    Last Post: 01-02-2009, 05:14 PM
  2. sql database update
    By ksuwanto8ksd in forum VB Classic
    Replies: 1
    Last Post: 06-14-2005, 03:42 PM
  3. MS-Access Error - Obsolet Database Format !
    By Makl. Lemmertz in forum VB Classic
    Replies: 2
    Last Post: 10-29-2001, 12:12 PM
  4. Access to SQL server
    By Nate in forum Database
    Replies: 29
    Last Post: 05-09-2001, 11:04 AM
  5. converse asp code for access database from sql
    By deane in forum authorevents.mitchell
    Replies: 0
    Last Post: 10-16-2000, 11:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center