work on a field of column By C#, ASP.NET code

Question

1.00/5 (1 vote)

See more:

Hi,
Suppose you have three columns of table names, fn, ln, code there. Is there a way that column fn in the fourth field put a lable?
The table is in sql

Posted 22-Aug-12 21:22pm

me64

Add a Solution

Comments

Zoltán Zörgő 23-Aug-12 3:25am

Sorry, what?
Please elaborate your question!

Prabhakaran Soundarapandian 23-Aug-12 3:25am

Can you improve your question?

me64 23-Aug-12 3:30am

I have a table in sql server
Now, i want displaying a field of columns in a label

[no name] 23-Aug-12 3:35am

give you code first!

me64 23-Aug-12 3:38am

I do not
I want to help you

pramod.hegde 23-Aug-12 4:32am

Be clear what you want to say. Elaborate your problem.

me64 23-Aug-12 4:36am

How value of a field into a column, put a label (display in label) ?

me64 23-Aug-12 5:04am

For example, fn column contains the following fields (a table in sql server)
Jenifer
Philip
Morgan
Henri
How third field put in a lable?

pradiprenushe 23-Aug-12 6:38am

you want morgan in column right?

me64 23-Aug-12 7:11am

i want display third field in lable.By language C#

pradiprenushe 23-Aug-12 7:13am

Are you using dataset or datareader while getting data from sql?

me64 23-Aug-12 7:16am

i using dataset

3 solutions

Solution 2

There is an type like Object type , your question is not clear..

Posted 22-Aug-12 22:53pm

Kamalkant(kk)

Comments

me64 23-Aug-12 6:33am

This is not Solution, This is comment

Solution 3

try this,

http://www.mikesdotnetting.com/Article/64/Bind-Data-From-a-SqlDataSource-to-a-Label[^]

Posted 23-Aug-12 0:10am

jeyamothi

Comments

me64 23-Aug-12 6:42am

here All contents of the fn column display in the lable
While one must show,For example, to display the third field. Is that Morgan

jeyamothi 23-Aug-12 7:00am

i am not getting you properly

me64 23-Aug-12 7:03am

For example, fn column contains the following fields (a table in sql server)
Jenifer
Philip
Morgan
Henri
How third field put in a lable?
But,by c# Language in ASP.NET

jeyamothi 23-Aug-12 7:09am

can you send your code where label filled.

me64 23-Aug-12 7:18am

i do not have

jeyamothi 23-Aug-12 7:37am

then how you check?
ok if your using dataset means use like this

ds.tables[0].rows[0][2];

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)

pradiprenushe · Accepted Answer · 2012-08-23T00:37:00

Solution 4

Go through this link
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/

Search for pivot table on google.

If you are using datset then

C#

lblTest.Text= ds.Tables[0].Rows[3]["fn"].ToString();

If using datatable

C#

lblTest.Text = table.Rows[3]["fn"].ToString();

If using datareader

C#

DataReader  dr = cmd.ExecuteReader();
int temp =0;
                while(rdr.Read())
                {
                    temp = temp+1;
            if(temp ==3)
            {
            lblTest.Text = dr["fn"].Tostring();
            }
                }

Posted 23-Aug-12 0:37am

pradiprenushe

Updated 23-Aug-12 1:23am

v5

Comments

me64 23-Aug-12 6:51am

solution must be Language C #.

pradiprenushe 23-Aug-12 7:08am

Do u tou want solution for DataTable from C#? Or you want retrieve fourth row value from table.

me64 23-Aug-12 7:19am

I want retrieve fourth row value from table.

pradiprenushe 23-Aug-12 7:23am

Please see my updated solution

me64 23-Aug-12 8:12am

what problem in line (Label1 = ds.Tables[0].Rows[3]["fn"];)?

SqlConnection con = new SqlConnection();
string str = "Data Source=localhost; initial Catalog=my-db; Integrated Security=True";
con.ConnectionString = str;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = @"select * from mytb";
da.SelectCommand = cmd;
da.Fill(ds);
Label1 = ds.Tables[0].Rows[3]["fn"];

Erore message:
Cannot implicitly convert type 'object' to 'System.Web.UI.WebControls.Label'. An explicit conversion exists (are you missing a cast?)

pradiprenushe 23-Aug-12 8:20am

Label1 = ds.Tables[0].Rows[3]["fn"];
here Label.Text you are trying to assign label which is not property.
ds.Tables[0].Rows[3]["fn"] you need to convert to string because text property requires input as string