need some help

[nclauder]

Hi there,
I'm wondering if I was on a write truck, could you please tell me?
I have a Button, textbox and a datagrid that updates. the datagrid is ok, but now I'm trying to get the user put an id number in the textbox and by the click of the button it selects immediatly the corresponding id number in the data grid.
this is the code I'm using:


private void bttok_click(object sender, System.EventArgs e)
{
con.Open();
try
{
using (SqlCommand myCommand = new SqlCommand("select * from employee where @ID="+txtname.Text,con))
{
SqlParameter myparam = new SqlParameter("@ID",SqlDbType.Text);
myparam.Value=ID;
myCommand.Parameters.Add(myparam);
using (SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand))
{
DataSet ds = new DataSet();
myAdapter.Fill(ds);
dgupdate.DataSource=ds;
dgupdate.DataBind();
}
}
catch(Exception err)
{
Console.WriteLine(err.Message);
}
finally
{
con.Close();
}

}