后台asp.Net 站内搜索 学习课件

后台代码protected void Button1_Click(object sender, EventArgs e)

{

SqlConnection conn = new

SqlConnection(ConfigurationManager.ConnectionStrings["connection"] .ConnectionString) ;conn.Open() ;string sql = "select * from市";if (TextBox1.Text != "")

{sql = "select * from市where市名称like '%" + TextBox1.Text + "%' ";

SqlCommand com = new SqlCommand(sql, conn) ;

SqlDataReader sdr = com.ExecuteReader() ;

GridView1.DataSource = sdr;

GridView1.DataBind() ;conn.Close() ;

}

}