using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.OleDb;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        OleDbConnection conn;
//        OleDbCommand command;
//        OleDbDataReader rdrResults;
        string strConn;
        string strSQL;

        strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                    "Data Source=" +
                    Server.MapPath("books.mdb") + ";";

        conn = new OleDbConnection(strConn);

        conn.Open();

        // this is new to the dataset example
        DataSet DS;
        OleDbDataAdapter data_adapter;

        strSQL = "Select * from Categories";
        data_adapter = new OleDbDataAdapter(strSQL, conn);
        
//        command = new OleDbCommand(strSQL, conn);

        // this is new to the dataset example
        DS = new DataSet();
        data_adapter.Fill(DS, "Categories");
        
//        command.Fill(DS, "Categories");

//        rdrResults = command.ExecuteReader();
//        grdCategories.DataSource = rdrResults;

        // this is new to the dataset example
        grdCategories.DataSource = DS.Tables["Categories"].DefaultView;

        grdCategories.DataBind();

//        rdrResults.Close();

        if (Request.QueryString["cat"] != null)
        {
            LabelCategory.Text = "Category Selected: " + Request.QueryString["cat"];

            strSQL = "Select Title, Price from Titles where [Titles].type='" + Request.QueryString["cat"] + "'";
//            command = new OleDbCommand(strSQL, conn);

            data_adapter = new OleDbDataAdapter(strSQL, conn);
            data_adapter.Fill(DS, "Titles");

//            rdrResults = command.ExecuteReader();
//            grdBooks.DataSource = rdrResults;

            grdBooks.DataSource = DS.Tables["Titles"].DefaultView;

            grdBooks.DataBind();

//            rdrResults.Close();
        }

        conn.Close();
    }
    protected void ButtonAddCat_Click(object sender, EventArgs e)
    {
        OleDbConnection conn;
        string strConn;
        string strSQL;

        strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                    "Data Source=" +
                    Server.MapPath("books.mdb") + ";";

        conn = new OleDbConnection(strConn);

        conn.Open();

        DataSet DS;
        OleDbDataAdapter data_adapter;

        strSQL = "Select * from Categories";
        data_adapter = new OleDbDataAdapter(strSQL, conn);

        DS = new DataSet();
        data_adapter.Fill(DS, "Categories");

        OleDbCommandBuilder cmdBldr = new OleDbCommandBuilder(data_adapter); 
        
        DataRow dr = DS.Tables["Categories"].NewRow();
        dr["category"] = TextBox1.Text;
        DS.Tables["Categories"].Rows.Add(dr);

        data_adapter.Update(DS, "Categories");

        grdCategories.DataSource = DS.Tables["Categories"].DefaultView;
        grdCategories.DataBind();

        conn.Close();
    }
}