using (SqlConnection sqlconn = new SqlConnection("data source=.; initial catalog=Northwind; uid=sa;pwd="))
{
sqlconn.Open();
SqlCommand cmd = sqlconn.CreateCommand();
cmd.CommandText = " select CompanyName, OrderDate,OrderID from Customers,Orders where Customers.CustomerID=Orders.CustomerID and CompanyName like '%"+name+"%'";
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
GridView1.DataSource = dt;
GridView1.DataBind();
}