public List <SubLegalArea> GetSubAreas(int number) { List <SubLegalArea> subLegalAreas = new List <SubLegalArea>(); using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("SP_GetSubLegalAreas", conn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.Add(new SqlParameter("@FK_MA_ID", number)); SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { return(subLegalAreas); } while (reader.Read()) { SubLegalArea subLegalArea = new SubLegalArea { Id = (int)reader["PK_SA_ID"], Title = (string)reader["SA_Title"] }; subLegalAreas.Add(subLegalArea); } } return(subLegalAreas); }
public void select(string Main) { SubLegalArea.SelectionList(); }