Setting label = datasource...

[Roy]

Could someone please post some sample code on how to set an <asp:label>
equal to the results of a sql query?

This seems like it should be simple, but I can't seem to get it done.

[Albert Pascual]

Well what do you get as a return? a SqlDataReader, DataView?
to get every row into the table you'll have to loop around, otherwise, use a
DataGrid to display row by row:

while(pData.Rea d())
Label.Text += pData.GetString (0);

Hope you getting string!

Al

"Roy" wrote:

Could someone please post some sample code on how to set an <asp:label>
equal to the results of a sql query?

This seems like it should be simple, but I can't seem to get it done.

[DotNetJerome]

y,

If you are going to have only one value in your result of a sqlquery thenyou
can use the following code to bind that single value to a label box.

Store that single value in a variable,say "MyVariable " for example, and
assign it to label cotrol as follows.

<asp:Label id="Label1" Text ='<%# MyVariable %>' runat=server/>

You've to write the following line in one of your event's let us Page_Load
event

Page.DataBind() ;
cheers,

Jerome. M
"Roy" wrote:

Could someone please post some sample code on how to set an <asp:label>
equal to the results of a sql query?

This seems like it should be simple, but I can't seem to get it done.

[Roy]

Thanks for the input guys.

Basically, I'm trying to set a label equal to a specific row in a
table. The row would have about 6 columns in it, but it would always be
just a single row. By the same token, I'd like it to look good... Can I
set it equal to a specific field? IOW, break up the row into it's
constituent parts?