retrive the data from database using like function

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("select * from [sales] where fullname like @p1 ", con);


cmd.Parameters.AddWithValue("@p1",string.Concat(TextBox1.Text,"%"));

cmd.CommandType = CommandType.Text;

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

GridView1.DataSource = ds.Tables[0]; ;
GridView1.DataBind();
*note[db connection=Data Source=your server name;Integrated Security=true;Initial Catalog=your database name]