adodc save query in database table

[vonnoy]

can anyone help how to save using this code below.?
i used adodc recordset

with adodc1
    .ConnectionString = connectdb
    .RecordSource = "Select * from 'tablename'"
    .Refresh

    'dont know the next action

    end with
    'what does this code mean?

[AndreRet]

Do the following...

with adodc1
    .ConnectionString = connectdb
    .RecordSource = "Select * from 'tablename'"
    .Refresh
    'dont know the next action
    .AddNew
    ''If your textboxes is connected to the respective fields, data will be captured automatically...
    .Update
    end with
    'what does this code mean?

[AndreRet]

I would rather suggest you learn how to make use of adodb which gives you MUCH more control over your database manipulation.

[abelingaw]

Edit:

with adodc1

   .ConnectionString = connectdb
    .RecordSource = "Select * from 'tablename'"
    .Refresh

    .AddNew


        .Recordset.Fields("Tablecolumn name") = txtYourtextbox.Text

 'any entry on that specific textbox would be save to that specific column on your table
 'make sure your textbox control is connected to your adodc

    .Update
    end with

[vonnoy]

thanks a lot guys.