Windows Forms

public static void dgCellFormat(object sender, DataGridViewCellFormattingEventArgs e)
{
    DataGridViewColumn oCol = (sender as DataGridView).Columns[e.ColumnIndex];
    string vt = oCol.ValueType.ToString().ToLower();
    switch (vt)
    {
        case "system.int32":
        case "system.int16":
        case "system.int64":
            e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
            //if the right 2 characters are not ID then add , to the value
            if (!oCol.HeaderText.EndsWith("ID"))
            {
                e.CellStyle.Format = "#,#";
            }
            break;
        case "system.decimal":
            e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
            //if the right 2 characters are not ID then add , to the value
            if (!oCol.HeaderText.EndsWith("ID"))
            {
                e.CellStyle.Format = "#,#.00";
            }
            break;
        case "system.datetime":
            e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
            break;
    }
}

#Region "1).Declarations"
Dim con As SqlConnection
end region