Category: ado.net

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 […]

Cannot add Entity Data Model in Visual Studio

I am running Visual Studio 08 Team Edition with .NET Framework 3.5 SP1 on WinXP. I am trying to add a Entity Data Model to my project, however, the option to add an “ADO.NET Entity Data Model” selection does not appear. To give you a visual, I am essentially following the directions here, but cannot […]