Question: How to insert values into Client, Payment, Project Table in one SQL Query Database Name: WFM_CMS Table Name: Client, Payment, Project Function: Insert Values into
How to insert values into Client, Payment, Project Table in one SQL Query
Database Name: WFM_CMS
Table Name: Client, Payment, Project
Function: Insert Values into Client, and those Values also have to be inserted into Payment, Project Tables using One SQL Query for C# Add Button



Project Table Column Name Data Type ProjectID int ProjectName varchar(50) ProjectDescription varchar (50) StartDate date EndDate date ProjectStatus varchar (50) Payment Table Column Name Data Type int float varchar (50) PaymentID PaymentAmount PaymentType PaymentDate TotalPaidAmount DuePaymentAmount date float float Grand Total float Client Table Column Name Data Type ClientID int ClientName Email varchar (50) varchar (50) varchar (50) varchar (250) ContactNo Address int varchar (50) varchar (50) int varchar (50) date ProjectID ProjectName ProjectDescription ProjectCost ProjectStatus StartDate EndDate Payment Amount Payment Type PaymentDate TotalPaid Amount DuePayment Amount Grand Total date float varchar (50) date float float float
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
