If you are with "Views" then no worries.
Below is the way how to handle multiple parameters with SQL Views.
Create a variable called "Where" inside pass all your SQL parameters by concatenating.
Example : If you are having EmployeeMst table and you have created a view called "View_Select_All_Employees" then call this view as below.
string Where = " Where 1=1 ";
if(txtFName.Text.Trim() != Null)
{
Where += " And EmpFName ='"+ txtFName.Text.Trim() +"'";
}
if(txtLName.Text.Trim() != Null)
{
Where += " And EmpLName ='"+ txtLName.Text.Trim() +"'";
}
string commandText = "select * from View_Select_All_Employees " + Where;
SqlCommand command = new SqlCommand(commandText, connection);
command.Parameters.Add("@studentid", 101);
Hope this will help you..!!! :)