Question

TEXTBOX1搜索 gridview 显示 gridview SqlDataSource绑定的

protected void Button1_Click(object sender, EventArgs e)
{
this.BindGrid();
}
private void BindGrid()
{
string sql = "SELECT EMPID,EMPName,EMPSEX,EMPbirth,Department,Position,Degree,Part,CTCTY,Professional FROM [EMPBaseInfo] WHERE [EMPID]='" + TextBox1.Text + "'";
GridView1.DataSource = ReturnDataTable(sql);
GridView1.DataBind();
}
public static DataTable ReturnDataTable(string cmdtext)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = ConfigurationManager.ConnectionStrings["ETHANConnectionString"].ConnectionString;
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd = new SqlCommand(cmdtext, cn);
cmd.CommandType = CommandType.Text; ;
SqlDataReader dr = null;
using (dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(dr);
}
return dt;
}

Answer 1

将 Page_Load改一下
protected void Page_Load(object sender, EventArgs e)
{ if (!Page.IsPostBack)
{
GridView1.Visible = false;
}
}
试一下吧

Answer 2

[EMPID]='" + TextBox1.Text + "'";
搜索一般用like 不是用=