How to Perform crud in asp.net mvc
Microsoft Net Framework

  How to Perform crud in asp.net mvc


1) open the visual studio and sql Server

2) frist you can make the database in Sql Server in the name of ContractManagement and make the table in the name of Contract
 and add the Columns in the of (ContractID,Name,Email,Phone and Gender) and save the table in the of Contracts
3) open the visual studio you can select the new project.you can see the project file and you can click the web option in the
Asp.net Web Application(.net Framework) and you can select and tick the Mvc File and the project will be created in automatically 

4) you can make the Folder in the name of Database 

5)right click database folder and select add option and then click new item and go to data option and click in the name
of (ADO.NET Entity Data Model) and given the name in Model as well.

6) Open the next page and choose the Model Content which is (EF Designer from database) and click next.

7) select the new connection which is given server name of the Sql Server name and paste the server name in the new connection login
in the server option and select the Sql Server Authentication and which you have the username and password of sql server
and seclect the database name in which correct database and click ok

8) clickm the yes option and then press next

9) in the next page entity framework 6.x and click the next page then choice the table option and click the finish  

10) click the controller and add the new controller and open the new window and select the (Mvc 5 Controller with read/write actions) 
click the add. open the new window and name the controller.

11)Add the project name in Libraries

12)Add the database name in Controller class

13) make the variable for list.in the index class in the from is 
    Public ActionResult Index()
   {
      var list=db.Contact.ToList();
      return view(list);
   }
 and click the view and add the view class and run the Browser

14) you have add the create class in the from of
   public ActionResult Create(Contact model)
   {
    try
     {
       //TODO:Add insert logic here
          db.contacts.Add(model);
          db.savechanges();
          return RedirectToAction("Index");
      }
    catch
       {
          return view();
        }

 you have click view and add the view class and run in brower

15)you have add the edit class in the form of
 public ActionResult Edit (int id) 
{
 Contact model=new Contact();
 if(id>0)
{
  model=db.contacts.find(id);
}
return View(model);
}

[HTTPPost]
Public ActionResult Edit(int id,Contact model)
{
 try
 {
  if (model.ContactID>0)
  {
   db.Entry(model).State = System.Data.Entity.EntityState.Modified;
                    db.SaveChanges();
                  }
                return RedirectToAction("Index");
            }
            catch
            {
                return View();
            }
        }
you have click the return view and add of the add

16)you have delete the data you write have in get method
   // GET: Management/Delete/5
        public ActionResult Delete(int id)
        {
            var model = db.Contacts.FirstOrDefault(o => o.ContactID == id);
            db.Contacts.Remove(model);
            db.SaveChanges();
            return View();
        }        
         add create the view.
 

Share This with your friend by choosing any social account


Upcoming Articles
You may also read following recent Post
Copyright Future Minutes © 2015- 2024 All Rights Reserved.   Terms of Service  |   Privacy Policy |  Contact US|  Pages|  Whats new?
Update on: Dec 20 2023 05:10 PM