Click here to Skip to main content
15,867,568 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)
Posted
Comments
Richard Deeming 20-Oct-15 10:44am    
Which table are you trying to update / delete from?
[no name] 20-Oct-15 12:43pm    
Gridview in binded with both tables("Jobmaster" and second is "RAssign".)some column are from one tabe and some column are from second table and I want to delete complete row.
Richard Deeming 20-Oct-15 12:44pm    
From which table?
[no name] 20-Oct-15 13:11pm    
"Jobmaster" and "Rassign" these both are database tables in one gridview I have also attached some select statement code as well..
Richard Deeming 20-Oct-15 14:52pm    
But which table do you want to delete from or update?

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