1.11M Members

adodc save query in database table

 
0
 

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?
 
0
 

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?
 
0
 

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

 
1
 

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
 
0
 

thanks a lot guys.

Question Answered as of 1 Year Ago by AndreRet and abelingaw
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article