Click here to Skip to main content
15,921,463 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I want to delete and update a row in Gridview but that grid have values of two tables

I'm using following sttement for selecting-
SELECT JobMaster.Country, JobMaster.City, JobMaster.State, JobMaster.EmploymentType, JobMaster.JobTitle, JobMaster.SpecializedArea, JobMaster.Specializedskill, JobMaster.ID, JobMaster.[Post Assign], RAssign.RecruiterID AS Post_Assign FROM JobMaster LEFT OUTER JOIN RAssign ON JobMaster.ID = RAssign.JobID WHERE (RAssign.RecruiterID = @RecruiterID) OR (@RecruiterID IS NULL)

What statement should I use for Update,Insert and for delete?
(Actually I'm new in coding and I just know to delete from single table but in above statement we are selecting to tables data one is "Jobmaster" and second is "RAssign".
Please help me if possible)
Updated 19-Oct-15 20:14pm
So where is the problem?
Krunal Rohit 19-Oct-15 0:39am    
What's been done so far ?


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900