iepaul
asked on
VB.NET insert records into SQL 2000 table using data from other tables
I have three tables in MS SQL server 2000 and I am creating an application using VB.Net. I want to read information from two tables and populate the third.
tblProjects - fldProjectNumber, fldCustomerName, fldStartDate
tblTemplate - fldTaskName, fldStartDay, fldOwner
tblTasks - fldProjectNumber, fldTaskName, fldDueDate, fldOwner
In VB.Net I need to read tblProjects and get fldProjectNumber and fldStartDate. I then need to read tblTemplate and get the list of tasks and their start day, and their owner.
These tasks then need to be inserted in to tblTasks where fldDueDate is fldStartDate + fldStartDay (fldStartDay is a number showing how many days before or after the project startdate a task is due).
tblProjects - fldProjectNumber, fldCustomerName, fldStartDate
tblTemplate - fldTaskName, fldStartDay, fldOwner
tblTasks - fldProjectNumber, fldTaskName, fldDueDate, fldOwner
In VB.Net I need to read tblProjects and get fldProjectNumber and fldStartDate. I then need to read tblTemplate and get the list of tasks and their start day, and their owner.
These tasks then need to be inserted in to tblTasks where fldDueDate is fldStartDate + fldStartDay (fldStartDay is a number showing how many days before or after the project startdate a task is due).
ASKER
I am not using LINQ. Can I use that with SQL 2000?
Depending on your targetted framework, LINQ acts as a data access layer between VB.NET and your SQL Server.
Otherwisde you are going to have to manually create all of the insert statements and execute them on the server.
What stage are you at with connecting to your server and getting data etc?
Otherwisde you are going to have to manually create all of the insert statements and execute them on the server.
What stage are you at with connecting to your server and getting data etc?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What method are you using to access your database?
If you are using LINQ it will make things a lot easier!