display SqlDataReader values bound to labels MSSQL C#

I have very limited knowledge on asp .net using c#. I am trying to fetch data from my mssql database and display the value on my page. I have succeeded to display it using datagrid. But I want it to diplay attached to labels or text boxes.

Below is the code that I have made but it is throwing error

Expand|Select|Wrap|Line Numbers

 
<%@ Page Language="c#" %>

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

<%@ import Namespace="System.Data.SqlClient" %>

<script runat="server">
 
    void Page_Load()

    {

            string connectionStr =

"server=63.45.234.23;uid=MSSqldbdbdb;pwd=password;database=MSSqldbdbdb";

            string queryStr = "SELECT * FROM dibs_test";
 
            SqlConnection connectObj = new

SqlConnection(connectionStr);

            SqlCommand commandObj = new

SqlCommand(queryStr,connectObj);
 
            SqlDataReader readerObj;
 
            connectObj.Open();

            readerObj=commandObj.ExecuteReader();
 
            // display datareader contents into html table

           // first open the table and set up the table headers

           html += "<table cellspacing=1 class='data' width=90%>";

           html += "<tr>";

           html += "<th>Customer ID</th>";

           html += "<th>Company Name</th>";

           html += "</tr>";
 
           // loop thru the reader

           while ( readerObj.Read ( ) ) {

              html += "<tr>";

              html += "<td>" + readerObj.GetInt ( 0 ) + "</td>";

              html += "<td>" + readerObj.GetString ( 1 ) + "</td>";

              html += "</tr>";

           }
 
           // close the table

           html += "</table>";

    }
 
</script>

<html>

<head>

    <title>Record</title>

</head>

<body>

    <h2>Use DataReader to display table with variables not using datagrid

    </h2>

    <%=html%>

</body>

</html>
 
</html>

Apr 15 '10 #1

Subscribe Post Reply

6199

Frinavale

9,735

Expert Mod 8TB

It would really help if you stated what the error message was saying ;)
I thought you said you were using a "DataGrid" to display your data? But looking at your code it's clear that you are not using a "DataGrid" at all! You're dynamically creating an HTML table based on the data retrieved from the database.

There is an easier (better?) way of doing this.
Use the GridView control instead.

So, after you have retrieved the data from the database, instead of dynamically creating the table, set the GridView's DataSource property to the table retrieved and use the GridView.DataBind() method to bind the data to the grid.

In the GridView, you can specify how the data is displayed.
You do this using TemplateFields and other types of "columns".
You can use labels in the template to make sure that the data is displayed exactly the way you want it to.

-Frinny

Apr 15 '10 #2

dibwas

Hii,

Thanks for replying.

I have used datagrid view... and that works correct..

I didn't knew I could design a datagrid.. so I was trying to generate HTML code instead.

Below is the code with datagrid that worked.

Expand|Select|Wrap|Line Numbers

 
<%@ Page Language="c#" %>

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

<%@ import Namespace="System.Data.SqlClient" %>

<script runat="server">
 
    void Page_Load()

    {

            string connectionStr =

"server=63.45.234.23;uid=MSSqldbdbdb;pwd=password;database=MSSqldbdbdb";

            string queryStr = "SELECT * FROM dibs_test";
 
            SqlConnection connectObj = new

SqlConnection(connectionStr);

            SqlCommand commandObj = new

SqlCommand(queryStr,connectObj);
 
            SqlDataReader readerObj;
 
            connectObj.Open();

            readerObj=commandObj.ExecuteReader();
 
            dataGridControl.DataSource = readerObj;
 
            dataGridControl.DataBind();
 
    }
 
</script>

<script language="javascript">

alert("dibs");

</script>

<html>

<head>

    <title>Visualizzo i record</title>

</head>

<body>

    <h2>Uso DataReader per visualizzare il contenuto di una tabella 

    </h2>

    <asp:DataGrid id="dataGridControl" runat="server"></asp:DataGrid>

</body>

</html>

Can you provide some simple steps to display image, links, designed text ... etc with data fetched from database and displayed into datagrid.

Thanks

Dibs

Apr 15 '10 #3

Frinavale

9,735

Expert Mod 8TB

Instead of relying on the DataGrid to determine what columns to display you manually add the columns. To do this you need to use the TemplateField class this lets you specify controls that are bound to your data source so that you can display the data the way you want to.

It has been a very long time since I've used a DataGrid so I'm not even sure if the TemplateField works with this control.

Why are you using the DataGrid when the GridView is the updated, new-and-improved version that has been around for many years now?

-Frinny

Apr 15 '10 #4

Similar topics

SQLDATAREADER

by: Arvind P Rangan | last post by:

Hi All, How do you get all the values of a sqldatareader if it contains multiple resultset. Using sqldatareader.nextresult and sqldatareader.read e.g. While sqldatareader.read ' If not...

ASP.NET

Image download upload display problems on aspx (code pasted in)

by: Adam | last post by:

I am having difficulty retrieving images from a SQL database. Here is the code I use to UPLOAD the image to the database: <form id="Form1" method="post" enctype="multipart/form-data"...

ASP.NET

How to access selected row values in Datalist

by: Gary Frank | last post by:

I added a couple of labels and a button to a Datalist control called "dlSignIn" by adding them to the Item template. The labels are bound to a dataset column. Program code gets executed in the...

ASP.NET

late bound form reference

by: Galen Somerville | last post by:

In two different Form modules FFTcls.Currfrm = Me In FFTcls class module Dim CurrForm As System.Windows.Forms.Form Public WriteOnly Property Currfrm() As System.Windows.Forms.Form...

Visual Basic .NET

Checkboxes - How do I display values from a reference table

by: Fendi Baba | last post by:

I have a table with a field called ProjectPhaseID, and another which shows the ProjectPhaseID and ProjectPhaseName. On the data enty form, I want to display the ProjectPhaseName as radio button...

Microsoft Access / VBA

Unable to Display Image from database at runtime

by: den 2005 | last post by:

Hi everyone, Here is code working on..Trying to insert record with a column with Image or VarBinary datatype in sql database from a existing jpeg image file, then retrieve this image from...

ASP.NET

Dynamically Populate DataGrid Using SqlDataReader

by: rn5a | last post by:

A SqlDataReader is populated with the records from a SQL Server 2005 DB table. The records retrieved depends upon 2 conditions (the conditions depend on what a user selects in an ASPX page). If...

ASP.NET

Retrieve and add the values from a Quiz form and display the results.

by: geckobtz | last post by:

Hi Guys, I am trying to build a page in ASP/MSsql with the aid of dreamweaver, the page contains total of 6 Questions, each question has 3 choices, of which one of the choice contains the right...

ASP / Active Server Pages

Best way to display data.

by: RB | last post by:

Hi there, I'm pretty new to ASP.NET, and have a "best practice" sort-of question. I'm programming for .NET 2.0, using VB.Net in Visual Studio 2002. Basically, I've got a web-page which is...

ASP.NET

How do I put computed values in 'formview'

by: COHENMARVIN | last post by:

I have a formview control, with labels arranged in a table. The labels are bound to fields from a query. But I also want to sum up the values in the table and put them in a row of totals at the...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice