How to bind data from database to table, getting error..

am getting error when am binding data to table from database

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

Additional information: Value cannot be null or empty.

my controller

var data = new List();

TestDemoEntities db = new TestDemoEntities();

data = db.Accounting_PendingBills.Where(x=>x.Party=="86").ToList();

return View(data);

view page

@model IEnumerable

@using System.Web.Mvc;

@using AccountsPageLayout.Models;

ViewBag.Title = "pendings";

Layout = null;

}

@foreach (AccountsPageLayout.Accounting_PendingBills emp in @Model)

{

Customer	Amount	Pendings	Pending Value	Pending Adjusted	Account Name
@Html.TextBox("", emp.Amount)	@Html.TextBox("", emp.Amount)	@Html.TextBox("", emp.Amount)	@Html.TextBox("", emp.Amount)	@Html.TextBox("", emp.Amount)	} 7 Replies Know the answer? Post it — somebody with the same question will find it here. Sign in to answer this question It is the same account you read, post and publish with — and you will come straight back to this page. Sign in Create an account Vinay Singh10y ago If you are not getting any value then check weather you have passed the model value properly from controller to view or not. have a look of the below link this link is an example to pass the list value to view in mvc http://www.aspdotnet-pools.com/2016/03/multiselect-dropdownlist-using-jquery.html Nitin Sontakke10y ago May be nothing to with your issue, but just happen to observe that the tr in the for each is not properly closed. Let me give you a hint: It looks like, some values are coming NULL in the result set and that is what is causing a problem, so you should look into fixing that. suman goud10y ago hi vinay singh, i used that but not displaying any values Vinay Singh10y ago I think your problem is with the model used in view. use your mode as shown below @model AccountsPageLayout.Accounting_PendingBills Nitin Sontakke10y ago Unfortunately, not quite sure how EF works, but there must be a flag / property to handle nulls there. suman goud10y ago am not using stored procedure here , am binding data from table by using entity framework Nitin Sontakke10y ago Precisely how you are getting data is not clear here. However, if you are using stored procedure, execute it in Query Analyzer and make sure none of the columns is having null. If it does, modify the select statement in stored procedure itself to include ISNULL and give appropriate alternate values (0 in case of number empty string in case of text, etc.) to the NULL.