public void loadData(string part)
{
partslist.Clear();
SqlCommand com = new SqlCommand("select * from Products where type='" + part + "'", con);
con.Open();
SqlDataReader reader = com.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Product newproduct = new Product();
newproduct.id = (Int32)reader["productid"];
newproduct.name = reader["name"].ToString();
newproduct.imgurl = reader["imgurl"].ToString();
newproduct.type = reader["type"].ToString();
newproduct.defaultprice = (float)reader.GetDouble(4);
partslist.Add(newproduct);
}
}
PartsGridView.DataSource = partslist;
PartsGridView.DataBind();
con.Close();
}
