Gamez Loverz

Complete tutorial on how to Delete data from SQL Server 2012 Using ASP + MVC 5 + Angualar.Js and CSharp 2015 HomeController.cs public JsonResult DeleteInfo(int id) { using (SqlConnection con = new SqlConnection(SqlConnectionString)) { con.Open(); string sql_Delete = "delete from ASP_Angular_MVC where id='" + id + "'"; SqlCommand cmd = new SqlCommand(sql_Delete, con); cmd.ExecuteNonQuery(); con.Close(); } return Json(id); } Tutorial App.js var app = angular.module("SearchApp", []); app.controller("SearchController", function ($scope, $http, $location) { $scope.Delete = function (SID) { if (confirm("Are you sure want to delete?")) { var httpreq = { method: 'POST', url: '/Home/DeleteInfo', headers: { 'Content-Type': 'application/json; charset=utf-8', 'dataType': 'json' }, data: { id: SID } } $http(httpreq).success(function (response) { $scope.Infofill(); alert("Deleted successfully."); }) } }; }); Index.cshtml Delete

This is Complete tutorial on how to get data from SQL Server 2012 Using ASP + MVC 5 + Angualar.Js and Visual Studio C# HomeController.cs public JsonResult GetInfoList() { List Entity = new List(); DataSet ds = new DataSet(); using (SqlConnection con = new SqlConnection(SqlConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "select Id,Name,Age,Phone from ASP_Angular_MVC"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } } } if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables.Rows) Entity.Add(new ModelInfo(int.Parse(dr.ToString()), dr.ToString(), dr.ToString(), dr.ToString())); } return Json(Entity); } Tutorial App.js var app = angular.module("SearchApp", []); app.controller("SearchController", function ($scope, $http, $location) { $scope.Infofill = function () { var httpreq = { method: 'POST', url: '/Home/GetInfoList', headers: { 'Content-Type':

This is Complete tutorial on how to insert data in SQL Server Using ASP + MVC + Angualar.Js and Visual Studio 2015 HomeController.cs Code using System.Web.Mvc; using System.Data.SqlClient; using System.Data; using System.Linq; using System.Configuration; using System.Web.Services; using System.Web.Script.Services; using System.Web.UI.WebControls; namespace ASP_MVC_Angular.Controllers { public class HomeController : Controller { public ActionResult Index() { return View(); } const string SqlConnectionString = @"Data Source=Your Server Name;initial catalog=Your Database Name;integrated security=true;"; public JsonResult Addinfo(string Name, string Age, string Phone) { using (SqlConnection con = new SqlConnection(SqlConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "insert into ASP_Angular_MVC (Name,Age,Phone) VALUES (@Name,@Age,@Phone)"; cmd.Parameters.AddWithValue("@name", Name); cmd.Parameters.AddWithValue("@Age", Age); cmd