图书管理搜索部份

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class Search : System.Web.UI.Page
{
    static string strconn = "Data Source=localhost;database=BOOKS;integrated security=SSPI";
    SqlConnection conn = new SqlConnection(strconn);
    protected void Page_Load(object sender, EventArgs e)
    {
     
       
    }
    protected void ByBookName_CheckedChanged(object sender, EventArgs e)
    {

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default.aspx");
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        bool flag = false; //标志是显示GridView控件及数据
        string SQL = "SELECT * FROM BOOKSTORAGE WHERE ";
        string condition = "";
        if (CheckBoxByBkName.Checked == true)
        {
            condition += "bk_name like '%" + TextBoxByName.Text+"%' and";
        }
        if (CheckBoxByAuthor.Checked == true)
        {
            condition += " bk_author like '%" + TextBoxByAuthor.Text + "%' and";
        }
        if (condition != "")
        {
            SQL += condition.Substring(0, condition.Length - 3);//减去最后的"and"
            flag = true;
        }
        else
        {
            SQL = SQL.Substring(0, SQL.Length - 6);//减去最后的"where"
            flag = true;
        }
        SqlConnection conn = new SqlConnection(strconn);
        SqlCommand cmd = conn.CreateCommand();
        cmd.CommandText=SQL;
        conn.Open();
        if (flag)
        {
            Message.Text = "您搜索到的结果:";
            gvShow.Visible = true;
            gvShow.DataSource = cmd.ExecuteReader();
            gvShow.DataBind();

        }
        else
        {
            Message.Text = "对不起，您没有输入条件，请重试!";       
        }
    }
    protected void gvShow_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}