---
title: "using extjs Create Login page and add,edit,update record from database."
description: "first I have create a UserLogin TableCREATETABLE[dbo][UserLogin][UserId][int]IDENTITY11PRIMARYKEY[UserName][varchar]100NULL,[UserEmail][varchar]100NU"
author: "Anonymous User"
published: 2016-10-04
updated: 2016-10-04
canonical: https://www.mindstick.com/blog/11213/using-extjs-create-login-page-and-add-edit-update-record-from-database
category: "sencha cmd"
tags: ["sencha"]
reading_time: 7 minutes
---
# using extjs Create Login page and add,edit,update record from database.
first I have create a UserLogin Table
```
CREATE TABLE [dbo].[UserLogin]( [UserId] [int] IDENTITY(1,1) PRIMARY KEY, [UserName] [varchar](100) NULL, [UserEmail][varchar](100) NULL, [PhoneNumber][varchar](100) NULL, [Address] [varchar](100) NULL, [Password] [varchar](100) NULL, )
```
Create a [layout View](https://www.mindstick.com/forum/155794/how-to-create-layout-view-in-asp-dot-net-mvc-razor-view) layout.cshtml
```
LAYOUT.Cshtml
@ViewBag.Title
@RenderBody()
```
\
Create a index view where user can login and go to **[Dashboard](https://answers.mindstick.com/qa/34007/reports-and-dashboard-limitations-in-salesforce).**
```
Index.cshtml
@{
Layout = null;
}
Index
```
\
It is user.js file which work for user login page.
```
Login.js
/// Users { get; set; }
public int TotalCount { get; set; }
}
public ModelList Get(int start, int limit, string sort)
{
ModelList result = new ModelList();
var data = db.UserLogin.AsQueryable();
result.Users = data.OrderBy(x => x.UserName).Skip(start).Take(limit).ToList();
result.TotalCount = data.Count();
return result;
}
```
**This is dashboard user list output.**
```
```
**This is add new user form output.**
```
```
This is edit user form Output.
```
```
This [method](https://www.mindstick.com/forum/166/webservice-method) use for add,update user.
```
public void Post(UserLogin obj)
{
var original = db.UserLogin.Find(obj.UserId);
if (original != null)
{
original.UserName = obj.UserName;
original.UserEmail = obj.UserEmail;
original.PhoneNumber = obj.PhoneNumber;
original.Password = obj.Password;
original.Address = obj.Address;
}
else
{
db.UserLogin.Add(obj);
}
db.SaveChanges();
}
```
This method use for delete user.d\
```
public void Delete(int id)
{
var original = db.UserLogin.Find(id);
if (original != null)
{
db.UserLogin.Remove(original);
}
db.SaveChanges();
}
```
Thanks.\
\
\
---
Original Source: https://www.mindstick.com/blog/11213/using-extjs-create-login-page-and-add-edit-update-record-from-database
Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.