public List<Thana> GetThanaAccordingToDistrict(int id) { List<Thana> thanas=new List<Thana>(); SqlConnection connection = new SqlConnection(connectionstring); string query = "SELECT t.thana_Id,t.thana_Name FROM Table_Thana as t join Table_District as d on t.thana_DistrictId=d.district_Id WHERE thana_DistrictId='"+id+"'"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Thana thana = new Thana(); thana.Id = int.Parse(reader["thana_Id"].ToString()); thana.Name = reader["thana_Name"].ToString(); thanas.Add(thana); } reader.Close(); connection.Close(); return thanas; }
public List<Thana> GeThanas() { List<Thana>thanas=new List<Thana>(); SqlConnection connection=new SqlConnection(connectionstring); string query = "SELECT * FROM Table_Thana"; SqlCommand command=new SqlCommand(query,connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Thana thana=new Thana(); thana.Id = int.Parse(reader["thana_Id"].ToString()); thana.Name = reader["thana_Name"].ToString(); thana.DistrictId = int.Parse(reader["thana_DistrictId"].ToString()); thanas.Add(thana); } reader.Close(); connection.Close(); return thanas; }