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