C#

SELECT NULLIF(ColumnName, DefaultValueIfNull), ...

<pre>  for (int j = 0; j <= rows - 1; j++)
                    {
                        var rowItem = dt.Rows[j].ItemArray;
                        for (int k = 0; k <= rowItem.Length - 1; k++)
                        {
                            if (String.IsNullOrEmpty(rowItem[k].ToString()))
                                allRecords[j + 1, k] = string.Empty;
                            else
                            allRecords[j + 1, k] = rowItem[k];
                        }
                    }

class Program
    {
        static void Main(string[] args) //<< this is a function, the main entry point when you run the program
        {
            decimal[] values = new decimal[] { 1, 2, 3, 4, 5 };
            decimal result = MeanAvg(values);//<< Calls a function and pass a value
        }

        static decimal MeanAvg(decimal[] values) //<< This is a function that accepts input as a paramter and retuns a value
        {
            decimal result = 0;
            //to do calculation

            return result; //returns the final result that will later on will be use from the caller
        }
    }

static void Main()
{
    double answer = MeanAvg(1,2,3,4,5);
    double answer2 = MeanAvg(1,2,3,4,5,6,7,8,9,10);
}

static double MeanAvg(params int [] values)
{
   double total = values.Average();
}

private static double MeanAvg(params object[] values) 
{
    return Convert.ToDouble(values.Select(Convert.ToDecimal).Average());
}

double answer = MeanAvg(1M,3,3d);
answer = MeanAvg(1M,3M,"3");

double answer = MeanAvg(1M,3M,"abc");

BillWoodruff wrote:

If we provide code to people that helps them avoid/shirk their homework, we are degrading the educational process, and contributing to the OP's failure to learn and grow: we are fostering dependency and laziness.

John Simmons / outlaw programmer wrote:

Down-voting CORRECT answers is bullsh|t, Bill

John Simmons / outlaw programmer wrote:

Should we get your approval before answering questions from now on?