search.aspx.cs

图书销售系统源码

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.SqlClient;

public partial class Search : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string BookName = Request.Cookies["BookName"].Value;

            //读取数据库连接字符串
            string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
            //创建数据库连接对象
            SqlConnection myconn = new SqlConnection(settings);
            //打开数据库连接
            myconn.Open();

            SqlCommand myCommand = new SqlCommand("SearchBook", myconn);

            //指明Sql命令的操作类型是使用存储过程
            myCommand.CommandType = CommandType.StoredProcedure;

            //给存储过程添加参数
            SqlParameter parameterSearch = new SqlParameter("@BookName", SqlDbType.NVarChar, 255);
            parameterSearch.Value = BookName;
            myCommand.Parameters.Add(parameterSearch);

            SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
          
            MyList.DataSource = result;
            MyList.DataBind();

            if (MyList.Items.Count == 0)
            {
                ErrorMsg.Text = "没有找到您需要得商品。";
            }
        }

    }
}