Line 85: }
Line 86: cn.Close();
Line 87: if (ds.Tables[0].Rows[0]["image2_path"].ToString() == "" && ds.Tables[0].Rows[0]["image3_path"].ToString() == "" && ds.Tables[0].Rows[0]["image_path"].ToString() != "")
Line 88: {
Line 89: AccessDataSource2.SelectCommand = "SELECT C.category_name, S.subcategory_name, G.gallery_id, G.category_id, G.subcategory_id, G.image_path, G.image_title, G.design_price, G.image2_path, G.image3_path FROM (Category_mst AS C INNER JOIN SubCategory_mst AS S ON C.category_id = S.category_id) INNER JOIN Gallery_mst AS G ON (S.category_id = G.category_id) AND (S.subcategory_id = G.subcategory_id) where G.category_id=" + cid + " and G.subcategory_id=" + sid + " and G.gallery_id=" + gid + "";
|