Display data in a asp.net page

Question

2.50/5 (2 votes)

See more:

I want to display data from database in different places. I am using datareader to read the data and stored data like this:

string name=dr["name"].ToString();

then i display the data in webpage writing code like this <=%name%> in source page.
There is a problem that if i need 100 columns of data then i need to use 100 variables to declare and store the data.

so please any one can tell me any other simple procedure to do that.

Thanks in advance

can we access datareader value in source code?
if can then how?

Posted 2-Jun-11 1:13am

rahul dev123

Updated 2-Jun-11 2:05am

v3

Add a Solution

Comments

rudrik8 2-Jun-11 7:17am

u can use string array.

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sunasara Imdadhusen · Answer 1 · 2011-06-02T01:58:00

Solution 3

you can use

XML

<![CDATA[<%= dr["name"].ToString() %>]]>

Posted 2-Jun-11 1:58am

Sunasara Imdadhusen

Comments

rahul dev123 2-Jun-11 8:03am

where to use this code?

anvas kuttan · Answer 2 · 2011-06-02T01:17:00

Solution 1

hi,

if your having different fields you have to use different variables.
or if you have same variables repeating for a number of set the you can use repeater control.

Posted 2-Jun-11 1:17am

anvas kuttan

Dylan Morley · Answer 3 · 2011-06-02T02:12:00

Any reason why you wouldn't want to use a Grid View[^] or one of the other data binding controls?

Instead of using a DataReader, populate a DataSet or DataTable then simply bind to the grid.

You can have the grid autopopulate the columns, so no need for variables or anything like that

E.g. something like this

http://aspalliance.com/757_Code_Snip_Populating_GridView_Control_Using_ASPNET_and_C_with_MouseOver_Effect.2[^]

csharpchamp · Answer 4 · 2011-06-02T03:00:00

Solution 5

use stringBuilder class to build dynamic design
stringbuilder.append("");

Posted 2-Jun-11 3:00am

csharpchamp

prem shanker verma · Answer 5 · 2011-06-02T01:34:00

Solution 2

hi,

Design server side with string builder like
stBuilder.Append("...")Then u will not have to use extra variable.

Posted 2-Jun-11 1:34am

prem shanker verma