i want to get row values to labels

Question

3.00/5 (1 vote)

See more:

C#

str = "select CAT_NO from CATEGORY1";
cmd = new SqlCommand(str, cn);
sda = new SqlDataAdapter(cmd);
ds = new DataSet();
sda.Fill(ds, "CATEGORY1");
dt = ds.Tables[0];
foreach (DataRow dr1 in dt.Rows)
{
    label1.Text = dr1[0].ToString();
    label2.Text = dr1[0].ToString();
}

The table contains two rows sub1 and sub2 and the label1 should display sub1 and label 2 display sub2 but using this code both the labels displays sub2

Posted 20-Apr-15 21:11pm

MadhuRavuri

Updated 20-Apr-15 21:19pm

Mario Z

v2

Add a Solution

Comments

Deepak Kanswal Sharma 21-Apr-15 3:21am

Have you tried changing the index?
label2.Text = dr1[1].ToString();

MadhuRavuri 21-Apr-15 3:24am

yes when changing the index the error was cannot find column 1

MadhuRavuri 21-Apr-15 3:25am

how to get 2nd row value of same column to another label

Deepak Kanswal Sharma 21-Apr-15 3:39am

What about the rows syntax?

2 solutions

Solution 2

label1.Text = dr1.Rows[0]["column-name"].ToString();
label2.Text = dr1.Rows[1]["column-name"].ToString();

Try this thing.

Posted 20-Apr-15 21:45pm

Deepak Kanswal Sharma

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)

Mario Z · Accepted Answer · 2015-04-20T21:22:00

Solution 1

Can you try changing the label2.Text assignment to this:

C#

label2.Text = dr1[1].ToString();

Oh I see now (or at least I hope I know now what you mean), you have two rows with a single column (that CAT_NO column) right?
In that case try this:

C#

dt = ds.Tables[0];
label1.Text = dt.Rows[0][0].ToString();
label2.Text = dt.Rows[1][0].ToString();

Posted 20-Apr-15 21:22pm

Mario Z

Updated 20-Apr-15 21:48pm

v2

Comments

MadhuRavuri 21-Apr-15 3:26am

yes when changing the index the error was cannot find column 1
how to get 2nd row value of same column to label2

Mario Z 21-Apr-15 3:50am

I edited my answer, please check it out.
I hope this helps.