Select the value from a field of one table and place it into another table.
Using VB.NET, VS2005, SQL Server 2000. In a Windows Form, how could I provide a means for a user to select the value from a field of one table (a primary key value) and place it into another table (as a foreign key value)? The goal is to "assign" a person from one table to a location in another table by placing the person's primary key value into the location's foreign key field via an easy to use "selection" mechanism like a DataGridView or something.Thanks in advance for any help or examples.David  this is an ASP.Net forum - - you might want to check out: http://forums.microsof...

Datalist Bind from one table with a dropdownlist inside bound to another table based on dataKeyfield
 I'm looking to get the datalist below working. I'm not sure how to bind the dropdown list so that the proper value is displayed from the db.  Basically what i'm doing is pulling a list of skills from a table and displaying them so a user can update thier proficiency. I've got one table for the skills which is bound to the datalist. I then need to get the users proficiency which is stored in another table to be selected in the drowdownlist for each of those skills. Then i must save them all I guess by looping through each row in the datalist? &n...

insert multiple values from one table into one column from another table?
Hi, I'm attempting to create an insert statement that gets the values from multiple columns and insert them into one column from another table, is there a simple solution to do this?Here is something similar to what i'm wanting done, just it's not the correct way to do it, i want value1, value2 and value3 from one table to be combined and put into the value1 column of another table, what am i doing wrong? INSERT INTO tablename2 (value1 + value2 + value3)SELECT value1FROM tablename1 thanks in advance! INSERT INTO tablename2 (SELECT val1 + val2 + val3 FROM tabl...

Updating table with DropDownList values from another table
Hi. I'm trying to insert a value from DropDownList into database. I want to select value from DropDownList(DropDownList has SqLDataSource from another table) and insert that selected value into table.I'm trying to do this in DetailsView. And when I do, i get this error :  Must declare the scalar variable "@ServiceName"Problem starts when i try to edit a record. Oh, and the ServiceName in table Provided_Services is NULL. Please help me with this...Here is my code:  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CustomerID" &nb...

Select values from one table based upon values in another...
How do I:Select f1, f2, f3, from tb1 where f1=Select f1 from tb2 where f1='condition'?Rex WinnCode-frog System Architects, Inc.VS 2005 Professional, C#, C++ Well... You might try reading up on some standard sql syntax... There are a number of different ways... Select t.f1,t.f2,t.f3 From tb1 t INNER JOIN tb2 t2 ON t.f1 = t2.f1 Where t2.f1 = 'condition'   Select t.f1,t.f2,t.f3 From tb1 t Where t.f1 IN (    Select t2.f1    From tb2 t2    where t2.f1 = 'condition')   Select t.f1,t.f2,t.f3 From tb1 t Where exists (select t2....

can I compare one record from one table to another record in another table?
can I compare one record from one table to another record in another table? I need to test if this condition is met. My scenario is: i need to check one table for a value and compare it to a list of records. for example, table 1           columnrecord 1- applesrecord 2- orangesrecord 3- grapes table 2            col1   col2   col3    col4record 1- Null , Null, Null, grapes I need to compare table 2 records with a list of records from table 1. the fru...

select from one table, put into another, delete from original table
Hi there, i am writing a stock control system for a small company. Most of it has been done apart from the picking part. When the user (staff member in the shop) places an order for a customer, they type in the item ID they want + the qty and there is a DDL to say collection, delivery etc. There are 3 main tables involved tbl_stock - where stock information + pics are held tbl_location - where the location of stock is held, each row has 11 columns e.g. Item Name  Qty1  Location1  Qty2  Location2 etc up to 5. Each row is for one item, so for example if there is stockID 2...

DropDownList populated by one table then updates another table (in GridView)
EDIT: Has anyone got a DropDownList to work like this successfully?? Hi all. I'm yet another newbie to ASP.NET an would be very grateful for any help you can offer I also am trying to use a DDL in a GridView and populate the DDL (JobAssignedToDDL) with values (Names) from one table (WorkshopTechnicians). When the user (in edit mode) selects a Name and clicks update, this value is stored in another table (WorkshopJobs). I've tried to implement the code here: http://forums.asp.net/t/1231510.aspx, but can't seem to get it working. At the moment the GV in normal mode display...

CheckBoxList Databinding, Select from One Table, Insert Into another Table
Newbie here! I've looked all over the place to see if I find some code that can get me started with this project, here it goes guys, as usual, all help is appreciated... SQL Server, I have 1 table tblServices that shows all of the services we offer, with 3 fields, such as: ID, CategoryCode, CategoryDescription. When loading my web form I want to offer all of these service options showing them the "CategoryDescription" in a checkboxlist option for my users to click on, and then submit the form into a second table. The second table "tblEx...

Copy values from one table to another table using LINQ to SQL?
Hello,I have two database tables that have different names but identical structure (columns).What is the easiest way to copy the values from one table to the other table using LINQ to SQL? Thanks,-- shawn shawn Hi, As far as I research, we could use "foreach"  to insert the data from one table to another table. The code is shown below.         //there exist two table list and listSecond        DataClassesDataContext dataClass = new DataClassesDataContext(); //create the instance of the DataCon...

CheckBoxList gets text from one table, send values to another table
I am working on making a CheckBoxList in a DetailsView that allows the user to check the boxes of the services they would like to receive. In my SQLDataSource, I have two tables that are involved in this. Columns "ServiceID" and "Name"are stored in one table, "Services," and the columns "UserID" and "ServiceID" are stored in another table, "UserServices." I want the CheckBoxList to grab the value and the name of all the services available and have a box for each with the name beside each box. Once the user clicks on each box they want and then click "Submit" I want all rows in table "Use...

How do i copy / insert a Primary Key value of one table into another table?
  Hi i have set up  two very simple tables, I want a user to be able to create a basic account ( data stored in User_Profile  table with Id set as the Primery Key as Identity) I want the user to be able to be able to return to their account at a later date and then post multiple reviews of different bands they have seen at a later date. I kept the tables in my example very simple so I could get my head around the concept, but generally, I want to connect the Id (PK) value in User_Profile table to the User_Id filed in the User_Review table, so every review th...

Add values to a table based on values in another table
When a record is inserted or updated records in Table1 I want a record to be inserted into table3 for each record ID that is in table2 if the table2.id does not already exist in table3. What is the best way to do this? Could this be done with a trigger? If it could how would I write such a trigger. I have never written one before and this sounds like a hand full for my first effort. Your help will be greatly appreciated. Thanks You could do it in a trigger.  They're really not hard.  It's just SQL you want to run whenever a certain action happens on your table.  Pretty st...