Bind Gridview with value selected from textbox in autocomplete

See more:

ASP.NET

SQL

Ajax

Hi,
I am working on a Autocomplete textbox which works fine, from
http://www.aspsnippets.com/Articles/Populate-jQuery-AutoComplete-TextBox-from-Database-using-Web-Service-in-ASPNet.aspx[^]

When the user selects any value like Kiran then it should show the result in gridview with Kiran details.The code that I have used is not working,gow do i achieve this:

protected void txtSearch_TextChanged(object sender, EventArgs e)
    {
        
        string cn=ConfigurationManager.ConnectionStrings["testing"].ConnectionString;
        using(SqlConnection connection = new SqlConnection(cn))
        {    
            
           
            SqlCommand command = new SqlCommand("select * from country where EmployeeName=@EmployeeName", connection);
            command.Parameters.AddWithValue("@EmployeeName", txtSearch);
	    connection.Open();
            SqlDataReader dr = command.ExecuteReader();
            GridView1.DataSource = dr;
            GridView1.DataBind();
        }

Data Base is

insert into Country values (1,'India','Kiran')
insert into Country values (2,'India','Karan')