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.
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">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server"><title>About</title>
</head>
<body>
<div>
<table width="50%" border="1">
<tr>
<td width="10%" height="30px">
User ID
</td>
<td width="20%">
User Name
</td>
<td width="10%">
</td>
</tr>
<%foreach (var item in Model)
{ %>
<tr>
<td width="10%" height="30px">
<%=Html.DisplayFor(x => item.UserID)%>
</td>
<td width="20%">
<%=Html.DisplayFor(x => item.UserName)%>
</td>
<td>
<%=Html.DisplayFor(x => item.Email)%>
</td>
</tr>
<%} %>
</table>
</div>
</body>
</html>
No comments:
Post a Comment