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.Soif 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 Singhi should get data from DB.I had done the following changes u had said to mebut 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 tfsperfqueuecon); 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(HomeAdmin)' // 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(AdminHome)' // 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(AdminHome)' // 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.