how to choose a datatype of input parameter they can vary from nvarchar,int,date or any valid datatype depands upon the selected field name from the dropdown

See more:

C#

ASP.NET

SQL

MySQL

Need to create a procedure or query dynamically.
dynamic table name from a dropdown ,and the same for fields.

how to choose a datatype of input parameter they can vary from nvarchar,int,date or any valid datatype depands upon the selected field name from the dropdown.

create procedure field_search(@name nvarchar(255),@field1_name nvarchar(255),@field1_value nvarchar(255),@field2_name nvarchar(255),@field2_value nvarchar(255))
as begin
SELECT * from @name
WHERE     (@field1_name LIKE '%@field1_value%') AND (@field2_name LIKE '%field2_value%')
end

thanks in advance..!!!