protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=20110524-1702;Initial Catalog=compare;Integrated Security=True";
if (conn.State == ConnectionState.Closed)
conn.Open();
string str = "select iname 姓名,iage 年龄,isex 性别 ,ibrithday 出生日期,ibumen 部门,iphone 联系方式 ,ieducation 学历 from infocation where iname='" + this.TextBox1.Text.ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(str,conn);
DataSet ds = new DataSet();
da.Fill(ds,"123");
this.GridView1.DataSource=ds.Tables["123"];
this.GridView1.DataBind();
if (conn.State == ConnectionState.Open)
conn.Close();
Response.Write("<script language='javascript'> alert('查询成功!!')</script>");
TextBox1.Text = " ";
}