Inserting data into db

I am trying to write some data to an access database in vb.net.

I have used a .Fill(DataSet) statement to read the db and return how many rows there are.

I thought I would then be able to use to insert the information from my form.

I use a try statement to return a message box to say whether the insert has been successful or not. I get a MB 'successful' return, but there is nothing added to my database.

I am trying to emulate a program that I have seen elsewhere, but I know nothing about vb.net really, so am struggling.

Can anyone help me please, I so confused at the moment.

cheers
harlequeen

You didn't specify your Try block, but did you perform the

affrows = insertCommand.ExecuteNonQuery()

This should perform your query and place the number of rows affected into the affrows varaible.