public static List <FipsKeyRecord> GetStates(SqlConnection scon) { SqlCommand getfips = new SqlCommand(@"SELECT * FROM[Geography].[dbo].[FipsKeys] where placecode = '00000' and county = '000'", scon); var sr = getfips.ExecuteReader(); List <FipsKeyRecord> results = new List <FipsKeyRecord>(); while (sr.Read()) { var f = new FipsKeyRecord(); f.Read(sr); results.Add(f); } sr.Close(); return(results); }
public static List <FipsKeyRecord> GetCountyByState(string numericStateCode, SqlConnection scon) { SqlCommand getfips = new SqlCommand("SELECT * FROM[Geography].[dbo].[FipsKeys] where County<>'000' and State=@state", scon); getfips.Parameters.AddWithValue("@state", numericStateCode); var sr = getfips.ExecuteReader(); List <FipsKeyRecord> results = new List <FipsKeyRecord>(); while (sr.Read()) { var f = new FipsKeyRecord(); f.Read(sr); results.Add(f); } sr.Close(); return(results); }
public static List <FipsKeyRecord> GetPlaceByState(string numericStateCode, SqlConnection scon) { SqlCommand getfips = new SqlCommand("select * from dbo.FipsKeys f where f.PlaceCode <> '00000' and state=@state", scon); getfips.Parameters.AddWithValue("@state", numericStateCode); var sr = getfips.ExecuteReader(); List <FipsKeyRecord> results = new List <FipsKeyRecord>(); while (sr.Read()) { var f = new FipsKeyRecord(); f.Read(sr); results.Add(f); } sr.Close(); return(results); }