knowsearchresult.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 Web_KnowSearchResult : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
   {
        if(!this.IsPostBack)
        {
           
            KeywordEntity key = new KeywordEntity();
            KeywordDA keyda = new KeywordDA();
            DataSet ds = new DataSet();
        
            Label1.Text = Request.QueryString["keywords"];
            //定义拆分标识符数组
            char[] delimiterChars = { ' ', ',', '.', ':', '\t' };

            string text = Label1.Text.ToString();
            string[] words = text.Split(delimiterChars);

            int j = words.Length;
            
            string strSQL = "SELECT c.Knowledge_id,Knowledge_title,Knowledge_content,Knowledge_accessary,Knowledge_issuetime,Knowledge_pUsername "
                +"FROM tb_Keyword as b inner join tb_Ref_key2know as c on b.Keyword_id = c.Keyword_id inner join tb_Knowledge as a on a.Knowledge_id=c.Knowledge_id" +
                        " WHERE 1 = 1 ";

            for (int i = 0; i < j; i++)
            {
                strSQL = strSQL + " AND Keyword_name = @Keyword_name" + i.ToString();
            }
            //对参数逐个进行赋值
            SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction);
            SqlCommand sqlc = new SqlCommand(strSQL,conn);
            
            sqlc.Parameters.Clear();

            for (int n = 0; n < j; n++)
            {
                sqlc.Parameters.Add("Keyword_name" + n, SqlDbType.VarChar, 20);
                sqlc.Parameters["Keyword_name" + n].Value = words[n];
            }

            SqlDataAdapter sa = new SqlDataAdapter(sqlc);
            //for (int n = 0; n < j; n++)
            //{
            //    //sa.Parameters.Add(words[n], SqlDbType.VarChar, 20);
            //    sa.SelectCommand.Parameters.Add(words[n], SqlDbType.VarChar, 20);

            //}

            int a = 0;
            a = sa.Fill(ds);


             if (a > 0 || ds.Tables[0].Rows.Count > 0)
            {
                this.GridView1.DataSource = ds;
                this.DataBind();
            }
            
            
        }
            
    }

    
}