CustomerID

CustomerID

ProductName

ProductName

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();
 }

TransFormer

TransFormer

TransFormer

TransFormer

TransFormer

TransFormer

dddddd

dddddddd

ddddddddddd

ddddddddddd