01.string strConn = WebConfigurationManager.ConnectionStrings["testConnectionString2"].ConnectionString;
02. SqlConnection Conn = new SqlConnection(strConn);
03. Conn.Open();
04. string nam = "%"+search.Text+"%";
05. string sqlproduct = "SELECT* FROM empoy WHERE name LIKE @name";
06. SqlCommand com = new SqlCommand(sqlproduct,Conn);
07. SqlDataReader dr;
08. com.Parameters.Add("@name",SqlDbType.NVarChar).Value=nam;
09. dr = com.ExecuteReader();
10. if (dr.HasRows)
11. {
12. DataTable dt = new DataTable();
13. dt.Columns.Add("test");
14.
15. dt.Load(dr);
16. GridView1.DataSource = dt;
17. GridView1.DataBind();
18.
19.
20. }
21. dr.Close();
