ASP.NET

// Populate Room and add Please Select
            // This shows ALL Rooms ---> string commandText1 = "SELECT * FROM tblRoom";\
            // Below shows ALL rooms minus any chosen before but does not consider day of the week (week_Day) or (start_Time and end_Time) of the class.
            string commandText1 = "SELECT * FROM tblRoom WHERE NOT EXISTS (SELECT * FROM tblClass WHERE tblRoom.room_Num = tblClass.room_Num)";
           


            var ds1 = new DataSet();

            using (var connection = new OleDbConnection(connectionString))
            using (var command = new OleDbCommand(commandText1, connection))
            {
                // OleDbCommand uses positional, rather than named, parameters.
                // The parameter name doesn't matter; only the position.
                command.Parameters.AddWithValue("@p0", ddlRoom.SelectedValue);

                var adapter = new OleDbDataAdapter(command);
                adapter.Fill(ds1);
            }

            ddlRoom.DataSource = ds1;
            ddlRoom.DataTextField = "room_Num";
            ddlRoom.DataValueField = "room_Num";
            ddlRoom.DataBind();
            ddlRoom.Items.Insert(0, new ListItem("Please Select", "0"));
            ddlRoom.Items.Insert(1, new ListItem("TBD", "TBD"));
        }

    }

protected void Button_Rssreader_Click(object sender, EventArgs e)
       {
           var reader = XmlReader.Create(TextBox1.Text);
           var feed = SyndicationFeed.Load(reader);

           reader.Close();

           string s = "";
           foreach (SyndicationItem i in feed.Items)
           {

               s += i.Title.Text + "<br />" + i.Summary.Text + "<br/>" + i.PublishDate.ToString() + "<br />" + "<br />" + (i.Content as TextSyndicationContent).Text.Trim();

                       s += "<hr />";
           }
           Literal1.Text = s;
       }

private bool ValidateTeacher(string TeacherID, String Semester)
   {
       // Populate Room and add Please Select
       string path = Server.MapPath("eAcademy_DB.mdb");
       string connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" + path;
       string commandText = "SELECT COUNT(*) FROM tblClass WHERE emp_ID=? and sem_Time=?";

       var ds6 = new DataSet();

       using (var connection = new OleDbConnection(connectionString))
       using (var command = new OleDbCommand(commandText, connection))
       {
           // OleDbCommand uses positional, rather than named, parameters.
           // The parameter name doesn't matter; only the position.


           var adapter = new OleDbDataAdapter(command);
           if (ds6.Tables[0].Rows.Count > 3)
           {
               return false;
           }
           else return true;

       }
   }