Silly question on DataBinding

[MikeD]

Hello,

Sorry about this but I don't have my notes with me today. I wish to bind a
SQL SELECT statement to a set of .NET labels within a table. These are for
ReadOnly purposes and I don't think it necesitates a data container
(DataGrid, Repeater, etc) as it will only be one record at any time. I've
placed the labels in a table within a form, but can't remeber how to bind
them to columns from teh dataset.

Does anyone have a sample of how to go about this as I just can't remember?

Thanks,

<M>ike

 

[Sam Fields]

two ways:

1. Via back-end code only: Load your data in the page_load event and set
the .text property of the labels to the correct values.
2. Via front-end databinding AND back-end code: Create a protected
datatable at the class level. Fill it on page_load with the data. Call
MyLabel.DataBind() after filling the datatable. On your aspx page, set the
text property of the label as follows: Text='<%#
DataBinder.Eval(MyDataTable.Rows[0], "MyColumnName") %>'

 

[MikeD]

Thanks Sam,

I think that's what I was looking for.

<M>ike

two ways:

1. Via back-end code only: Load your data in the page_load event and set
the .text property of the labels to the correct values.
2. Via front-end databinding AND back-end code: Create a protected
datatable at the class level. Fill it on page_load with the data. Call
MyLabel.DataBind() after filling the datatable. On your aspx page, set the
text property of the label as follows: Text='<%#
DataBinder.Eval(MyDataTable.Rows[0], "MyColumnName") %>'

Hello,

Sorry about this but I don't have my notes with me today. I wish to bind a
SQL SELECT statement to a set of .NET labels within a table. These are for
ReadOnly purposes and I don't think it necesitates a data container
(DataGrid, Repeater, etc) as it will only be one record at any time. I've
placed the labels in a table within a form, but can't remeber how to bind
them to columns from teh dataset.

Does anyone have a sample of how to go about this as I just can't remember?

Thanks,

<M>ike