ASP.NET

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;

       }
   }

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataKeyNames="order_id" DataSourceID="SqlDataSource1">
    <Columns>
        <asp:BoundField DataField="order_id" HeaderText="order_id" 
            InsertVisible="False" ReadOnly="True" SortExpression="order_id" />
        <asp:BoundField DataField="order_date" HeaderText="order_date" 
            SortExpression="order_date" />
        <asp:BoundField DataField="order_value" HeaderText="order_value" 
            SortExpression="order_value" />
        <asp:BoundField DataField="order_status" HeaderText="order_status" 
            SortExpression="order_status" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:BoardGamesConnectionString %>" 
    SelectCommand="'OrderInfo'" SelectCommandType="StoredProcedure">
    <SelectParameters>
        <asp:Parameter Name="order_id" Type="Int32" />
        <asp:Parameter Name="order_value" Type="String" />
        <asp:Parameter Name="order_date" Type="String" />
        <asp:Parameter Name="order_status" Type="String" />
        <asp:SessionParameter Name="UserID" SessionField="UserID" 
            Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>

ALTER PROCEDURE [dbo].[Orderinfo]

    @order_id int,
    @order_value nvarchar(max),
    @order_date nvarchar(max),
    @order_status nvarchar(max),
    @UserID int
   
    
AS

   Select order_id, order_date, order_value, order_status from Orders Where UserID=@UserID And order_status='Εκκρεμεί'