This is my Index.cshtml page
@{
ViewBag.Title = "Insert";
Layout = "";
}
ViewBag.Title = "Insert";
Layout = "";
}
$(document).ready(function () {
//function will be called on button click having id btnsave
$('#btntst').click(function(){
// debugger;
var frmdata = {
ReleaseId: $("#txtReleaseId").val(), //Reading text box values using Jquery
Release_Name: $("#txtRelease_Name").val(),
Scope_Lock_Date: $("#txtScope_Lock_Date").val(),
Release_Date: $("#txtReleaseDate").val(),
Segment: $("#txtSegment").val(),
Query: $("#txtQuery").val(),
Status: $("#txtStatus").val()
};
$.ajax({
type: "Get", //HTTP POST Method
url: '@Url.Action("Save","Home")', // Controller/View
//method: 'Post',
data: frmdata,
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function () {
alert("save successfully");
//window.location.href = '/Default1/Insert';
//window.location.href = '/Default1/Insert';
},
error: function (error) {
alert(error)
}
});
});
});
error: function (error) {
alert(error)
}
});
});
});
Release_Name
Scope_Lock_Date
Release_Date
Segment
Query
This is my homecontroller.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MySql.Data.MySqlClient;
using System.Data;
using System.Data.SqlClient;
using Link.Models;
namespace Link.Controllers
{
public class HomeController : Controller
{
public ActionResult Insert()
{
cmd.Parameters.AddWithValue("@ReleaseID", ReleaseID != null ? Convert.ToInt32(ReleaseID) : 0);
cmd.Parameters.AddWithValue("@Release_Name", Release_Name);
cmd.Parameters.AddWithValue("@Scope_Lock_Date", Scope_Lock_Date);
cmd.Parameters.AddWithValue("@Release_Date", Release_Date);
cmd.Parameters.AddWithValue("@Segment", Segment);
cmd.Parameters.AddWithValue("@Query", Query);
cmd.Parameters.AddWithValue("@Status", Status != null ? Convert.ToInt32(Status) : 0);
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MySql.Data.MySqlClient;
using System.Data;
using System.Data.SqlClient;
using Link.Models;
namespace Link.Controllers
{
public class HomeController : Controller
{
public ActionResult Insert()
{
return View();
}
[HttpGet]
public ActionResult Save(string ReleaseID, string Release_Name, DateTime Scope_Lock_Date, DateTime Release_Date, string Segment, string Query, string Status)
{
MySqlConnection con = new MySqlConnection("server=localhost;user id=root;database=perfautomationdb;password=Password@1");
con.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM tfsperfqueue",con);
// cmd.CommandText = "sp_InsertReleasedetails";
// DataTable DATA = new DataTable();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
}
[HttpGet]
public ActionResult Save(string ReleaseID, string Release_Name, DateTime Scope_Lock_Date, DateTime Release_Date, string Segment, string Query, string Status)
{
MySqlConnection con = new MySqlConnection("server=localhost;user id=root;database=perfautomationdb;password=Password@1");
con.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM tfsperfqueue",con);
// cmd.CommandText = "sp_InsertReleasedetails";
// DataTable DATA = new DataTable();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ReleaseID", ReleaseID != null ? Convert.ToInt32(ReleaseID) : 0);
cmd.Parameters.AddWithValue("@Release_Name", Release_Name);
cmd.Parameters.AddWithValue("@Scope_Lock_Date", Scope_Lock_Date);
cmd.Parameters.AddWithValue("@Release_Date", Release_Date);
cmd.Parameters.AddWithValue("@Segment", Segment);
cmd.Parameters.AddWithValue("@Query", Query);
cmd.Parameters.AddWithValue("@Status", Status != null ? Convert.ToInt32(Status) : 0);
cmd.ExecuteNonQuery();
con.Close();
RedirectToAction("Insert");
return View();
}
}
}
con.Close();
RedirectToAction("Insert");
return View();
}
}
}
i want to get data from DB if i click on Link button.
Ranjit PowarPosted Jul 10, 2017, 1:01 PM
Ranjit PowarPosted Jul 11, 2017, 12:32 PM
//window.location.href = '/Default1/Insert';
Harsha EadaraPosted Jul 11, 2017, 12:41 AM