brokeMyLegBiking
asked on
return type from ExecuteNonQuery other than integer
Is there a way to get a more complete return type than just an integer when you run the ExecuteNonQuery statement? For example if the query produces warnings, or messages, is there a way to capture these?
Dim iRet As Integer = cmd.ExecuteNonQuery()
I'd like to get back more than just an integer or SqlException! That would be very helpful!
-brokeMyLegBiking.
Dim iRet As Integer = cmd.ExecuteNonQuery()
I'd like to get back more than just an integer or SqlException! That would be very helpful!
-brokeMyLegBiking.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
YZlat is correct. Only integer or Exception will be returned by ExecuteNonQuery.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok, interesting option.
ASKER
Is there an alternative to ExecuteNonQuery?
What about the new Sql Stored procedures? Do they offer more return types than just integer? Does anyone know anything about the return types for SqlServer CLR hosted .NET assemblies?
thx,