should I use a datarow for this?

  • Thread starter Thread starter djc
  • Start date Start date
D

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.
 
djc said:
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?
Click to expand...

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.
Click to expand...

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