Why we use here datareader,executereader,datasource,datatext field and data value field and databind?

Question

1.00/5 (2 votes)

See more:

Can anyone explain this coding step by step?

C#

public void city()
    {
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }
        SqlCommand cmd = new SqlCommand("select distinct area from product", con);
        SqlDataReader dr = cmd.ExecuteReader();
        BulletedList2.DataSource = dr;
        BulletedList2.DataTextField = "area";
        BulletedList2.DataValueField = "area";
        BulletedList2.DataBind();
        con.Close();
    }

Posted 17-Nov-11 17:04pm

sathiyak

Updated 17-Nov-11 17:10pm

koolprasad2003

v2

Add a Solution

Comments

koolprasad2003 17-Nov-11 23:24pm

why you Question subject and body are mismatched ?

sathiyak 17-Nov-11 23:32pm

sorry....hereafter i takecare...

3 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)

koolprasad2003 · Answer 1 · 2011-11-17T17:13:00

Solution 1

Go step by step

1. check for the coonection if it's closed then open the connection
2. Execute Query to select distinct area from product table
3. strore result in reader
4. bind the BulletedList2 with area
5. connection close.

Posted 17-Nov-11 17:13pm

koolprasad2003

Not Active · Answer 2 · 2011-11-17T17:16:00

If the connection is not opened, then open it.
Construct a SqlCommand by providing a SQL statement
Execute the SqlCommand and return a SqlDataReader that contains the resultset
Assign SqlDataReader to the datasource of BulletedList
Tell BulletedList2 what fields in the SqlDatReader results to use
Cause BulletedList2 to bind to the results in the SqlDataReader in the DataSource and construct the html elements

Now, next time learn to read some documentation. All of this is explained in great detail in a great many sources.

moneymakermaster · Answer 3 · 2011-11-17T17:41:00

The main Idea of this code is to get the cities from the database and bind it to a list.
So the SqlCommand and DataReader fetch the data from the Database.

The DataSource of list is bound to the dr where the data from Database has been stored.

DataTextField and DataValueField refers to the text to be displayed to you in the page and the value of the item selected to be posted back respectively.

Finally you are binding the data to the list

Why we use here datareader,executereader,datasource,datatext field and data value field and databind?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0