should I use a datarow for this?

[djc]

I am retrieving fields from a database using a stored procedure that I know
will always only return 1 row. I would like to arrange my text boxes,
dropdown listboxes, etc... and bind the appropriate fields from this stored
procedure to these controls.

Can I return this one row of data directly into a DataRow object? or do I
need to use a DataAdapter and fill a DataTable, then access the DataRow?

Or more generally, what is the preferred way to retrieve 1 row of data and
bind the fields to webserver controls on the page?
any info is appreciated.

 

[Miha Markic [MVP C#]]

I am retrieving fields from a database using a stored procedure that I know
will always only return 1 row. I would like to arrange my text boxes,
dropdown listboxes, etc... and bind the appropriate fields from this
stored
procedure to these controls.

Can I return this one row of data directly into a DataRow object?

No
or do I

need to use a DataAdapter and fill a DataTable, then access the DataRow?
Yes.

Or more generally, what is the preferred way to retrieve 1 row of data and
bind the fields to webserver controls on the page?
any info is appreciated.

Use DataReader and you won't need a DataRow/DataTable.

 

[djc]

Thanks!

No
or do I

Use DataReader and you won't need a DataRow/DataTable.