1,105,375 Community Members

adodc save query in database table

Member Avatar
vonnoy
Light Poster
31 posts since Feb 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
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?
Member Avatar
AndreRet
Industrious Poster
4,492 posts since Jan 2008
Reputation Points: 362 [?]
Q&As Helped to Solve: 499 [?]
Skill Endorsements: 24 [?]
 
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?
Member Avatar
AndreRet
Industrious Poster
4,492 posts since Jan 2008
Reputation Points: 362 [?]
Q&As Helped to Solve: 499 [?]
Skill Endorsements: 24 [?]
 
0
 

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

Member Avatar
abelingaw
Posting Whiz in Training
247 posts since Jun 2008
Reputation Points: 69 [?]
Q&As Helped to Solve: 32 [?]
Skill Endorsements: 2 [?]
 
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
Member Avatar
vonnoy
Light Poster
31 posts since Feb 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
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