Category: c++

Linq – How to aggregate the results of another query

Post author By user user
Post date February 19, 2022
Categories In aggregate, c++, linq
3 Comments on Linq – How to aggregate the results of another query

I want to take the results of a where clause on a list and then take that result set and create just one new type that has all its fields constructed from aggregates of the original query. So given the basic example below, is there anyway to combine the 2 linq statements into one? If […]

Using the SQL Command object, how can you check to see if the result set is empty?

Post author By user user
Post date February 19, 2022
Categories In ado.net, asp.net, c++, sql
7 Comments on Using the SQL Command object, how can you check to see if the result set is empty?

Using the ExecuteScalar method in the SQL Command object, how can you check to see if the result set is empty? I am using ASP.net, C#, and MS SQL 2008. Right now when I run the following code the Response.Write returns a 0 when the resultset is empty. But I would like to differentiate between […]