C#•3y ago

❔ Using DataTable in .cshtml File with JavaScript

Hello everyone,

I'm still new to using C#, and I'm trying to figure out how you display data from a SQL database that is called in the OnGet() method of my page with a paginated table.

using System.Data;
using System.Data.SqlClient;
using Microsoft.AspNetCore.Mvc.RazorPages;

namespace ExampleWebsite.Pages;

public class Responses : PageModel
{
    public void OnGet()
    {
        DataTable table = new DataTable();
        const string connectionString = "secret";
        using (SqlConnection connection = new SqlConnection(
                   connectionString )
               )
        using(SqlCommand cmd = new SqlCommand(
                  "SELECT * FROM Responses", 
                  connection )
              )
        using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
        {
            adapter.Fill(Dt);
        }
    }
}

using System.Data;
using System.Data.SqlClient;
using Microsoft.AspNetCore.Mvc.RazorPages;

namespace ExampleWebsite.Pages;

public class Responses : PageModel
{
    public void OnGet()
    {
        DataTable table = new DataTable();
        const string connectionString = "secret";
        using (SqlConnection connection = new SqlConnection(
                   connectionString )
               )
        using(SqlCommand cmd = new SqlCommand(
                  "SELECT * FROM Responses", 
                  connection )
              )
        using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
        {
            adapter.Fill(Dt);
        }
    }
}

using System.Data;
using System.Data.SqlClient;
using Microsoft.AspNetCore.Mvc.RazorPages;

namespace ExampleWebsite.Pages;

public class Responses : PageModel
{
    public void OnGet()
    {
        DataTable table = new DataTable();
        const string connectionString = "secret";
        using (SqlConnection connection = new SqlConnection(
                   connectionString )
               )
        using(SqlCommand cmd = new SqlCommand(
                  "SELECT * FROM Responses", 
                  connection )
              )
        using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
        {
            adapter.Fill(Dt);
        }
    }
}

using System.Data;
using System.Data.SqlClient;
using Microsoft.AspNetCore.Mvc.RazorPages;

namespace ExampleWebsite.Pages;

public class Responses : PageModel
{
    public void OnGet()
    {
        DataTable table = new DataTable();
        const string connectionString = "secret";
        using (SqlConnection connection = new SqlConnection(
                   connectionString )
               )
        using(SqlCommand cmd = new SqlCommand(
                  "SELECT * FROM Responses", 
                  connection )
              )
        using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
        {
            adapter.Fill(Dt);
        }
    }
}

This is where I am so far. Any help is greatly appreciated.

Angius•4/21/23, 9:11 PM

If you're using Razor Pages - which you seem to be doing - just create a property on that class and save your data there

Angius•4/21/23, 9:12 PM

(also, a very weird choice to be using DataTables and ADO with modern ASP)

Accord•4/22/23, 9:20 PM

Was this issue resolved? If so, run

/close

/close

otherwise I will mark this as stale and this post will be archived until there is new activity.

❔ Using DataTable in .cshtml File with JavaScript

Similar Threads

Similar Threads

Similar Threads