English 中文(简体)
ASP.NET Core 2 .1 - How to show all data in table
原标题:

I don t know how to put CustomerData into CustomerLists property. I m already using CustomerLists = CustomerData; but I got error:

CustomerLists is a type but is used like a variable

Can anyone explain this to me?

This is my code in Index.cshtml.cs:

namespace WebApplication1.Pages
{
    public class Pages : PageModel
    {
        public List<CustomerList> CustomerLists = new List<CustomerList>();

        private readonly ApplicationDbContext _conn;

        public Pages(ApplicationDbContext conn)
        {
            _conn = conn;
        }

        public int Message;

        public void OnGet()
        {
            var CustomerData = _conn.table_customer.ToList();
            //??
        }
    }

    public class CustomerList
    {
        public string CustomerId;
        public string Name;
        public string Address;
        public string MobileNo;
    }
}
最佳回答

As the error mentioned, you are assigning CustomerData to CustomerList which CustomerList is a type. It s incorrect.

You need:

CustomerLists = CustomerData;

But only when CustomerData is a List<CustomerList> type.

For casting CustomerData to List<CustomerList> type, work with Linq .Select().

using System.Linq;

public void OnGet()
{
    var CustomerData = _conn.tabel_customer.ToList();
    CustomerLists = CustomerData
        .Select(x => new CustomerList
        {
            // Assign property value
            CustomerId = x.CustomerId,
            ... // Remaining properties
        })
        .ToList();
}

Or you can straightway assign the CustomerLists value without the need for CustomerData variable.

using System.Linq;

public void OnGet()
{
    CustomerLists = _conn.tabel_customer
        .Select(x => new CustomerList
        {
            // Assign property value
            CustomerId = x.CustomerId,
            ... // Remaining properties
        })
        .ToList();
}

Change the fields to properties by providing getter and setter.

public class CustomerList
{
    public string CustomerId { get; set; }
    public string Name { get; set; }
    public string Address { get; set; }
    public string MobileNo { get; set; }
}
问题回答

暂无回答




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签