how to update access database without sql

[Avelin]

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?

[pclement]

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.

[Avelin]

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.

[pclement]

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