private void LoadCarouselRepeater()
    {
        clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp();

        // dont write db_name.dbo.viewname, it doesn't work in my sq. 1 is hardcode for gate which is fixed

        DataTable dtProduct = ObjDAL.ExecuteSelectStatement("SELECT Path FROM ztech.tblImages WHERE ProductID=4 AND flag=0");

        if (dtProduct != null && dtProduct.Rows.Count > 0)
        {
            CarouselRepeater.DataSource = dtProduct;
            CarouselRepeater.DataBind();
        }
    }
Example #2
0
    private void LoadCarouselRepeater()
    {
        clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp();

        // dont write db_name.dbo.viewname,  hardcode for gate which is fixed

        DataTable dtProduct = ObjDAL.ExecuteSelectStatement("select * from View_MainSliderDetails");

        if (dtProduct.Rows.Count > 0)
        {
            CarouselRepeater.DataSource = dtProduct;
            CarouselRepeater.DataBind();
        }
    }