how to insert row from one table to another..

Question

0.00/5 (No votes)

See more:

C#

ASP.NET

how i insert row of table1 to table2 ..and after insertion delete that row from table1.

Posted 9-Apr-13 19:27pm

Raj@88

Add a Solution

Comments

Ramya SV 10-Apr-13 1:31am

Can you briefly explain the Question.

Karthik Harve 10-Apr-13 1:41am

which table ? sql table or .net datatable ?

Raj@88 10-Apr-13 1:50am

i hv two table in my project Advertise1,Advertise2...the project is related to Advertising the business, when user insert data related to their business data will save in Advertise1 ...with start date and end date after completion the date the data of the particular user should move from Advertise1 to Advertise2...for that am using access database.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

kishore sharma · Accepted Answer · 2013-04-09T19:46:00

Here you can check
if your both tables having same defination means same number of columns and same data types
then you can go with

SQL

insert into table2
select * from table1 where id=1 --your condition here
delete from table1 where id=1 --your condition here

if your both table defination are different but the datatype of respected columns must be same
then you need to go for

SQL

insert into table2
select column1,column2,column3 from table1 where id=1 --your condition here
delete from table1 where id=1 --your condition here
--where column1,column2 and column3 are the columns you need to take from table1 which need to be inserted into table2

Thanks
Happy coding ;>)