连接数据写在Web.Config 搜表users protected void Button3_Click( object sender, EventArgs e) ... { string constr = System.Configuration.ConfigurationManager.AppSettings["constr"]; SqlConnection con = new SqlConnection(constr); con.Open(); string str = this.TextBox1.Text.Trim(); SqlDataAdapter da = new SqlDataAdapter("select username,email,roleid from users where username like '%"+str+"%'", con); DataSet ds = new DataSet(); da.Fill(ds, "users"); this.GridView1.DataSource = ds.Tables[0]; this.GridView1.DataBind();}