```
SqlCommand cmdadmin = new SqlCommand("loginvalidation");
cmdadmin.Connection = con;
cmdadmin.CommandType = CommandType.StoredProcedure;
SqlParameter paramadmin;
paramadmin = new SqlParameter("@vtype",drd1.ToString());
SqlParameter paramadmin1;
paramadmin1 = new SqlParameter("@username",Label1.Text);
cmdadmin.Parameters.Add(paramadmin1,paramadmin);

```

This Is My C# code

I am using Stored procedure to display the following result in select Command but I don't know how to use multiple parameters in a select statement