how to write simple query

Question

hi

this is my sp

UPDATE Con

SET Category1code =c1.Category1Name, Category2Code=c2.Category2Name

FROM Contacts Con

INNER JOIN Category1 As c1

ON Con.Category1Code = c1.Category1Code

Inner Join Category2 As c2

ON Con.Category2Code = c2.Category2Code

just i want write above sp into simple query like

SqlConnection Con=new SqlConnection();
SqlCommand cmd=New SqlCommand("how to write above sp here",con);

please give me solution
thanx in advance.

Pradip Pandey · Answer

Hi Use following code string sqlQuery =  UPDATE Con  +  SET Category1code = c1.Category1Name Category2Code = c2.Category2Name  +  FROM Contacts Con  + INNER JOIN Category1 As c1  + ON Con.Category1Code = c1.Category1Code  + Inner Join Category2 As c2  + ON Con.Category2Code = c2.Category2Code ; SqlConnection Con=new SqlConnection(); SqlCommand cmd=New SqlCommand( sqlQuery con); Hope it will help.

Ajinkya Ban · Answer

thanx...

Ajinkya Ban · Answer

thnx..

Pradip Pandey · Answer

Simple select statement you can use like this Select Con.Category1code Con.category2code From Contacts Con This is because previously you have updated Category1code & Category2code with categoryname. Hope it will help.

Vishal Gilbile · Answer

Hi You just need to call the procedure following is the way for calling. SqlConnection con=new SqlConnection(Your Connection string over here); SqlCommand cmd=new SqlCommand(ProcedureNamecon); cmd.CommandType=CommandType.StoredProcedure; //if your procedure accepts parameter you need to add it for instance if my proc accepts //a parameter name @name I will add it in the following way. cmd.Parameter.AddWithValue(@namevalue); // Rest of the execution is same what we do for single line query. With Regards Vishal Gilbile

Ajinkya Ban · Answer

how we can replace this update query into Select query

Pradip Pandey · Answer

Hi Please mark it as Accepted Answer if it really helped you. Hope it will help.

Ajinkya Ban · Answer

thanx sir...