declare @var varchar(200)=' ''rs001'',''am001'' ' Exec ('select * from Emp_Master where empcode IN (' + @var + ')')
Concatenate all the values selected in the Dropdown using comma. Then pass this concatenated value to the parameter in the stored procedure. In the query assign this parameter as below
Select * from <table_name> Where <column_name> in (@parameter)</column_name></table_name>
Hope this helps
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)