I want sql query for retrieving data from one table and store it in another table

Question

1.00/5 (2 votes)

See more:

C#

ASP.NET

What i am trying to do is on button click i want to store some selected data from one table into other table

Posted 9-Apr-14 19:34pm

jayraj86

Add a Solution

Comments

Maciej Los 10-Apr-14 1:38am

OK, but what have you tried? Where are you stuck? What kind of issue do you have?

jayraj86 10-Apr-14 1:56am

I have tables
1.Users
2.AppliedUsers

in AppliedUsers table I have few 6-7 columns which are same as in Users table. As I want those values from Users table and store those values in this new AppliedUsers table.

I have stored UserID (from users table) value in session, the thing I am doing here is on button click i want to store selected values from Users into AppliedUsers table where UserId=session[userid]. The user is applying for job on button click and i want to store the data of that user who applied into this new AppliedUsers table from Users table.

2 solutions

Solution 2

SQL

SELECT *
INTO carcopy2 ////this is table where you will insert
FROM carcopy;/////this is from whre you are retrieving

Posted 9-Apr-14 20:27pm

Member 9425683

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)

Raajkumar.b · Accepted Answer · 2014-04-09T19:55:00

Solution 1

protected void Button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("connection string");
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from Users where UserID='"+Session["userid"].ToString()+"'",con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                SqlCommand cmd2 = new SqlCommand("insert into AppliedUsers values('" + dt.Rows[0][0].ToString() + "','" + dt.Rows[0][1].ToString() + "',......) ", con);
                cmd2.ExecuteNonQuery();
            }
            con.Close();
        }

Posted 9-Apr-14 19:55pm

Raajkumar.b

Updated 9-Apr-14 21:01pm

v3

Comments

jayraj86 10-Apr-14 2:08am

Appreciate your answer Raajkumar,
how can I write insert query here ?
INSERT INTO UsersApplied (UserID,FirstName)Values (???)
what should i write in values ??

Raajkumar.b 10-Apr-14 2:12am

("insert into UserApplied(UserID,FirstName) values('" + dt.Rows[0][0].ToString() + "','" + dt.Rows[0][1].ToString() + "')",con);

jayraj86 10-Apr-14 2:16am

qlConnection con = new SqlConnection("Data Source=jayraj-pc\\sqlexpress;Initial Catalog=Internship;Integrated Security=True;Pooling=False");

con.Open();
SqlCommand cmd = new SqlCommand("select UserID,FirstName from Users where UserID='" + Session["UserID"].ToString() + "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
SqlCommand cmd2 = new SqlCommand("insert into UsersApplied values('" + dt.Rows[0][0].ToString() + "','" + dt.Rows[0][1].ToString() + "',......) ", con);
cmd.ExecuteNonQuery();
}
con.Close();

I applied this code but i m not getting any data in AppliedUsers table. why ?

Raajkumar.b 10-Apr-14 2:19am

SqlCommand cmd2 = new SqlCommand("insert into UsersApplied values('" + dt.Rows[0][0].ToString() + "','" + dt.Rows[0][1].ToString() + "') ", con);

remove .... in insert query

Raajkumar.b 10-Apr-14 2:19am

r u getting any error

jayraj86 10-Apr-14 2:26am

i removed ... from insert query. no I'm not getting any error.

Raajkumar.b 10-Apr-14 2:21am

once check the datatable dt is filling or not. If dt is filled then error is in query check the insert query once again

jayraj86 10-Apr-14 2:31am

I checked it by writing Response.Write("dfd"); below da.Fill(dt);
and its showing dfd at corner

Raajkumar.b 10-Apr-14 2:37am

once take one gridview in design page afther da.fill(dt) write
gridview1.datasource=dt;
gridview1.databind();

execute it and tell me whether gridview is filling with userid and firstname.

jayraj86 10-Apr-14 2:42am

Yes its gridview is filling with userid and firstname

jayraj86 10-Apr-14 2:43am

yes its filling gridview

jayraj86 10-Apr-14 3:01am

Thanks a lot RaajKumar. it was just a small mistake, cmd2 instead of cmd in 3rd last line :)

jayraj86 10-Apr-14 3:22am

Thanks a lot RaajKumar. it was just a small mistake, cmd2 instead of cmd in 3rd last line.

Raajkumar.b 10-Apr-14 2:46am

SqlCommand cmd2 = new SqlCommand("insert into UserApplied(UserID,FirstName) values('" + dt.Rows[0][0].ToString() + "','" + dt.Rows[0][1].ToString() + "')",con);

just paste this query at cmd2 command once it will work confirmly

jayraj86 10-Apr-14 2:48am

yes its filling gridview

Raajkumar.b 10-Apr-14 2:54am

Is the values are inserting in Applied Users table or not

Raajkumar.b 10-Apr-14 3:00am

hey sry yaar the problem is after cmd2 command ther we are writing cmd.executenonquery()

replace it with cmd2.ExecuteNonQuery();

jayraj86 10-Apr-14 9:32am

Yeah I got it later about that cmd thing, btw thank you so much RaajKumar :))

one other problem i m stuck at right now, can you sort it out ?
here is the link http://www.codeproject.com/Questions/756411/In-Asp-Net-Csharp-I-Have-Four-Dropdownlist-And-I-W