Passing multiple parameters to sp in asp.net

See more:

ASP.NET

SQL

Hi all,

i have query as

select * from LoginTable where RoleId in ('1','2','3')

i want to pass these parameters via my asp.net code,
i don't know how to pass parameter with multiple values please help me with sp also
doing this for the first time your help will be greatly appreciated.

public static DataSet GetLoginInfo(string[] roleid)
 {
     SqlConnection conn = DBConnection.GetConnection();
     SqlCommand cmd = new SqlCommand("GetLoginInfo", conn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add(new SqlParameter("@roleid", SqlDbType.VarChar)).Value = roleid;

     SqlDataAdapter da = new SqlDataAdapter(cmd);
     DataSet ds = new DataSet();
     try
     {
         conn.Open();
         da.Fill(ds);
     }
     catch (Exception) { throw; }
     finally
     {
         conn.Close();
         cmd.Connection = null;
         cmd.Dispose();
     }
     return ds;
 }