C# - What is the return value for SqlCommand.ExecuteScalar?
I've got the following code...
cmd = new SqlCommand(strSQL, conn);
cmd.Connection.Open();
strScalar = cmd.ExecuteScalar(); <======= Line causing error
What is the return type of the value of this type of command? Am I using ExecuteScalar() correctly? How do I make it into a string that will feed into this variable?
cmd = new SqlCommand(strSQL, conn);
cmd.Connection.Open();
strScalar = cmd.ExecuteScalar(); <======= Line causing error
What is the return type of the value of this type of command? Am I using ExecuteScalar() correctly? How do I make it into a string that will feed into this variable?
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
object obj = cmd.ExecuteScalar();
if (obj == null)
{
// record not found, do something
}
else
{
// record found, do proper casting like:
// int x = (int)obj;
// string s = (string)obj;
}