public string GetDistrict(int districtId) { string searchMedicine = "SELECT * FROM tbl_destrict where id='" + districtId + "' "; sqlConnection.Open(); sqlCommand.CommandText = searchMedicine; SqlDataReader reader = sqlCommand.ExecuteReader(); District aDistrict = new District(); while (reader.Read()) { aDistrict.Name = reader["District"].ToString(); } reader.Close(); sqlConnection.Close(); return aDistrict.Name; }
public List<District> GetAllDistrict() { string searchMedicine = "SELECT * FROM tbl_destrict Order By District ASC"; sqlConnection.Open(); sqlCommand.CommandText = searchMedicine; SqlDataReader reader = sqlCommand.ExecuteReader(); List<District> districtList = new List<District>(); while (reader.Read()) { District aDistrict = new District(); aDistrict.Id = Convert.ToInt32(reader["id"].ToString()); aDistrict.Name = reader["District"].ToString(); districtList.Add(aDistrict); } reader.Close(); sqlConnection.Close(); return districtList; }
public List<District> GetAllDistrict() { string query = "SELECT * FROM tbl_destrict ORDER BY District ASC"; sqlConnection.Open(); sqlCommand.CommandText = query; SqlDataReader aReader = sqlCommand.ExecuteReader(); List<District> districtList = new List<District>(); while (aReader.Read()) { District aDistrict = new District(); aDistrict.Id = (int)aReader["id"]; aDistrict.Name = aReader["District"].ToString(); aDistrict.Population = Convert.ToDouble(aReader["Population"].ToString()); aDistrict.LoctLat = aReader["loclat"].ToString(); aDistrict.LoctLong = aReader["loclong"].ToString(); districtList.Add(aDistrict); } aReader.Close(); sqlConnection.Close(); return districtList; }