Loading

How to display records in Rows in ASP.NET MVC5

How to display records in Rows in ASP.NET MVC5

Abraham Olatubosun

Abraham Olatubosun

8y4.3k.NET

Dear all,

Compliment of the season, I am prety new to ASP.NET MVC but when through some tutorials and i am able to get my fingers on it step by step.

I have some issue with the displaying my records in rows below is my code from the Index.cshtml

@model System.Data.DataTable
@{
ViewBag.Title = "Index";
}
class="table table-bordered table-striped table-responsive">
First Name
Last Name
Other Name
Email
Address
B Month
Martal Status
Member Status
Edit
Delete
@for (int i = 0; i < Model.Rows.Count; i++)
{
@Model.Rows[i][1]
@Model.Rows[i][2]
@Model.Rows[i][3]
@Model.Rows[i][4]
@Model.Rows[i][5]
@Model.Rows[i][6]
@Model.Rows[i][7]
@Model.Rows[i][8]
class="btn btn-primary" href="@Url.Action("Edit", "Member", new {@[email protected][i][0] })" >Edit
class="btn btn-danger" href="@Url.Action("Delete", "Member", new {@[email protected][i][0] })">Delete
}
"@Url.Action("Create","Member")" class="btn btn-sm btn-primary">Add Member
@*"my-button" onclick="location.href='@Url.Action("YourActionName", "YourControllerName")'">Submit*@

my Model code is as follows (I am not using Entity Frame work)

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace HIGHGROUNDMCV.Models
{
public class MembersModel
{
public int ID { get; set; }
[DisplayName("First Name")]
public string FName { get; set; }
[DisplayName("Last Name")]
public string LName { get; set; }
[DisplayName("Other Name")]
public string OName { get; set; }
public string Email { get; set; }
public string Address { get; set; }
[DisplayName("Month of Birth")]
public int MOB { get; set; }
[DisplayName("Marital Status")]
public string MStatus { get; set; }
[DisplayName("Member Status")]
public string MembStatus { get; set; }
}
}

then the result i am getting is as follows

I want the records to show in rows all show in a single row, please what am i doing wrong.

thank you for your help

4 Replies

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

Amit Kumar8y ago
Accepted answer
Hi,

Your problem is not complex it is very easy. You want to print the data row by row but in your screen shot data is printed in same for solve this problem use tag inside the for loop like. Keeping mind read my comments and use my below code
class="table table-bordered table-striped table-responsive">

First Name
Last Name
Other Name
Email
Address
B Month
Martal Status
Member Status

Edit


Delete


-----Remove it from here and use it inside for loop
@for (int i = 0; i < Model.Rows.Count; i++)
{
--use here
@Model.Rows[i][1]
@Model.Rows[i][2]
@Model.Rows[i][3]
@Model.Rows[i][4]
@Model.Rows[i][5]
@Model.Rows[i][6]
@Model.Rows[i][7]
@Model.Rows[i][8]
class="btn btn-primary" href="@Url.Action("Edit", "Member", new {@[email protected][i][0] })" >Edit
class="btn btn-danger" href="@Url.Action("Delete", "Member", new {@[email protected][i][0] })">Delete
---use here
}
---- Remove it from here and use it inside for loop

Amit Kumar

Amit Kumar8y ago

Thanks,

I have give designed code . you have to set only color. Paste it in html file and run it and set the color by your choice.

Setup For Composite Rates
Category :
Sub Category :

Description :	Unit : Price :
Batch file Upload :

Dharmraj Thakur8y ago
Please move your inside loop like this...
@foreach (DataRow item in Model.Rows)
{

        @Convert.ToString(item[1])
        @Convert.ToString(item[2])
        @Convert.ToString(item[3])
        @Convert.ToString(item[4])
        @Convert.ToString(item[5])
        @Convert.ToString(item[6])
        @Convert.ToString(item[7])
        @Convert.ToString(item[8])
        class="btn btn-primary" href="@Url.Action("Edit", "Member", new {@id=Convert.ToString(item[0]) })">Edit
        class="btn btn-danger" href="@Url.Action("Delete", "Member", new {@id=Convert.ToString(item[3]) })">Delete

}
Abraham Olatubosun8y ago
Many Thanks Amit Kumar it works fine.

I want to ask how is it posible to design my user interface so that i can have some label and textbox in one row of a table, just the way we design it on ASP.NET
Some thing like the one below:

Thank you once again