Click here to Skip to main content
13,258,055 members (48,292 online)

Select a value from one table and insert into another table

Raghavanand asked:

Open original thread

I am new to dotnet and stuck in a task which deals with two sql tables. Let me explain clearly

I have two tables Events,user-events.I have four asp buttons.Each button is asssigned to each id in Events table .On button click i need to insert that id in user-events table.

I tried using select statement for retrieving the id from first table and later using insert for inserting into second table ...But it did not work.. can anyone help me sorting out this issue
Tags: C#, ASP.NET, SQL-Server


When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. 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.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).

Advertise | Privacy |
Web01 | 2.8.171114.1 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100