VB6 Crashed when insert Crystal Report 8.5 in Windows 7 Error Code: C0000005.

Crystal Report 8.5

VB6: "Visual basic has stopped working"

I had been facing the same issue since long, and due to this i was not able to upgrade my laptop to Win7 or 8, finally i resolved the issue, 

1. just go to the Root Directory where VB6 id installed, 
2. select properties, and in compatibility tab select "Run this program in compatibility mode (Windows 7)
3. Run this program as an administrator

PIVOT and UNPIVOT SQL

PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted in the final output.

UNPIVOT performs the opposite operation to PIVOT by rotating columns of a table-valued expression into column values.

The following is annotated syntax for PIVOT.

SELECT <non-pivoted column>,

    [first pivoted column] AS <column name>,

    [second pivoted column] AS <column name>,

    ...

    [last pivoted column] AS <column name>

FROM

    (<SELECT query that produces the data>)

    AS <alias for the source query>

PIVOT

(

    <aggregation function>(<column being aggregated>)

FOR

[<column that contains the values that will become column headers>]

    IN ( [first pivoted column], [second pivoted column],

    ... [last pivoted column])

) AS <alias for the pivot table>

<optional ORDER BY clause>;

Example 

Here is the result set.

DaysToManufacture          AverageCost

0                          5.0885

1                          223.88

2                          359.1082

4                          949.4105

-- Pivot table with one row and five columns
SELECT 'AverageCost' AS Cost_Sorted_By_Production_Days, 
[0], [1], [2], [3], [4]
FROM
(SELECT DaysToManufacture, StandardCost 
    FROM Production.Product) AS SourceTable
PIVOT
(
AVG(StandardCost)
FOR DaysToManufacture IN ([0], [1], [2], [3], [4])
) AS PivotTable;

Here is the result set.

Cost_Sorted_By_Production_Days    0         1         2           3       4       

AverageCost                       5.0885    223.88    359.1082    NULL    949.4105

Shorting Data Table in C#

dtViewState.DefaultView.Sort = "Column_Name Desc/Asc"
dtViewState = dtViewState.DefaultView.ToTable();

Check SQL connectivity from your Client machine to others

A simple test method for SQL connectivity is to create an empty text file, with a file extension of "UDL". You can create it in Notepad. And it can have any name. I use "TestSQL.UDL"

Save it on the desktop of a windows PC and double click it.

A "Data Link Properties" dialog box will pop up where you can enter the IP address of the SQL server and also a SQL username and password.

Click the "Test Connection" button to see if you can connect.

Add Delay (wait) between two SQL statements

SELECT GETDATE() CurrentTime --First Statement
WAITFOR DELAY '00:00:05' ---- 5 Second Delay
SELECT GETDATE() CurrentTime -- Second Statement

Print India Map in C# Console Window.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace IndiaMap
{
    class Program
    {
        static void Main(string[] args)
        {
            int[] data = {20,6,74,10,71,15,67,14,64,15,66,12,68,12,70,12,68,8,72,10,69,14,64,16,63,16,34,
                           5,23,19,31,10,19,23,17,1,9,10,15,30,14,2,5,12,16,37,8,2,6,8,20,61,20,46,1,12,
                            22,44,2,12,15,6,1,43,8,6,15,53,6,5,20,48,8,3,19,52,8,1,21,6,1,39,35,5,1,37,44,
                            35,44,35,46,30,50,30,50,28,52,26,54,25,56,24,57,20,60,19,62,16,65,16,64,15,66,
                            14,67,12,68,12,68,12,70,8,72,6,75,4,52,0
                         };
            int c = 0;
            int linecount = 0;
            for (int b = 0; data[b]  != 0; b++)
            {
                for (int a = data[b]; a >0; a--)
                {
                    c++;
                    if (c==80)
                    {
                        c = 0;
                        Console.WriteLine();
                        linecount++;
                    }
                    else if (b%2==0)
                    {
                        Console.Write(" ");
                    }
                    else
                    {
                        if (linecount<16)
                        {
                            Console.ForegroundColor = ConsoleColor.Red;
                            Console.Write("!");
                        }
                        else if (linecount>15 && linecount<31)
                        {
                            Console.ForegroundColor = ConsoleColor.White;
                            Console.Write("!");
                        }
                        else
                        {
                            Console.ForegroundColor = ConsoleColor.Green;
                            Console.Write("!");
                        }
                       
                    }
                }
            }
            Console.WriteLine();
            Console.CursorSize = 15;
            Console.WriteLine("I Love My India - Chandra Kant Hatwal");
            Console.Read();
        }
    }
}

Out Put

C program to print map of India.

#include  <stdio.h>

void main()
{
    char data[]={20,6,74,10,71,15,67,14,64,15,66,12,68,12,70,12,68,8,72,10,69,14,64,16,63,16,34,
5,23,19,31,10,19,23,17,1,9,10,15,30,14,2,5,12,16,37,8,2,6,8,20,61,20,46,1,12,
22,44,2,12,15,6,1,43,8,6,15,53,6,5,20,48,8,3,19,52,8,1,21,6,1,39,35,5,1,37,44,
35,44,35,46,30,50,30,50,28,52,26,54,25,56,24,57,20,60,19,62,16,65,16,64,15,66,
14,67,12,68,12,68,12,70,8,72,6,75,4,52,0};
   
    int a,b,c=0;
   
    for (b=0; data[b] != 0; b++)
    {
       for(a = data[b]; a > 0 ; a--)
       {
           c++;
           if (c == 80)
           {
               c = 0;
               putchar('\n');
           }
           else if (b%2 == 0)
           {
               putchar(' ');
           }
           else
           {
               putchar('!');
           }
       }
    }
}

o/p