C#

paper67 wrote:

I use the "TableAdapter Configuration Wizard" to generate my DAL code

string name = sqlcommRights.ExecuteScalar().ToString();

public virtual T
ExecuteScalar<T>
(
    T IfNull
)
{
    lock ( this.command )
    {
        try
        {
            this.OpenCount++ ;

            object result = this.command.ExecuteScalar() ;

            if ( ( result == null ) || ( result == System.DBNull.Value ) )
            {
                result = IfNull ;
            }
            else if ( typeof(T) != result.GetType() )
            {
                result = System.Convert.ChangeType
                (
                    result
                ,
                    typeof(T)
                ) ;
            }
            this.RaiseEvent ( this.OnSuccess , 1 , null ) ;
            return ( (T) result ) ;
        }
        catch ( System.Exception err )
        {
            throw ( this.WrapException
            (
                "ExecuteScalar"
            ,
                this.command
            ,
                err
            ) ) ;
        }
        finally
        {
            this.OpenCount-- ;
        }
    }
}