searchpage.aspx.cs

这是用ASP+SQL+HTML+XML写的

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.Data.SqlClient;

namespace Lesson3D4
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid dgproddetail;
		protected System.Web.UI.WebControls.DropDownList ddlsearchcty;
		protected System.Web.UI.WebControls.Label lblwelcome;
		protected System.Web.UI.WebControls.Label lblmessage;
		protected System.Web.UI.WebControls.Label lblcty;
		protected System.Web.UI.WebControls.TextBox txtsearch;
		protected System.Web.UI.WebControls.Button bnsearch;

		static string strcty;
		SqlConnection cn;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				ddlsearchcty.Items.Add("Toys");
				ddlsearchcty.Items.Add("Books");
				ddlsearchcty.Items.Add("Flowers");
				//strcty="Toys";
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.dgproddetail.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgproddetail_ItemCommand);
			this.dgproddetail.SelectedIndexChanged += new System.EventHandler(this.dgproddetail_SelectedIndexChanged);
			this.bnsearch.Click += new System.EventHandler(this.bnsearch_Click);
			this.ddlsearchcty.SelectedIndexChanged += new System.EventHandler(this.ddlsearchcty_SelectedIndexChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void dgproddetail_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//TableCell itemCell = e.Item.Cells[1];
			//string prodid=itemCell.Text;
			//Navigates the execution of the application to the Web form OnlinePurchase.aspx and passes the value stored in prodid to the Web Form
			//Response.Redirect("OnlinePurchase.aspx?prodid=" + System.Web.HttpUtility.UrlEncode(prodid));
		}

		private void ddlsearchcty_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			//得到从下拉列表中选择的商品类型
			strcty=ddlsearchcty.SelectedItem.Text;
		}

		private void bnsearch_Click(object sender, System.EventArgs e)
		{
			dgproddetail.Visible=true;
			cn=new SqlConnection("server=.;database=WebShoppe;user id=sa;password=;");
			string srch=txtsearch.Text;
			if (strcty=="Books")
			{
				SqlDataAdapter myCommand = new SqlDataAdapter("select * from BooksDetails where freetext(*,@srch)", cn);
				myCommand.SelectCommand.Parameters.Add("@srch",SqlDbType.NChar,30);
				myCommand.SelectCommand.Parameters["@srch"].Value=srch;
				DataSet ds = new DataSet();
				myCommand.Fill(ds, "BooksDetails");
				dgproddetail.DataSource=ds;
				dgproddetail.DataBind();
			}
			if (strcty=="Toys")
			{
				SqlDataAdapter myCommand = new SqlDataAdapter("select * from ToysDetails where freetext(*,@srch)", cn);
				myCommand.SelectCommand.Parameters.Add("@srch",SqlDbType.NChar,30);
				myCommand.SelectCommand.Parameters["@srch"].Value=srch;
				DataSet ds = new DataSet();
				myCommand.Fill(ds, "ToysDetails");
				dgproddetail.DataSource=ds;
				dgproddetail.DataBind();
			}
			if (strcty=="Flowers")
			{
				SqlDataAdapter myCommand = new SqlDataAdapter("select * from FlowersDetails where freetext(*,@srch)", cn);
				myCommand.SelectCommand.Parameters.Add("@srch",SqlDbType.NChar,30);
				myCommand.SelectCommand.Parameters["@srch"].Value=srch;
				DataSet ds = new DataSet();
				myCommand.Fill(ds, "FlowersDetails");
				dgproddetail.DataSource=ds;
				dgproddetail.DataBind();
			}
		}

		private void dgproddetail_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}
	}
}