TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Harsha Eadara
NA
45
8.5k
fetching data from Db using link button
Jul 10 2017 5:17 AM
This is my Index.cshtml page
@{
ViewBag.Title = "Insert";
Layout = "";
}
<script src="~/Scripts/jquery-1.10.2.js"></script>
<script src="~/Scripts/jquery-ui.min.js"></script>
<div>
<input type="button" class="btn" value="Admin" id="btntst"/>
</div>
<script>
$(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';
},
error: function (error) {
alert(error)
}
});
});
});
</script>
<script type="text/javascript">
$(document).ready(function () {
$("#txtScope_Lock_Date").datepicker();
});
</script>
<script type="text/javascript">
$(document).ready(function () {
$("#txtRelease_Date").datepicker();
});
</script>
<br /><br />
<fieldset>
<div class="form-horizontal">
<div class="editor-label">
Release_Name
</div>
<div class="editor-label">
<input type="text" id="txtRelease_Name" />
</div>
<div class="editor-label">
Scope_Lock_Date
</div>
<div class="editor-label">
<input type="text" id="txtScope_Lock_Date" />
</div>
<div class="editor-label">
Release_Date
</div>
<div class="editor-label">
<input type="text" id="txtRelease_Date" />
</div>
<div class="editor-label">
Segment
</div>
<div class="editor-label">
<input type="text" id="txtSegment" />
</div>
<div class="editor-label">
Query
</div>
<div class="editor-label">
<input type="text" id="txtQuery" />
</div>
<div class="editor-label">
<br />
<input class="btn-default" type="button" id="btnSave" value="Save" />
</div>
</div>
</fieldset>
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()
{
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;
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();
}
}
}
i want to get data from DB if i click on Link button.
Reply
Answers (
3
)
Error in UNIT Test using VS2015
what is treenode.tag means