asp.net - How to pass concatenated value of drop down to stored proc as parameter -

i have drop down in values concatenated 2 columns of table, use value of drop down parameter stored procedure, possible? how that?

this code

create procedure [dbo].[reassign]    @recordumber int    @employeename begin     update qr     set qr.qamemberid = @qamemberid     roster qr     inner join teammaster s tm         on qr.qamemberid = tm.qamemberid     qr.recordnumber = @recordumber       , qr.firstname, qr.lastname = @employeename end 

and qr.firstname, qr.lastname = @employeename know last piece of code wrong... how can right way? thank you...

do not concatenate values in code, rather use parameter firstname , parameter lastname, this:

create procedure [dbo].[reassign]     @recordumber int,     @firstname,     @lastname begin     update qr     set qr.qamemberid = @qamemberid     roster qr     inner join teammaster s tm          on qr.qamemberid = tm.qamemberid     qr.recordnumber = @recordumber         , qr.firstname = @firstname, qr.lastname = @lastname end