DbDataAdapter.Fill() - just the first row

[Guest]

Hi;

Is there a database independent way to fill just the 1st row of a DataTable?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[William \(Bill\) Vaughn]

If you use a DataReader, you can use the CommandBehavior.SingleRow.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[Cor Ligthert [MVP]]

David,

Will you explain this a little bit more, because when you want to load
database information in a datatable, than trying to do this withouth SQL is
at the moment impossible. In SQL is the simple First 1 so doing that extra
is as well crazy.

Cor

 

[Guest]

The "first 1" or "top 1" is different for each vendor.


--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Miha Markic]

Hi David,

You have various Fill method overloads that accept startRecord and
maxRecords argument.
However, this way is not optimal as all records will be fetched and only the
first one will be inserted into the table.
Best way is to specify the right sql statement...
BTW, did you consider an ORM based solution?

 

[Charles Zhang]

You can create a datareader object by using "ExecuteReader". To return
the first row only, using CommandBehavior.SingleRow

To fill a datatable from a datareader object, you can use DataTable.Load()

Charles Zhang
SpeedyDB Technologies (The fastest, most secure ADO.NET Provider over
Wide Area Network)
http://www.speedydb.com

 

[Guest]

But no way to have DataTable.Load() load just the first row

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Miha Markic]

CommandBehavior.SingleRow is just an optimization hint and it doesn't affect
the actual select - meaning that all the data is fetched but only one row is
returned.

 

[Charles Zhang]

But no way to have DataTable.Load() load just the first row

The datareader only contains one row if you use
CommandBehavior.SingleRow to return the datareader. The DataTable.Load()
will only load whatever the datareader object returns.

Charles Zhang
SpeedyDB Technologies (The fastest, most secure ADO.NET Provider over
Wide Area Network)
http://www.speedydb.com

 

[Guest]

thank you

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm