How to access an SQL function via .NET DataAdapter?

[Dick Swager]

Is there a way to use a DataAdapter to retrieve data via an SQL function? I
have done what I need to do using a stored procedure that returns a 1x1
table, but it seems like it would be much cleaner if the single value
returned by a function could be obtained. Maybe there is some mechanism
other than a DataAdapter. I've been away from this stuff for a while and
I'm trying to re-learn a lot of the C++ / SQL interaction stuff with .NET.

Dick

 

[Guest]

Dick,

Use a command object, for example an SQLCommand object if you are working
with SQL Server.

You can use the command object's ExecuteScalar method to retrieve a single
value.

Kerry Moorman

 

[Cor Ligthert[MVP]]

Dick,

Beside the by Kerry told executescalar there is as well the datareader,
which gives you a row back from the resultset. There are more kind of
adapters, however those are generated using the dataadapter (while the
dataadapter is in fact using the datareader).

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader(VS.71).aspx

Cor

 

[Dick Swager]

Thanks for the help. This stuff is so easy when you know how.

Dick