StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionStri ng); cmd.Connection.Open(); SqlDataReader lugeja = cmd.ExecuteReader(); while (lugeja.Read()) { rollid.Add(lugeja["Nimi"].ToString()); } lugeja.Close(); cmd.Connection.Close(); return (string[])rollid.ToArray(typeof(string)); } public override string[] FindUsersInRole(string roleName, string usernameToMatch) { ArrayList kasutajad = new ArrayList(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "FindUsersInRole_proc"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionStri ng); cmd.Parameters.AddWithValue("@RoleName", roleName); cmd.Parameters
StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionString); cmd.Connection.Open(); SqlDataReader lugeja = cmd.ExecuteReader(); while (lugeja.Read()) { rollid.Add(lugeja["Nimi"].ToString()); } lugeja.Close(); cmd.Connection.Close(); return (string[])rollid.ToArray(typeof(string)); } public override string[] FindUsersInRole(string roleName, string usernameToMatch) { ArrayList kasutajad = new ArrayList(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "FindUsersInRole_proc"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionString); cmd.Parameters.AddWithValue("@RoleName", roleName); cmd.Parameters
annaabi.ee 
