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