Visual Basic

waner michaud wrote:

Visual Studio 2005 and Sql Express

I are Troll

waner michaud wrote:

The article is bit convoluted, with my very litle experience in sp..

waner michaud wrote:

I do not like to waste valuable in something I am not good at..

waner michaud wrote:

Briefly, my cenario is as such, Open a connection, select OfficerTable from the source, send it to destination database which was the original point of initiating the connection to modify OfficerTable in destination.

I are Troll

waner michaud wrote:

Must I create a sp for delete, insert, and update that reside in the database for the destination table and as well in the source database?

I are Troll

waner michaud wrote:

Ok. since I need the destination table for search only. Can I just simply alter the destiantion table?

CREATE VIEW [destinationDb].[dbo].[RemoteOrders]
AS 
    SELECT *
      FROM [sourceDb].[dbo].[Orders]

I are Troll

waner michaud wrote:

Which way to go and how?

I are Troll

private static uint[] CRCtable={
				   0x00000000, 0x1db71064, 0x3b6e20c8, 0x26d930ac,
				   0x76dc4190, 0x6b6b51f4, 0x4db26158, 0x5005713c,
				   0xedb88320, 0xf00f9344, 0xd6d6a3e8, 0xcb61b38c,
				   0x9b64c2b0, 0x86d3d2d4, 0xa00ae278, 0xbdbdf21c};

                // this method is pseudo-code only!
		public static uint CalcCRC(string fileName) {
			uint CRC=0;
                        open the file
			byte[] buf=new byte[0x10000];
			for(;;) {
				int count=readBinaryDataFromFileReturningCount(file, buf);
				if (count<=0) break;
				CRC=updateCRC(CRC,buf,count);
			}
			close the file
			return CRC;
		}

                // this is the tricky part:
		private static uint updateCRC(uint CRC, byte[] buf, int count) {
			CRC=~CRC;
			for (int i=0; i< count; i++) {
				byte chr=buf[i];
				uint index=(CRC^chr)&0x0F;
				CRC=(CRC>>4)^CRCtable[index];
				chr>>=4;
				index=(CRC^chr)&0x0F;
				CRC=(CRC>>4)^CRCtable[index];
			}
			return ~CRC;
		}