Get Only Single Value Error

6y695Learn iOS Programming

It's me c# code . I have get value from database using this code.Run this code but view only one record.

public IActionResult UserManagement()

{

UserViewModel obj = new UserViewModel();

List lst = new List();

try

{

var Result = _context.UserProfileMaster.ToList();

if (Result.Count > 0)

{

foreach (var item in Result)

{

obj.FullName = item.FirstName + " " + item.LastName;

obj.DOB = Convert.ToDateTime(item.Dob);

var Mob = item.MobileNumber;

obj.MobileNumber = String.Format("{0:+##-##########}", double.Parse(Mob));

obj.Country = item.Country;

obj.UserImage = item.UserImage;

}

else

{

ViewBag.message = "No Record !";

}

catch (Exception ex)

{

ViewBag.message = "Internal Server Error";

var message = ex.InnerException.Message;

throw;

}

return View(new List { obj });

}

It's me view code.

@foreach (var item in Model)

{

1.@*

@Html.DisplayFor(x => item.FullName)

@Html.DisplayFor(x => item.DOB)

@Html.DisplayFor(x => item.MobileNumber)

@Html.DisplayFor(x => item.Country)

View Detail

check this

4 Replies

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

Jenith Thakkar6y ago
Accepted answer
Replace your foreach with this

foreach (var item in Result)
{
obj = new UserViewModel();
obj.FullName = item.FirstName + " " + item.LastName;
obj.DOB = Convert.ToDateTime(item.Dob);
var Mob = item.MobileNumber;
obj.MobileNumber = String.Format("{0:+##-##########}", double.Parse(Mob));
obj.Country = item.Country;
obj.UserImage = item.UserImage;
lst.Add(obj);
}
}
Jenith Thakkar6y ago
Saurabh It shows single record because you're initializing object outside of foreach loop

so it's overight value everytime

That's why you have to do something like

foreach (var item in Result)
{
obj = new UserViewModel();
obj.FullName = item.FirstName + " " + item.LastName;
obj.DOB = Convert.ToDateTime(item.Dob);
var Mob = item.MobileNumber;
obj.MobileNumber = String.Format("{0:+##-##########}", double.Parse(Mob));
obj.Country = item.Country;
obj.UserImage = item.UserImage;
lst.Add(obj);
}
6y ago
Thanks @Jenith
Jignesh Kumar6y ago
Hi ,

Please add you values to list and return that list,
public IActionResult UserManagement()
{
UserViewModel obj = new UserViewModel();
List lst = new List();
try
{
var Result = _context.UserProfileMaster.ToList();
if (Result.Count > 0)
{
foreach (var item in Result)
{
obj.FullName = item.FirstName + " " + item.LastName;
obj.DOB = Convert.ToDateTime(item.Dob);
var Mob = item.MobileNumber;
obj.MobileNumber = String.Format("{0:+##-##########}", double.Parse(Mob));
obj.Country = item.Country;
obj.UserImage = item.UserImage;
lst.Add(obj);
}
}
else
{
ViewBag.message = "No Record !";
}
}
catch (Exception ex)
{
ViewBag.message = "Internal Server Error";
var message = ex.InnerException.Message;
throw;
}
return View(lst);
}