I want to show sql table data in partial view of index

Nagma Khan

9y1k

to show data in partial view

I have created a Partial view on index

here is the index method

public ActionResult Index()

{

Big5OnlinePortalEntities db = new Big5OnlinePortalEntities();

var data = db.ExpoRegistrations.ToList();

return View(data);

}

here is the partial view

@model IEnumerable

Layout = null;

}

Index

@foreach (var ExpoRegistration in Model)

{

}

ID	Email Id	User Name	Password	EditionName
@ExpoRegistration.Id	@ExpoRegistration.EmailId	@ExpoRegistration.UserName	@ExpoRegistration.Password	@ExpoRegistration.EditionName

now it is showing error 'System.Data.Entity.Core.EntityException'

The underlying provider failed on Open.
can anyone help I am new to MVC

2 Replies

Know the answer? Post it — somebody with the same question will find it here.