How to the get to number of retrieved columns?

[Roman Klimkowicz]

Hello everyone,

i just implement an own search site in MS CRM 1.2, which searches in a
MS-SQL database.

My question is, how to get the number of retrieved columns by a SQL-query??

Any suggestions for me?

Thx...


Greets,

Roman

[Scott Mitchell [MVP]]

Roman Klimkowicz wrote:

> i just implement an own search site in MS CRM 1.2, which searches in a
> MS-SQL database.
>
> My question is, how to get the number of retrieved columns by a SQL-query??
>
> Any suggestions for me?

Roman, I am not familiar with MS CRM at all, so this is a shot in the
dark. There's basically two approaches you can use:

(1) Run a SQL query to determine the number of results, i.e.:

SELECT COUNT(*) FROM TableName WHERE ...


(2) Once you have the data back in a DataTable or DataSet, use the
apporpriate properties. For example, the DataTable's Rows collection
has a Count property that specifies how many rows are contained in the
DataTable. I'm not certain what ADO.NET object you are using to
retrieve the data for CRM, so I don't know if this second approach will
be helpful or not.

Thanks

--

Scott Mitchell [ASP.NET MVP]
[email]mitchell@4GuysFromRolla.com[/email]
[url]http://www.4GuysFromRolla.com/ScottMitchell[/url]