gridview not showing values via BLL?

Question

My control doesnt return the values in my gridview.

table adapter runs the query fine and displays the data.

Here is my code from the control:

 categoriesBLL categoriesLogic = new categoriesBLL();
 GridView1.DataSource = categoriesLogic.GetCategories();
 GridView1.DataBind();

and here is my BLL:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using NopSolutions.NopCommerce.Nop.DataAccess.MegaProductMenuTableAdapters;

namespace NopSolutions.NopCommerce.BusinessLogic.MegaProductsMenu
{
    [System.ComponentModel.DataObject]
    public class categoriesBLL
    {

        private Nop_CategoryTableAdapter _categoriesAdapter = null;
        protected Nop_CategoryTableAdapter Adapter
        {
            get
            {
                if (_categoriesAdapter == null)
                    _categoriesAdapter = new Nop_CategoryTableAdapter();

                return _categoriesAdapter;
            }
        }



        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public Nop_CategoryTableAdapter GetCategories()
        {
            return _categoriesAdapter;
        }


    }

}

My DAL looks like this:

enter image description here

If connect directly to the DAL I can get the values to show up. So i think there is something wrong with my BLL, but what could it be? I receive no error messages.

My gridview source:

    <asp:GridView ID="GridView1" runat="server" CssClass="DataWebControlStyle" AutoGenerateColumns="True">
       <HeaderStyle CssClass="HeaderStyle" />
       <AlternatingRowStyle CssClass="AlternatingRowStyle" />
    </asp:GridView>

show your gridview code (source). – Idrees Khan Jul 08 '12 at 13:26 — Idrees Khan, Jul 08 '12 at 13:26
@DigitalAssets: added the source. – SOLDIER-OF-FORTUNE Jul 08 '12 at 13:28 — SOLDIER-OF-FORTUNE, Jul 08 '12 at 13:28

score 1 · Answer 1 · answered Jul 08 '12 at 13:23

1

Do you have any columns defined? or is AutoGenerateColumns == true

answered Jul 08 '12 at 13:23

Amiram Korach

13,056
3
28
30

AutoGenerateColumns is set to true. Shall i change it to false?? – SOLDIER-OF-FORTUNE Jul 08 '12 at 13:24
No. Now I see that you assign the DataAdapter as a data source. You need to assign a DataTable or a DataView. – Amiram Korach Jul 08 '12 at 13:26
changing it to false made no difference. – SOLDIER-OF-FORTUNE Jul 08 '12 at 13:26

score 1 · Answer 2 · answered Jul 08 '12 at 13:34

1

categoriesBLL categoriesLogic = new categoriesBLL();
GridView1.DataSource = categoriesLogic.GetCategories();
GridView1.DataBind();

Change the line 2 to the following

GridView1.DataSource = categoriesLogic.Adapter.GetCategories();

answered Jul 08 '12 at 13:34

Ehsan Aleem Avee

231
1
4

this doesn't solve it. I get: **'NopSolutions.NopCommerce.BusinessLogic.MegaProductsMenu.categoriesBLL.Adapter' is inaccessible due to its protection level** – SOLDIER-OF-FORTUNE Jul 08 '12 at 13:46
then when i change `private Nop_CategoryTableAdapter _categoriesAdapter = null;` to public and do what you said, i still get no values showing. – SOLDIER-OF-FORTUNE Jul 08 '12 at 13:47
Please check weather calling Fill() instead of GetCategories() works or not? And set the AutoGenerateColumns to true. – Ehsan Aleem Avee Jul 08 '12 at 13:52
It doesnt allow me to do fill – SOLDIER-OF-FORTUNE Jul 08 '12 at 13:56
OR you can do the following [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)] public Nop_Category GetCategories() { return Adapter.GetCategories(); } – Ehsan Aleem Avee Jul 08 '12 at 13:59
**Cannot implicitly convert type 'NopSolutions.NopCommerce.Nop.DataAccess.MegaProductMenu.Nop_CategoryDataTable' to 'NopSolutions.NopCommerce.Nop.DataAccess.MegaProductMenuTableAdapters.Nop_CategoryTableAdapter'** – SOLDIER-OF-FORTUNE Jul 08 '12 at 14:02

score 0 · Accepted Answer · answered Jul 08 '12 at 14:25

I solved this by asigning the datatable:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using NopSolutions.NopCommerce.Nop.DataAccess.MegaProductMenuTableAdapters;

namespace NopSolutions.NopCommerce.BusinessLogic.MegaProductsMenu
{
    [System.ComponentModel.DataObject]
    public class categoriesBLL
    {

        private Nop_CategoryTableAdapter _categoriesAdapter = null;
        protected Nop_CategoryTableAdapter Adapter
        {
            get
            {
                if (_categoriesAdapter == null)
                    _categoriesAdapter = new Nop_CategoryTableAdapter();

                return _categoriesAdapter;
            }
        }

        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public NopCommerce.Nop.DataAccess.MegaProductMenu.Nop_CategoryDataTable GetCategories()
        {
            return Adapter.GetCategories();
        }

    }

}

gridview not showing values via BLL?

3 Answers3