Insertion using sql link query , jquery and ajax

In this articles of ASP.NET MVC we will learn about Insertion using sql linq query with jquery and ajax so let's get start.

Firstly make a connection with database and for connection,Open visual studio on the left hand side goto server explorer and make a connection on click this button:

After Click on this button you will find a dialogbox called Add Connection ,after appearing a dialogbox add a server name (to find a server name firstly open sql server management studio and when you open you will find a server name just copy server name and paste on Add Connection dialogbox under server name input field). In my case , my server name is NAVEED-PC.

After adding server name just click OK button ,then you will find a connection with your database at the left corner under server explorer.

After making connection , just right click on the connection which is marked with red colour and goto properties and once you clicked the properties option you will find its properties on the right hand corner so just copy the connection string

After done all this stuff then we will create controller so in my case i create a HomeController

HOME CONTROLLER:

public ActionResult AddPage()

{

ViewBag.userName = new SelectList(db.GEN_Users, "sysUserID", "Username");

return View();

}

public ActionResult AddRecord(int txtuserId, string txttaskDate, string txttaskAssignTo, string txttaskAssignFrom, string txttaskDescription,string imageUploading, string filenameVariable, string filetypeVariable)

{

var list = db.Database.SqlQuery<GEN_TaskMaster>("insert into GEN_TaskMaster(sysUserID,Task_Date,Task_Assign_To,Task_Assign_From,Task_Description)values('" + txtuserId + "','" + txttaskDate + "','" + txttaskAssignTo + "','" + txttaskAssignFrom + "','" + txttaskDescription + "')").ToList();

return Json("Successfully Inserted", JsonRequestBehavior.AllowGet);

}

Create a view called AddPage and write a code below:

}

<!DOCTYPE html>

<html>

<head>

<title>Add Record</title>

</head>

<body>

</div>

</div>

<div class="panel-title table-thead-text-size-changer text-center text-color-changer ">Add Record</div>

</div>

</div>

@Html.DropDownList("GEN_Users", (SelectList)ViewBag.userName, "Select One", new { @class = "form-control txtuserId", id = "txtuserId" })

</div>

<span>Task Assign To</span>

</div>

</div>

<span>Task Assign From</span>

</div>

</div>

<span>Task Description</span>

</div>

</div>

<span>File Upload</span>

</div>

</div>

</div>

</form>

</div>

$("#txttaskDate").datepicker();

$("#txttaskDate").datepicker("setDate", new Date());

var imageUploading = "";

var filenameVariable = "";

var filetypeVariable = "";

function encodeImageFileAsURL(element) {

var file = element.files[0];

filenameVariable = element.files[0].name;

filetypeVariable = element.files[0].type;

var reader = new FileReader();

reader.onloadend = function () {

imageUploading = reader.result;

var hiddenImage = $("#hiddenImage").val(imageUploading);

}

reader.readAsDataURL(file);

}

$("#submitBtn").click(function () {

var txtuserId = $("#txtuserId option:selected").val();

var txttaskDate = $("#txttaskDate").val();

var txttaskAssignTo = $("#txttaskAssignTo").val();

var txttaskAssignFrom = $("#txttaskAssignFrom").val();

var txttaskDescription = $("#txttaskDescription").val();

$.ajax({

url: "/Home/AddRecord",

type: "POST",

data: { txtuserId: txtuserId, txttaskDate: txttaskDate, txttaskAssignTo: txttaskAssignTo, txttaskAssignFrom: txttaskAssignFrom, txttaskDescription: txttaskDescription, imageUploading: imageUploading, filenameVariable: filenameVariable, filetypeVariable: filetypeVariable},

dataType:"JSON",

success: function (result) {

window.location.href = "/Home/Dashboard";

error: function (err) {

alert("Something went wrong");

}

});

$("#cancelBtn").click(function () {

window.location.href = "/Home/Dashboard";

});

</script>

</body>

</html>

I create a model called GEN_TaskMaster:

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.Linq;

using System.Web;

namespace Kassim.Models

{

public class GEN_TaskMaster

{

public long sysTaskID { get; set; }

public long sysUserID { get; set; }

public DateTime Task_Date { get; set; }

public string Task_Assign_To { get; set; }

public string Task_Assign_From { get; set; }

public string Task_Description { get; set; }

public string Username { get; set; }

public string Password { get; set; }

}

I have design my database you can take data field in database whatever you want.

Thank you for reading , if you have any query then leave a message.

Learn ASP NET MVC tutorial

Search This Blog

Insertion using sql link query , jquery and ajax

Comments

Post a Comment

Popular posts from this blog

CRUD Operation in ASP.NET MVC Using ADO.NET Jquery Ajax

Showing List of database Using Jquery, Ajax and Datatable

ASP.NET MVC - Get Started