How to update the data using stored procedures code?

[bommanaboyina]

iam using textbox1,textbox2,textbox3 for Empid,Ename,Esalary and iam upadting the data using update button for that im using stored procedure for updating ename esalary and the problem is some times i dont want to update the Ename but i wrote the stored procedure for updating both ename and esalary as well....when iam leaving the textbox2 as empty iam getting the errors so how can i modify my stored procedure with if statement for accepting the previous values also if i laeve textbox as empty

[Antony Nadan]

If you have empid as the primary key and if you are updating based on the empid ,, u should not get any sort of error, even if you leave the textbox2 or textbox3 empty.......

[Rabbit]

Build a dynamic SQL string in the stored procedure using the ifs and then execute that. Make sure you sanitize the inputs first.

[bommanaboyina]

Hai Rabb, can u plz provide me the solution i.e, procedure with if's for my problem.................

[Rabbit]

Sorry, we don't provide full solutions here. We can help you get there but we won't do it all for you.