Search.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls; 
using System.Data.SqlClient;
using System.Data;
using ClassLibrary2;
public partial class Search : System.Web.UI.Page
{
    string str = System.Configuration.ConfigurationManager.AppSettings["str_con"].ToString(); //连接数据库
    SqlConnection con = null;
    SqlCommand cmd = null;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack) {
            bind();
        }
    }
    public void bind()
    {
        con = new SqlConnection(str);
        string sql = "SELECT * FROM [dbo].[英雄信息表] WHERE 英雄名称 like '%"+Value.type+"%'";
        con.Open();
        SqlDataAdapter dr = new SqlDataAdapter(sql, con);
        DataSet ds = new DataSet();
        dr.Fill(ds);
        DataList1.DataSource = ds;
        DataList1.DataBind();
        con.Close();
    }
}