Displaying data from aspnet.db

Question

After quite some time spent trying to configure web.config i finally done it just to get the following error :

An exception of type 'System.InvalidOperationException' occurred in System.Web.dll but was not handled in user code

Additional information: Data source is an invalid type.  It must be either an IListSource, IEnumerable, or IDataSource.

I am trying to connect to aspnet.db (i think i did it because i have no connection error , i copy pasted it from the normal web.config that the aplication provides you with) This is the web.config:

This is the page where i am trying to display the users from AspNetUsers(which the aplication very kindly creates for you so that the log in functionality works):

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="ManageUsers.aspx.cs" Inherits="SiteStiri.Administration.ManageUsers" %>


    
          
             

              

          
        |

Last but not least this is the code behind the page that should feed the GridView with data :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Security;
using Owin;
using SiteStiri.Models;
using Microsoft.AspNet.Identity;
using Microsoft.AspNet.Identity.Owin;

namespace SiteStiri.Administration
{
    public partial class ManageUsers : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                BindUserAccounts();

            }
        }
        private void BindUserAccounts()
        {
            UserAccounts.DataSource = Context.GetOwinContext().GetUserManager();
            UserAccounts.DataBind();
        }

        private void BindFilteringUI() { 
            string[] filterOptions = { "All", "A", "B", "C", "D", "E", "F", "G", "H",
                                         "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z" };
            FilteringUI.DataSource = filterOptions; 
            FilteringUI.DataBind();
        }
    }
}

What am i doing wrong ? I mean the guys at msd , in their tutorial can display the data this way :( .

Thank you in advance for trying to help me.

Andrei · Accepted Answer

This line:

UserAccounts.DataSource = Context.GetOwinContext().GetUserManager();

is the source of the problem. As per error message, DataSource expects something it can iterate over, extract individual values and bind the to the grid. Or it could be something that implements IDataSource. GridView cannot guess which method should it call from the manager object you are giving it.

So essentially data binding here should look like this:

var manager = Context.GetOwinContext().GetUserManager();
UserAccounts.DataSource = manager.GetUserList(); // Just a made up method, use what you need here
UserAccounts.DataBind();

Displaying data from aspnet.db

Answers (1)

Related Questions