When I open the page, the data recorded
Why I cannot display data
@page
@model MyStore.Pages.Clients.IndexModel
@{
}
<br>
<h2>List of Clients</h2>
<a class='btn btn-primary btn-sm' herf='/Clients/Create'>New Client</a>
<table calss="table">
<thead>
<tr>
<th>ID</th>
<th> </th>
<th>Name</th>
<th> </th>
<th>Email</th>
<th> </th>
<th>Phone</th>
<th> </th>
<th>Address</th>
<th> </th>
<th>Created At</th>
<th> </th>
<th>Action</th>
<th> </th>
</tr>
</thead>
<tbody>
@foreach(var item in Model.listclients)
{
<tr>
<td>@item.id</td>
<td>@item.name</td>
<td>@item.email</td>
<td>@item.phone</td>
<td>@item.address</td>
<td>@item.created_at</td>
<td>
<a class="btn btn-primary btn-sm" herf="/Clients/[email protected]">Edit</a>
<a class="btn btn-primary btn-sm" herf="/Clients/[email protected]">Delete</a>
</td>
</tr>
}
</tbody>
</table>
This is the code
using Microsoft.AspNetCore.Mvc.RazorPages;
using System.Data.SqlClient;
namespace MyStore.Pages.Clients
{
public class IndexModel : PageModel
{
public List<ClientInfo> listclients = new List<ClientInfo>();
public void OnGet()
{
try
{
string connectionString = "Data Source=.\\sqlexpress;Initial Catalog=mystore;Integrated Security=True;Encrypt=True;Trust Server Certificate=True";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string sql = "SELECT * From clients";
using (SqlCommand command = new SqlCommand(sql, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ClientInfo clientInfo = new ClientInfo();
clientInfo.id = "" + reader.GetInt32(0);
clientInfo.name = reader.GetString(1);
clientInfo.email = reader.GetString(2);
clientInfo.phone = reader.GetString(3);
clientInfo.address = reader.GetString(4);
clientInfo.created_at = reader.GetDateTime(5).ToString();
listclients.Add(clientInfo);
}
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception : " + ex.ToString());
}
}
}
public class ClientInfo
{
public string id;
public string name;
public string email;
public string phone;
public string address;
public string created_at;
}
}
in the database does not appear. Are there any other files that should be related to this? i am using vb 2022 razor page .Net8