public List<Thana> GetAllThana(int id) { string searchMedicine = "SELECT * FROM tbl_thana where DistrictId='"+id+"' Order By Thana ASC"; sqlConnection.Open(); sqlCommand.CommandText = searchMedicine; SqlDataReader reader = sqlCommand.ExecuteReader(); List<Thana> thanaList = new List<Thana>(); while (reader.Read()) { Thana aThana = new Thana(); aThana.Id = Convert.ToInt32(reader["id"].ToString()); aThana.Name = reader["Thana"].ToString(); thanaList.Add(aThana); } reader.Close(); sqlConnection.Close(); return thanaList; }
public List<Thana> GetAllThana(int id) { string query = "SELECT * FROM tbl_thana WHERE DistrictId='" + id + "'"; sqlConnection.Open(); sqlCommand.CommandText = query; SqlDataReader aReader = sqlCommand.ExecuteReader(); List<Thana> thanaList = new List<Thana>(); while (aReader.Read()) { Thana aThana = new Thana(); aThana.Id = (int)aReader["id"]; aThana.Name = aReader["Thana"].ToString(); aThana.DistrictId = (int)aReader["DistrictId"]; thanaList.Add(aThana); } aReader.Close(); sqlConnection.Close(); return thanaList; }
public string GetThana(int thanaId) { string searchMedicine = "SELECT * FROM tbl_thana where id='" + thanaId + "'"; sqlConnection.Open(); sqlCommand.CommandText = searchMedicine; SqlDataReader reader = sqlCommand.ExecuteReader(); Thana aThana = new Thana(); while (reader.Read()) { aThana.Name = reader["Thana"].ToString(); } reader.Close(); sqlConnection.Close(); return aThana.Name; }