Fetching data from DB by clicking on TAB in MVC.

Question

Hi i'm doing a project in MVC.I have to create a TAB .I had named that TAB as "ADMIN".So,if i click on that ADMIN TAB ,i have to fetch data from DB in GridView.I known how to do in ASP.NET ,But i'm not able to do in MVC.Can u pls help me out.

Harsha Eadara · Answer

Hi Ramesh Singh,i should get data from DB.I had done the following changes u had said to me,but still i'm getting error .I'm posting my controller and view.Any modifications pls tell me. Thank u. This is my Controller. 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 Admin(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.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(); } } } This is my View: Link.Models.Details; @{ ViewBag.Title = "Admin"; Layout = ""; } Admin @Model.ReleaseID @Model.Release_Name @Model.Scope_Lock_Date @Model.Release_Date @Model.Segment @Model.Query @Model.Status $("#btnst").click(function() { $(document).ready(function () { //function will be called on button click having id btnsave { // 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("Home","Admin")', // Controller/View //method: 'Post', dataType: "json", contentType: "application/json; charset=utf-8", success: function () { alert("save successfully"); //window.location.href = '/Home/Insert'; }, error: function (error) { alert(error) } }); } }); }); $(document).ready(function () { $("#txtScope_Lock_Date").datepicker(); }); $(document).ready(function () { $("#txtRelease_Date").datepicker(); }); Release_Name Scope_Lock_Date Release_Date Segment Query While im running my project im getting error like this: The parameters dictionary contains a null entry for parameter 'Scope_Lock_Date' of non-nullable type 'System.DateTime' for method 'System.Web.Mvc.ActionResult Admin(System.String, System.String, System.DateTime, System.DateTime, System.String, System.String, System.String)' in 'Link.Controllers.HomeController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter. Parameter name: parameters Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentException: The parameters dictionary contains a null entry for parameter 'Scope_Lock_Date' of non-nullable type 'System.DateTime' for method 'System.Web.Mvc.ActionResult Admin(System.String, System.String, System.DateTime, System.DateTime, System.String, System.String, System.String)' in 'Link.Controllers.HomeController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter. Parameter name: parameters Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Ramesh Singh · Answer

Hi Harsha, r u working for binding records or saving( inserting records) into data base? User GET/ Post method accroding to that. Need to change in code for getting records set into view:-. 1 .remove $("#btnst").click(function(){ code from $(document).ready(function () {. No need to put under document.ready method. 2. change this code - url: '@Url.Action("Admin","Home")', // Controller/View url: ControllerName/ActionName (" Home/ Admin") 3. does Action (method) Admin can accept paramter . Iy no, then remove - data: frmdata , part from ajax call. 4. debug server side code (C#) code to check that Admin() method retuns value or not. if you are still facing issue then pass me controller code. Regards, Ramesh

Harsha Eadara · Answer

Hi Ramesh Singh even i had done the same thing .I'm able to get TAB ,But i'm not able to get data.I'm posting my code.Any modifications should be done to my code pls tell me. This is my view Admin.cshtml: Link.Models.Details; @{ ViewBag.Title = "Admin"; Layout = ""; } Admin @Model.ReleaseID @Model.Release_Name @Model.Scope_Lock_Date @Model.Release_Date @Model.Segment @Model.Query @Model.Status $(document).ready(function () { //function will be called on button click having id btnsave $("#btnst").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("Admin","Home")', // Controller/View //method: 'Post', data: frmdata, dataType: "json", contentType: "application/json; charset=utf-8", success: function () { alert("save successfully"); //window.location.href = '/Home/Insert'; }, error: function (error) { alert(error) } }); }); });

Ramesh Singh · Answer

Use ajax call for tab click event and get collection of data to bind into HTML table or JQGrid. Please see below snapshot code. $('#TabName').click(function () { $.ajax({ url: '/ControllerName/ActionName/', type: 'Get', // data: JSON.stringify(ProjectElements), contentType: 'application/json; charset=utf-8', success: function (data) { //binding data into html table }, }); });

Harsha Eadara · Answer

Hii Harish Supekar ,while i'm compiling my project im getting error like this: The parameters dictionary contains a null entry for parameter 'ReleaseID' of non-nullable type 'System.Int32' for method 'System.Web.Mvc.ActionResult Admin(Int32, System.String, System.DateTime, System.DateTime, System.String, System.String, Int32)' in 'Link.Controllers.HomeController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter. Parameter name: parameters Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentException: The parameters dictionary contains a null entry for parameter 'ReleaseID' of non-nullable type 'System.Int32' for method 'System.Web.Mvc.ActionResult Admin(Int32, System.String, System.DateTime, System.DateTime, System.String, System.String, Int32)' in 'Link.Controllers.HomeController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter. Parameter name: parameters

Harish Supekar · Answer

Hi Harsha, As per my yesterday reply, you need to use jquery and call code behind method that return list of record from db. In MVC, there is no inbuilt controls like GridView. So for populating list of data you need to create a table that display that records. Currently I don't have code to share with you. but you can refer below url for creating and populating list of records. url=> http://www.binaryintellect.net/articles/b1e0b153-47f4-4b29-8583-958aa22d9284.aspx Regards, Harish.