searchpage.aspx.cs

用VC++做的一个网上小型网购物系统,需要SQL的支持.

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 _3.D._4
{
	
	/// <summary>
	/// Summary description for WebForm1.
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid dgproddetail;
		protected System.Web.UI.WebControls.TextBox txtsearch;
		protected System.Web.UI.WebControls.Button bnsearch;
		protected System.Web.UI.WebControls.DropDownList ddlsearchcty;
		protected System.Web.UI.WebControls.Label lblcty;
		protected System.Web.UI.WebControls.Label lblmessage;
		protected System.Web.UI.WebControls.Label lblwelcome;
		
		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");
			}
			
		}


		#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.ddlsearchcty.SelectedIndexChanged += new System.EventHandler(this.ddlsearchcty_SelectedIndexChanged);
			this.bnsearch.Click += new System.EventHandler(this.bnsearch_Click);
			this.dgproddetail.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgproddetail_ItemCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		

		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=txtsearch.Text;
				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=txtsearch.Text;
				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=txtsearch.Text;
				DataSet ds = new DataSet();
				myCommand.Fill(ds, "FlowersDetails");
				dgproddetail.DataSource=ds;
				dgproddetail.DataBind();
			}
				
			
			
		}

		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("OnlineShop.aspx?prodid=" + System.Web.HttpUtility.UrlEncode(prodid));
		}

		private void ddlsearchcty_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			strcty=ddlsearchcty.SelectedItem.Text;
		}


	}
}