Decoding JSON information in ASP.NET using C# and the Razor engine

Question

Decoding JSON information in ASP.NET using C# and the Razor engine

Hi there, I'm currently working in Visual Studio with ASP.NET and Razor. I am trying to populate a table with values from a database table, but I need to decode or parse JSON into simple text first. Any assistance would be greatly appreciated. Here is the code snippet that I am currently using: https://i.sstatic.net/K7imY.png

  [HttpGet]
        public ActionResult GetData()
        {
            string stdb = "Data Source=DMX87025;Initial Catalog=DB_PCC;Integrated Security=True";
            SqlConnection conn = new SqlConnection(stdb);
            string sql = "SELECT *FROM[DB_PCC].[dbo].[Departments]";
            SqlCommand cmd = new SqlCommand(sql, conn);
            conn.Open();

            SqlDataReader rd = cmd.ExecuteReader();

            var st = "kyo please help me u.u";
            return Json(new { success = true, message = rd },
                JsonRequestBehavior.AllowGet);
        }

This is the AJAX function that I have implemented...

<div id="result"></div>
<input type="button" name="name" value="try" onclick="DepListQuery()" />

<script>

    function DepListQuery() {

        $.ajax({
            type: 'GET',
            url: '@Url.Action("GetData","Home")',
            contentType: "application/json; charset=utf-8",
            dataType: "json",
            success: function (response) {

                $('#result').text(response.message);
            },
            failure: function (response) {
                alert("something went wrong u.u");
            }
        });
    }   

</script>

javascript c#ajax asp.net-mvc

Answer 1

Answer №1

To improve your data reading process from the SqlDataReader, it is recommended to utilize extension methods to read data directly into objects. A helpful tutorial on this topic can be found here:

For a more efficient approach, consider implementing extension methods as demonstrated in the following answer: Convert rows from a data reader into typed results

Here is an example of a sample extension method:

public static List<T> ReadList<T>(this IDataReader reader, 
                                  Func<IDataRecord, T> generator) {
     var list = new List<T>();
     while (reader.Read())
         list.Add(generator(reader));
     return list;
}

After calling

SqlDataReader rd = cmd.ExecuteReader();

, you can use the following code snippet:

var departmentList = reader.ReadList(x => new Department {
                                           DeptID = x.GetInt32(0),
                                           DeptName = x.GetString(1)
                                    });

Once you have populated a list of objects using this method, you can then handle them in the front-end view using AJAX:

How to parse JSON list of string on ajax return?

List of Objects To Json String

It is also advisable to enclose your database connections such as SqlConnection, SqlCommand, and SqlDataReader within using blocks for proper resource management.

Answer 2

To improve your data reading process from the SqlDataReader, it is recommended to utilize extension methods to read data directly into objects. A helpful tutorial on this topic can be found here:

For a more efficient approach, consider implementing extension methods as demonstrated in the following answer: Convert rows from a data reader into typed results

Here is an example of a sample extension method:

public static List<T> ReadList<T>(this IDataReader reader, 
                                  Func<IDataRecord, T> generator) {
     var list = new List<T>();
     while (reader.Read())
         list.Add(generator(reader));
     return list;
}

After calling

SqlDataReader rd = cmd.ExecuteReader();

, you can use the following code snippet:

var departmentList = reader.ReadList(x => new Department {
                                           DeptID = x.GetInt32(0),
                                           DeptName = x.GetString(1)
                                    });

Once you have populated a list of objects using this method, you can then handle them in the front-end view using AJAX:

How to parse JSON list of string on ajax return?

List of Objects To Json String

It is also advisable to enclose your database connections such as SqlConnection, SqlCommand, and SqlDataReader within using blocks for proper resource management.

Decoding JSON information in ASP.NET using C# and the Razor engine

Answer №1

Similar questions

Could not locate the provider: $stateProvider

Implement input validation in React by enhancing the functionality of HTML input tags

Preserving Scroll Location Through Back Button Usage and Ajax Manipulation of the Document Object Model

Ways to automatically update options in a dropdown menu using text box entries

What is the process to change the jQuery quiz outcome into a PDF when a user clicks a

Is there really a need to go through the hassle of creating a pure javascript/jquery widget when I can simply load it into an

The search and sorting functionality in jquery DataTables is malfunctioning

The implementation of various asynchronous Html.BeginForm scripts

Addressing three visual problems with an html form input, dropdown menu, and clickable button

Is there a way to extract the URL from an ng-resource?

Implement the Vue.js @click directive in a location outside of an HTML element

Instructions for incorporating animation into the CSS properties of an element as the class is updated using jQuery

Having trouble with refreshing the div content when using jQuery's $.ajax() function

Struggling to eliminate buttons upon clicking, but they persistently reappear (JavaScript, HTML)

Finding a particular movie in React

Library for implementing stylish font effects in JavaScript

Discovering the highest value within an array of objects

Error: The function onChange is not recognized

Determine the number of elements chosen within a complex JSON structure

Error in Dotfuscator - External type System.Data.Entity.Infrastructure.Annotations.AnnotationValues not located for EntityFramework framework with Version 6.0.0.0