void Load_GridData()
{
string CustomerId = (string)(Session["clientID"]);
double custid = double.Parse(CustomerId.ToString());
SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["dbaseconnection"].ConnectionString);
SqlCommand command = new SqlCommand("SELECT * FROM OrderFacts_StoredDatas WHERE Cust_Num = '" + double.Parse(custid.ToString()) + "'", conn);
SqlDataAdapter daimages = new SqlDataAdapter(command);
DataTable dt = new DataTable();
daimages.Fill(dt);
GridImageRetrieve.DataSource = dt;
GridImageRetrieve.DataBind();
GridImageRetrieve.Attributes.Add("bordercolor", "black");
}
void Load_GridData()
{
double prods = 0;
string productID = (string)(Session["ProductNum"]);
prods = double.Parse(productID.ToString());
//GridView GridImageRetrieve = Article2.ContentPlaceholder.Controls[0].FindControl("GridImageRetrieve") as GridView;
SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["dbaseconnection"].ConnectionString);
SqlCommand command = new SqlCommand("SELECT * FROM PRODUCT WHERE Product_Num = '" + double.Parse(prods.ToString()) + "'", conn);
SqlDataAdapter daimages = new SqlDataAdapter(command);
DataTable dt = new DataTable();
daimages.Fill(dt);
GridImageRetrieve.DataSource = dt;
GridImageRetrieve.DataBind();
GridImageRetrieve.Attributes.Add("bordercolor", "black");
}
void Load_GridData()
{
string GenderCategory = (string)(Session["GeneralCategoryGenders"]);
string CollectionsCategory = (string)(Session["CollectionsCat"]);
string TypesCategory = (string)(Session["CategoryNum"]);
_GenderCategory = double.Parse(GenderCategory.ToString());
_CollectionsCategory = double.Parse(CollectionsCategory.ToString());
_TypesCategory = double.Parse(TypesCategory.ToString());
SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["dbaseconnection"].ConnectionString);
SqlCommand command = new SqlCommand("SELECT PRODUCT.Product_Num, PRODUCT.Product_Name, PRODUCT.Product_UpdatedDescription, PRODUCT.Product_UpdatedPrice, PRODUCT.Product_Status, PRODUCT.Product_Image FROM CATEGORY INNER JOIN PRODUCT ON CATEGORY.Category_Num = PRODUCT.Category_Num INNER JOIN COLLECTIONCATEGORY ON PRODUCT.Collection_Num = COLLECTIONCATEGORY.Collection_Num INNER JOIN GENDERCATEGORY ON PRODUCT.GenderCategory_Num = GENDERCATEGORY.GenderCategory_Num WHERE PRODUCT.GenderCategory_Num = '" + double.Parse(_GenderCategory.ToString()) + "'AND PRODUCT.Collection_Num = '" + double.Parse(_CollectionsCategory.ToString()) + "' AND CATEGORY.Category_Num = '" + double.Parse(_TypesCategory.ToString()) + "'", conn);
SqlDataAdapter daimages = new SqlDataAdapter(command);
DataTable dt = new DataTable();
daimages.Fill(dt);
GridImageRetrieve.DataSource = dt;
GridImageRetrieve.DataBind();
GridImageRetrieve.Attributes.Add("bordercolor", "black");
}
