problem in using linq

See more:

C#3.0

C#

MySQL

plz help...
I need to make conditional search from a filled data set using linq and need to display it in a grid...
Here s my code

MySqlConnection db = new MySqlConnection("Database=loyaltycard;Data Source=localhost;User Id=root;Password=root");
db.Open();
MySqlDataAdapter da = new MySqlDataAdapter();
MySqlCommand c = new MySqlCommand("select SupplierId,SupplierCode,CompanyId,SurName from supplier", db);
da.SelectCommand = c;
DataSet ds = new DataSet();
da.Fill(ds);

var products = from p in ds.Tables[0].AsEnumerable() where p.Field<string>("SupplierCode").ToString() == "12" select p;
GridView1.DataSource = products.ToList();
GridView1.DataBind();
db.Close();
---------------------------------
I cant get the data from linq query and bind it 2 grid...someone please guide me.......