stored procedure update from c#.net

hi
i want to change procedure
example :
create procedure emp
as
begin
        select *from employee
end

this is my procedure.that procedure i want to change like this.
the fallwoing procedure i added order by empname.
create procedure emp
as
begin
        select *from employee order by empname asc
end

http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/insert-edit-update-in-gridview-using-single-stored-procedure/