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



    }