using?System;
using?System.Collections;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Web;
using?System.Web.SessionState;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.HtmlControls;
using?System.Configuration?;
using?System.Data?.SqlClient?;

namespace?BMS
{
	///?

	///?AdvancedSearch?的摘要說明。
	///?

	public?partial?class?AdvancedSearch?:?System.Web.UI.Page
	{
	
		protected?void?Page_Load（object?sender?System.EventArgs?e）
		{
			if（!IsPostBack）?BindGrid（）;
		}

		#region?Web?Form?Designer?generated?code
		override?protected?void?OnInit（EventArgs?e）
		{
			//
			//?CODEGEN：該調用是?ASP.NET?Web?窗體設計器所必需的。
			//
			InitializeComponent（）;
			base.OnInit（e）;
		}
		
		///?

		///?設計器支持所需的方法?-?不要使用代碼編輯器修改
		///?此方法的內容。
		///?

		private?void?InitializeComponent（）
		{????

		}
		#endregion


		public?void?DataGrid_Page（object?senderDataGridPageChangedEventArgs?E）
		{
			dgd_booklist.CurrentPageIndex?=E.NewPageIndex?;
			BindGrid（）;
		}
		public?void?BindGrid（）
		{	//從文件Web.config中讀取連接字符串
			string?strconn=?ConfigurationSettings.AppSettings[“dsn“];
			//連接本地計算機的LMS數據庫
			SqlConnection?cn=?new?SqlConnection?（strconn）;
			//創建帶篩子的SQL語句
			string?mysql=“select?*?from?book?where?1=1“;
			//對控建進行篩選
			if?（tbx_bid.Text?.ToString?（）!=““）//如果“書號”有輸入
			{
			try
				{
				?mysql=mysql+“?and?bid=“+Convert.ToInt32?（tbx_bid.Text?.ToString?（））;
				}
			?catch
				{	
				Response.Write?（“書號輸入有誤!“）;
				Response.End（）;
				}
			}
			if?（tbx_bname.Text?.ToString?（）!=““）//如果“書名”有輸入
			{
				mysql=mysql+“?and?bname?like?‘%“+tbx_bname.Text?.ToString?（）+“%‘“;
			}
			if?（tbx_bauthor.Text?.ToString?（）!=““）//如果“書作者”有輸入
			{
				mysql=mysql+“?and?bauthor?like?‘%“+tbx_bauthor.Text?.ToString?（）+“%‘“;
			}
			if?（tbx_bisbn.Text?.ToString?（）!=““）//如果“書ISBN”有輸入
			{
				mysql=mysql+“?and?bisbn=‘“+tbx_bisbn.Text?.ToString?（）+“‘“;
			}
			if?（tbx_bpress.Text?.ToString?（）!=““）//如果“書出版社”有輸入
			{
				mysql=mysql+“?and?bpress?like?‘%“+tbx_bpress.Text?.ToString?（）+“%‘“;
			}
			if?（tbx_btheme.Text?.ToString?（）!=““）//如果“主題詞”有輸入
			{
				mysql=mysql+“?and?btheme?like?‘%“+tbx_btheme.Text?.ToString?（）+“%‘“;
			}
			//創建SqlDataAdapter對象調用視圖
			SqlDataAdapter?da=new?SqlDataAdapter?（mysqlcn）;
			//創建并填充DataSet
			DataSet?ds=new?DataSet?（）;
			da.Fill?（ds）;
			dgd_booklist.DataSource?=ds;
			dgd_booklist.DataBind?（）;
			cn.Close?（）;
		}

		protected?void?btn_search_Click（object?sender?System.EventArgs?e）
		{
			BindGrid（）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????28672??2007-05-15?12:45??readme.doc

?????文件????1048576??2007-05-15?13:01??DB_51aspx\LMS_Data.MDF

?????文件????1048576??2007-05-15?13:01??DB_51aspx\LMS_Log.LDF

?????目錄??????????0??2007-05-15?13:00??DB_51aspx

?????文件???????3347??2004-09-01?12:32??LMS\acn98.gif

?????文件???????5434??2007-05-15?11:29??LMS\AdvancedSearch.aspx

?????文件???????2793??2007-05-15?11:29??LMS\AdvancedSearch.aspx.cs

?????文件???????3603??2007-05-15?11:29??LMS\AdvancedSearch.aspx.designer.cs

?????文件???????1733??2004-09-01?12:32??LMS\AdvancedSearch.aspx.resx

?????文件???????7474??2007-05-15?12:38??LMS\AdvancedSearchForReader.aspx

?????文件???????2835??2007-05-15?11:29??LMS\AdvancedSearchForReader.aspx.cs

?????文件???????3609??2007-05-15?11:29??LMS\AdvancedSearchForReader.aspx.designer.cs

?????文件???????1733??2004-09-01?12:32??LMS\AdvancedSearchForReader.aspx.resx

?????文件???????2102??2004-09-01?12:32??LMS\AssemblyInfo.cs

?????文件??????49152??2007-05-15?12:49??LMS\bin\LMS.dll

?????文件?????116224??2007-05-15?12:49??LMS\bin\LMS.pdb

?????目錄??????????0??2007-05-15?11:35??LMS\bin

?????文件???????7010??2007-05-15?11:29??LMS\BookAdd.aspx

?????文件???????4246??2007-05-15?12:40??LMS\BookAdd.aspx.cs

?????文件???????8099??2007-05-15?11:29??LMS\BookAdd.aspx.designer.cs

?????文件???????1733??2004-09-01?12:32??LMS\BookAdd.aspx.resx

?????文件??????11164??2007-05-15?12:38??LMS\BookClassify.aspx

?????文件????????928??2007-05-15?11:29??LMS\BookClassify.aspx.cs

?????文件????????943??2007-05-15?11:29??LMS\BookClassify.aspx.designer.cs

?????文件???????1733??2004-09-01?12:32??LMS\BookClassify.aspx.resx

?????文件???????8166??2007-05-15?12:38??LMS\BookDetail.aspx

?????文件???????3119??2007-05-15?11:29??LMS\BookDetail.aspx.cs

?????文件???????4933??2007-05-15?11:29??LMS\BookDetail.aspx.designer.cs

?????文件???????1733??2004-09-01?12:32??LMS\BookDetail.aspx.resx

?????文件???????5482??2007-05-15?11:29??LMS\BookManage.aspx

............此處省略126個文件信息