Regarding data from table to a textbox.

Hi
this is my cose.my table is sign_up and i wanna get fetched the record of tht table in to textboxes.how can I do that


protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button2_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string query = ("select * from sign_up where emp_code='" + TextBox1.Text + "' ");
SqlConnection con = new SqlConnection("Data Source=192.168.87.229;Initial Catalog=test;User ID=sa;Persist Security Info=False");
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
con.Open();
adp.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}


protected void Button1_Click(object sender, EventArgs e)
{

}
protected void TextBox2_TextChanged(object sender, EventArgs e)
{

}