Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi all, I am having a problem f

Status
Not open for further replies.

MDA

Technical User
Jan 16, 2001
243
US
Hi all,

I am having a problem figuring out how to insert records into a table. This is my scenario...

I am populating a data grid control with two fields of data from several different databases.

I need to take the data gathered in the grid and insert it into yet another database. I have two main questions...

--How do I insert data into a table from a data grid??

--How do I add 3 constants to the insert along with the data inserted from the grid...
For example.. I have five fields in the table 1,2,3,4,5 I will pull fields 1 and 2 from the data grid but 3 - 5 are constant integers...
ie.. 1 2 3 4 5
A1 11 1 0 1
B7 99 1 0 1
N9 75 1 0 1
And so on....

Any ideas on how to do this is greatly appreciated... I think it is much more easy than I am making it to be...

Thanks in advance for any ideas...

Regards,

Mike

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top