using System;
 
using System.Collections;
 
using System.ComponentModel;
 
using System.Data;
 
using System.Data.OleDb;
 
using System.Drawing;
 
using System.Web;
 
using System.Web.SessionState;
 
using System.Web.UI;
 
using System.Web.UI.WebControls;
 
using System.Web.UI.HtmlControls;
 
namespace lms
 
{
 
///<summary>
 
/// Summary description for inc_search_books.
 
///</summary>
 
public class inc_search_books : System.Web.UI.Page
 
{
 
protected System.Web.UI.WebControls.TextBox Q;
 
protected System.Web.UI.WebControls.Button Button1;
 
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
 
protected System.Web.UI.WebControls.Label Label1;
 
protected System.Web.UI.WebControls.DropDownList SearchType;
 
 
 
private void Page_Load(object sender, System.EventArgs e)
 
{
 
// Put user code to initialize the page here
 

 
if (Session["Student"]!="Yes")
 
{
 
Response.Redirect("Login1.aspx"); 
 
}
 
 
 
}
 
#region Web Form Designer generated code
 
override protected void OnInit(EventArgs e)
 
{
 
//
 
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
 
//
 
InitializeComponent();
 
base.OnInit(e);
 
}
 
 
 
///<summary>
 
/// Required method for Designer support - do not modify
 
/// the contents of this method with the code editor.
 
///</summary>
 
private void InitializeComponent()
 
{ 
 
this.Button1.Click += new System.EventHandler(this.Button1_Click);
 
this.Load += new System.EventHandler(this.Page_Load);
 
}
 
#endregion
 
private void Button1_Click(object sender, System.EventArgs e)
 
{
 
if (Q.Text!="")
 
{
 
string source = "";
 
switch (SearchType.SelectedIndex)
 
{
 
case 0:
 
source = "select * from book where name like '*" + Q.Text.ToString() + "*' OR description like '*" + Q.Text.ToString() + "*'";
 
break;
 
case 1:
 
source = "select * from book where isbn like '*" + Q.Text.ToString() + "*'";
 
break;
 
case 2:
 
source = "select * from book where publisher like '*" + Q.Text.ToString() + "*'";
 
break;
 
default:
 
source = "select * from book";
 
break;
 
}
 
Response.Write(source);
 
OleDbConnection con = new OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_lms"]);
 
con.Open(); 
 
OleDbCommand cmd=new OleDbCommand(source,con); 
 
OleDbDataReader r = cmd.ExecuteReader();
 
string StrResult="<table width=100% style=\"border:1px solid #ffffff;\">";
 
StrResult += "<tr><td align=center height=35 valign=middle style=\"border:1px solid #ffffff;background-color:#fed500;color:#000000;\"><b>Search Results</b></td></tr>";
 
 
 
while(r.Read()){
 
StrResult += "<tr><td><div class=header><b>" + r["Name"] + "</b> by "+ r["authors"] +"</div><BR>"+r["description"] +"</td></tr>";
 
StrResult += "<tr><td><b>Price: </b>"+ r["price"] +" | ";
 
StrResult += "<b>ISBN: </b>"+ r["isbn"] +" | ";
 
StrResult += "<b>Quantity: </b>"+ r["NoOfAvailableBooks"] +" | ";
 
StrResult += "<b>Publisher: </b>"+ r["publisher"] +" | ";
 
if (r["status"].ToString()=="True")
 
{
 
StrResult += "<b>Available: </b><font color=00ff00>Yes</font>";
 
}
 
else
 
{
 
StrResult += "<b>Available: </b><font color=fed500>No</font>";
 
}
 
if (r["type"].ToString()=="True")
 
{
 
StrResult += " | <b>PDF: </b><font color=00ff00>Yes</font>";
 
}
 
else
 
{
 
StrResult += " | <b>PDF: </b><font color=fed500>No</font>";
 
}
 
StrResult += " | <a href=\"inc_request_book.aspx?BookID="+r ["Id"] +"\">Request to Issue this book</a>";
 
StrResult +="<BR><strong>Accession #: </strong>" +r["Accession"].ToString()+"</td></tr>";
 
 
 
}
 
StrResult += "</table>";
 
r.Close();
 
con.Close();
 
cmd.Dispose();
 
Label1.Text=StrResult;
 
}
 
 
 
}
 
 
 
}
 
}
 

using System;
using System.Data;
using System.Data.Common;
using System.Data.OleDb;

namespace DataConnection
{
	/// <summary>
	/// Creates connection to query and modify a database
	/// </summary>
	public class DBConnection
	{

		private System.String	strConnection;//connection string


		public DBConnection(string ConnectionString)
		{
			strConnection = ConnectionString;
			//strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;" + 
			//			@"Data Source=\dir\Mydb.mdb; User Id=dbUser; Password=pass";	
		}



		protected OleDbConnection Connect()
		{
			OleDbConnection conn = null;

				//create the connection from the connection string
			conn =	new OleDbConnection(strConnection);

			conn.Open();


			return conn;
		}


			//Used for database SELECT queries	
		public System.Data.DataSet Select(string selectQuery)
		{

			if(selectQuery.Length <=1)
			{
				return null;
			}


				//create new connection
			OleDbConnection conn = this.Connect();

			DataSet dataSet = new DataSet();


				//create new adapter and command builder
			OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
			OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter);


				//Send SELECT query - set the dataadapters select statment to our select 
				//					  and out open connection 
			dataAdapter.SelectCommand = new OleDbCommand (selectQuery, conn);


				//fills our datatable with retreived table
			dataAdapter.Fill(dataSet);


			conn.Close();
			conn.Dispose();

			return dataSet;
		}//end Select



			//Used to INSERT, DELETE, UPDATE sql statments
		public void Modify(string mod)
		{


			OleDbConnection conn = this.Connect();

			OleDbCommand command = new OleDbCommand(mod,conn);

			command.ExecuteNonQuery();

			conn.Close();
			conn.Dispose();


		}//end Modify


	}//end DBConnection
}

string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Mydb.mdb;";