GridView in MVC 2 in Asp.Net

Pankaj Pandey
11y
18.2k
0
0

Blog

Step 1: Create a Project with MVC 2

Step 2: Go to Models Folder and add a Class with TestModels.cs name and write the below code.

using System;

using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.Globalization;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Security;
using System.Data.SqlClient;
using System.Data;

namespace MVCTEST1.Models

{
    public class LogOnModel
    {
        string ConnString = @"server=IT-WSPC-F10\SQL;Initial Catalog=pankaj;User Id=sa;Password=abc@123";
        DataSet ds;
        [Required]
        [DisplayName("User name")]
        public string UserName { get; set; }
        [Required]
        [DataType(DataType.Password)]
        [DisplayName("Password")]
        public string Password { get; set; }
        [Required]
        [DisplayName("Email")]
        public string Email { get; set; }
        public DataTable GetGridData()
        {
            try
            {
                ds = new DataSet();
                SqlConnection con = new SqlConnection(ConnString);
                SqlDataAdapter ada = new SqlDataAdapter("select * from User_Login", ConnString);
                ada.Fill(ds);
                return ds.Tables[0];
            }
            catch (Exception err)
            {
                throw err;
            }
        }
    }
}

Step 3: Go to Controller Folder and add a new controller class with TestController.cs name
and write the below code.

public ActionResult About()

{
DataTable dtGrid = new DataTable();
LogOnModel objGrid = new LogOnModel();
dtGrid = objGrid.GetGridData();
List<LogOnModel> Gridd = new List<LogOnModel>();
foreach (DataRow dr in dtGrid.Rows)
{
LogOnModel users = new LogOnModel();
users.UserName = dr["UserName"].ToString();

users.Email = dr["User_Pass"].ToString();

users.Email = dr["City"].ToString();
Gridd.Add(users);
}
return View("About", Gridd);
}

Step 4: Go to view folder and add a view named About.aspx and write the below code.

<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<IEnumerable<MVCTEST1.Models.LogOnModel>>" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head id="Head1" runat="server">
    <title>About</title>
</head>
<body>
    <div>
        <p>
            <%: ViewData["Message"] %>
        </p>
    </div>
    <div>
        <table width="50%">
            <tr>
                <td width="10%" height="30px">
                    ID
                </td>
                <td width="20%">
                    User Name
                </td>
                <td width="10%">
                    Age
                </td>
                <td width="10%">
                    Gender
                </td>
            </tr>
            <%foreach (var item in Model)
              { %>
            <tr>
                <td>
                    No Data
                </td>
                <td>
                    <%=Html.DisplayFor(x => item.UserName)%>
                </td>
                <td>
                    No Data
                </td>
                <td>
                    <%=Html.DisplayFor(x => item.Password)%>
                </td>
                <td>
                    <%=Html.DisplayFor(x => item.Email)%>
                </td>
            </tr>
            <%} %>
        </table>
    </div>
</body>
</html>

And run application. You can put your table as your requirement