c# - If data from database table column has country name then display "text on datatable" : I was able to retieve data from sql database and return it in json format . Now i have this region table which has the region and country name on it .

Now wen retrieving data from this table which has country name i want to display only the let say airport on that country only one airport .



    public void GetAllRooms()
        {
            

            string cs = ConfigurationManager.ConnectionStrings["MYDB"].ConnectionString;
            using (SqlConnection con = new SqlConnection(cs))
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = con;
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = "SELECT tblResortsRooms.intResortID, tblResortsRooms.strRoomType,tblResortsRooms.strDescription, tblRegions.strRegion FROM ((tblResortsRooms INNER JOIN tblResorts ON tblResorts.intResortID = tblResortsRooms.intResortID) INNER JOIN tblRegions ON tblRegions.intRegionID = tblResorts.intResortID);";
                con.Open();
                DataTable dt = new DataTable();
                
               // NEED HELP IN ENTRING THAT CODE HERE

                SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                adapter.Fill(dt);

                string JSONString = string.Empty;
                JSONString = JsonConvert.SerializeObject(dt);
                Context.Response.Write(JSONString);
             
     
            
        }