Loop through records in DataReader in ASPX page using C#

onvar119...

SOLVED CLOSED ACTIVE ANSWERED
User: onvar1196
Posted: on Sep 18, 2023 03:12 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 1977
Sample Code: Download

explaın: I cannot return the database data with the while oledbdatareader or sqldatareader in the web designer form and html table in Visual Studio 2015 the editor say dr1 variable get a the name dr1 does not exıst context say error and I'm trying to make the code look like a list like MVC.

I don't want to use placeholder dataview buildingstring datalist etc.

I couldn't manage to create a loop on the classic html table web designer side.

In short, the loop should be on the web designer form side.

I couldn't find any examples in movies or examples on the internet and how should the behind and web design side of my code be?

I would appreciate it if you could help me.

For example, in all codes, behind side always has buildingstring dataview placeholder etc.

Kind regards

namespace JOIN_PROJEM
{
    public partial class WebForm2 : System.Web.UI.Page
    {
        public IEnumerable<IDataRecord> ListUrunlers()
        {
            OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
            OleDbCommand command = new OleDbCommand("select * from country", connection);

            connection.Open();
            OleDbDataReader dr = command.ExecuteReader();

            while (dr.Read())
            {
                yield return dr;

            }
        }
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm2.aspx.cs" Inherits="JOIN_PROJEM.WebForm2" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
  <table>
<% foreach (idatarecord record in ListUrunlers()) { %>
<tr>
    <td> Product Name:</td>
    <td> <%= record["urunadi"] %> </td>
    <td> <%= record["productlinki"] %> </td>
</tr>
<% } %>
</table>           
    </div>
    </form>
</body>
</html>

idatarecord does not appear. There are many elements starting with idata in the library, but this one does not exist.

How can I add it? It says add a missing reference to it.

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 15

Reply
ANSWER
User: dharmendr
Replied: on Sep 20, 2023 06:04 AM
Modified: on Sep 22, 2023 02:05 AM
Report

Hi onvar1196,

You need to import the System.Data namespace in the aspx page.

Database

I have made use of the following table Customers with the schema as follows.

I have already inserted few records in the table.

You can download the database table SQL by clicking the download link below.

Download SQL file

HTML

<%@ Import Namespace="System.Data" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <table>
            <% foreach (IDataRecord record in ListUrunlers()) { %>
                <tr>
                    <td><%= record["CustomerId"] %> </td>
                    <td><%= record["Name"] %> </td>
                    <td><%= record["Country"] %> </td>
                </tr>
            <% } %>
        </table>
    </form>
</body>
</html>

VB.Net

<%@ Import Namespace="System.Data" %>
<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <table>
            <% For Each record As IDataRecord In ListUrunlers() %>
                <tr>
                    <td><%= record("CustomerId") %> </td>
                    <td><%= record("Name") %> </td>
                    <td><%= record("Country") %> </td>
                </tr>
            <% Next %>
        </table>
    </form>
</body>
</html>

Namespaces

using System.Configuration;
using System.Data;
using System.Data.SqlClient;

VB.Net

Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient

Code

public IEnumerable<IDataRecord> ListUrunlers()
{
    SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
    SqlCommand command = new SqlCommand("SELECT CustomerId, Name, Country FROM Customers", connection);
    connection.Open();
    SqlDataReader dr = command.ExecuteReader();
 
    while (dr.Read())
    {
        yield return dr;
    }
}

VB.Net

Public Iterator Function ListUrunlers() As IEnumerable(Of IDataRecord)
    Dim connection As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("constr").ToString())
    Dim command As SqlCommand = New SqlCommand("SELECT CustomerId, Name, Country FROM Customers", connection)
    connection.Open()
    Dim dr As SqlDataReader = command.ExecuteReader()
    While dr.Read()
        Yield dr
    End While
End Function

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Loop through records in DataReader in ASPX page using C#

Company

Explore

Follow us

Contact Us