Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning an object back?
Message
From
20/02/2013 09:40:53
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
C# 4.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01566475
Message ID:
01566480
Views:
60
This message has been marked as a message which has helped to the initial question of the thread.
We've been through this. Don't use out parameters. If you get no rows back, return null.

>Hi everybody,
>
>I am wondering if what I've written is OK or it's better to use boolean merhod here and return row as a parameter?
>
>
>/// <summary>
>        /// Returns row for Pass table
>        /// </summary>
>        /// <param name="sqlCommand"></param>
>        /// <returns></returns>
>        public DataRow GetPassRow(SqlCommand sqlPassCommand, ref String messageText, ref Int32 statusCode)
>        {
>            DataSet ds;
>            if (database.ExecuteSqlCommand(sqlPassCommand, out ds, ref messageText, ref statusCode))
>                return ds.Tables[0].Rows[0];
>            else
>                return new DataRow(); // Empty data row
>        }
>
>The problem I see here is how should I examine the result of this method when I call it? Perhaps it's better to use the out parameter?
>
>Thanks in advance.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform