myBks.aspx.cs

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Assignment3
{
    public partial class myBks : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            booksTable.CssClass = "table table-hover";
            TableRow tRow = new TableRow();
            booksTable.Rows.Add(tRow);
            TableCell tCell1 = new TableCell();
            TableCell tCell2 = new TableCell();
            TableCell tCell3 = new TableCell();
            TableCell tCell5 = new TableCell();
            tCell1.Text = "Title";
            tCell2.Text = "Author";
            tCell3.Text = "ISBN";
            tCell5.Text = "Category";
            tRow.Cells.Add(tCell1);
            tRow.Cells.Add(tCell2);
            tRow.Cells.Add(tCell3);
            tRow.Cells.Add(tCell5);

            Object idU = Session["id"];
            string idUserStr = (string)idU;
            int idUser = int.Parse(idUserStr);

            string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

            string sql = "select distinct BookTitle, BookAuthor, ISBN, CAT_NAME, BookId from Book, Category, History, ud WHERE Book.CAT_ID=Category.CAT_ID AND History.HUserId="+idUser+" AND History.HBookId=Book.BookId AND ReturnDate IS NULL ";
            SqlConnection con = new SqlConnection(connStr);
            SqlCommand cmd = new SqlCommand(sql, con);
            SqlDataReader dr;

            try
            {
                con.Open();

                dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    TableRow tRow2 = new TableRow();
                    booksTable.Rows.Add(tRow2);
                    for (int j = 0; j <= 3; j++)
                    {
                        // Create a new cell and add it to the row.
                        TableCell tCell = new TableCell();
                        tCell.Text = dr[j].ToString();
                        tRow2.Cells.Add(tCell);

                    }
                    if (Session["id"] != null)
                    {
                        TableCell tCell4 = new TableCell();
                        string id = dr[4].ToString();
                        tCell4.Text = "<a href='return.aspx?id=" + id + "'><span class='btn btn-primary glyphicon glyphicon-cloud-upload'>Return </span></a>";
                        tRow2.Cells.Add(tCell4);
                    }
                }

                dr.Close();


            }
            catch (Exception ex)
            {
                Response.Write(ex.ToString());
            }
            finally
            {

                con.Close();
            }

        }
    }
}