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