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;
}