copying data form one table to another

Question

0.00/5 (No votes)

See more:

I would like to know how to copy data from one table to another.

I would like to checked several rows in one table and copy those rows to a new table.

I would also like to know how to copy data to the same table if one column changes.

for example if I have a student table with student data during semester 1 when its semester 2

I would like to copy some of that same data for semester2.

I am new to visual studio 2010 and I am using asp.net

Posted 2-Aug-12 17:47pm

Member 9331278

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AshishChaudha · Answer 1 · 2012-08-02T17:59:00

You can use queries for copying records of a table to another table.

Following query will automatically create destination table

SQL

select * into <destination table=""> from <source table=""></source></destination>

If the table is already created

SQL

insert into <tablename> select * from <table name=""> where [condition].</table></tablename>

Thanks
Ashish

Kenneth Haugland · Answer 2 · 2012-08-02T17:52:00

Solution 1

This is rather basic datamanipulation and you should consider starting here:

http://msdn.microsoft.com/en-us/library/system.data.datatable%28v=vs.110%29.aspx[^]

There are example at the end of that page in the link. So good luck

Posted 2-Aug-12 17:52pm

Kenneth Haugland

Member 9331278 · Answer 3 · 2012-08-09T16:09:00

VB

Partial Class ViewStudents
    Inherits System.Web.UI.Page
    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        For Each gridviewrow As GridViewRow In GridView1.Rows

            Dim checkbox As CheckBox = gridviewrow.Cells(0).FindControl("CheckBox1")

            If checkbox.Checked Then

                Dim studentId As Integer = GridView1.DataKeys(gridviewrow.RowIndex).Value
                Dim FirstName As String = GridView1.DataKeys(gridviewrow.Cells(1).Value.ToString()) 'error! help please with this line
                Dim LastName As String


            End If

        Next
    End Sub

copying data form one table to another

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

copying data form one table to another

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us