how to post from one table to the other RRS feed

  • Question


    I have constructed MDI parent form with child form.  Plus, placing all my data onto one form with tab controls and pages.  Now, i want to post from one table to the other table.  Or, from one datagrid to the other datagrid. I know is by using the getdata method, but i cannot seem to be able to get it work.  i have add a query to get a specific data from the table 1 and wanting to post to table2, any ideas??
    Tuesday, February 26, 2008 9:34 AM

All replies

  • your post is not much expressive, do u want to insert data in table 2 which is retrieved from table 1 ? if yes use the simple insert query


    insert into table2(column1, column2) select column1,column2 from table1


    Thursday, February 28, 2008 4:30 AM
  • Moving to the .net data access forum from the SQL Server forum.
    Thursday, February 28, 2008 12:17 PM