Page.Title = "Log in";
if (IsPost && Validation.IsValid()) {
var email = Request.Form["email"];
var password = Request.Form["password"];
var db = Database.Open("studentcareer");
var result = db.QueryValue("SELECT Count(*) FROM Account WHERE Loginid = @0 AND Password = @1", email, password);
//var result = db.Query("SELECT * FROM Account WHERE Loginid = @0 AND Password = @1", email, password);
if (result > 0){
Session["a"]= Request.Form["email"];
Response.Redirect("~/HomePage22.cshtml");
}
}
}
<html>
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
<form name="login" action="" method="post" accept-charset="utf-8">
<table border="1">
<tr>
<td>
<label for="email">Email</label></td><td>
<input type="email" name="email" placeholder="[email protected]" required value = "@Request.Form["email"]"></td> </tr>
<tr> <td><label for="password">Password</label> </td>
<td> <input type="password" name="password" placeholder="Password" required> </td>
</tr>
<tr> <td> <a href="/PageRagistration.cshtml" target=" _blank"> New Ragistration</a> </td><td><input type="submit" value="Login"> </td></tr>
</table>
</form>
</body>
</html>
login page coding after coding open page
var db = Database.Open("studentcareer");
var selectQueryString = "SELECT * FROM webinfo where Loginid=@Session["a"].Tostring()"; ( how to Display Session store data only???)
}
@RenderPage("PageHeader.cshtml")
<!DOCTYPE html>
<html>
<head>
<title>Data information</title>
<style>
table, th, td {
border: solid 1px #bbbbbb;
border-collapse: collapse;
padding: 2px;
background: #f1f1f1;
}
</style>
</head>
<body>
<div class="Center ">
<h1>View your Data</h1>
<table>
<thead>
<tr>
<th>S.No.</th>
<th>Webpath</th>
<th>Login</th>
<th>Password</th>
<th>Remarks</th>
<th>Crdate</th>
<th>Examdate</th>
<th>LoginId</th>
<th>thought</th>
</tr>
</thead>
<tbody>
@foreach(var row in db.Query(selectQueryString))
{
<tr>
<td>@row.Sno</td>
<td>@row.Webpath</td>
<td>@row.Login</td>
<td>@row.Password</td>
<td>@row.Remarks</td>
<td>@row.Crdate</td>
<td>@row.Examdate</td>
<td>@row.LoginId</td>
<td>@row.thought</td>
</tr>
}
</tbody>
</table>
</div>
</body>
</html>
@RenderPage("PageFooter.cshtml")
Ananth GPosted Oct 21, 2016, 4:21 AM
Midhun TpPosted Oct 19, 2016, 7:38 AM