Query to fetch multiple files using Provider=Microsoft.Jet.OLEDB

Query to fetch multiple files using Provider=Microsoft.Jet.OLEDB

 

 

SELECT COLUMN_NAMES
FROM (TABLE_1 C LEFT OUTER JOIN TABLE_2 A ON C.ACCOUNTNUMBER = A.ACCOUNTNUMBER)
LEFT OUTER JOIN TABLE_3] T ON T.ACCOUNTNUMBER = C.ACCOUNTNUMBER

Browser's Default Email Client with a Simple Hack

Browser’s Default Email Client with a Simple Hack

Sick of mailto: links in your browser opening Outlook or Mail.app whenever you click them? You can tackle this problem with extensions or through other means, but Googler and HTML5 guru Paul Irish offers a simple, no-add-ons-required approach. Here's how it works:

1. Open Gmail in Chrome.
2. Press Ctrl+Shift+J (Windows) or Cmd+Opt+J (Mac) to open Chrome's built-in JavaScript console.
3. Paste the following into the console and press Enter:

 

4. navigator.registerProtocolHandler("mailto",

                                  "https://mail.google.com/mail/?extsrc=mailto&url=%s",

                                  "Gmail");

 

5. Chrome will prompt you, asking if you'd like to "Allow Gmail (mail.google.com) to open all email links?" Click the Use Gmail button.
6. That's it!

 

Compare 32 and 64 bit processor | 32 bit vs 64 bit processor

Compare 32 and 64 bit processor | 32 bit vs 64 bit processor

Today’s computer comes with either 32 bit or 64 bit processors. The difference between the two is the amount of information it can handle at any particular time. While a 64 bit processor can handle more data, it requires changes in the design of software to utilize it full capability.

A bit is a short form for ‘binary digit’. This is how a computer stores, processes, computes and accesses the data. A single bit can have a value of either 1 or 0. Data in a computer is a stream of 1’s and 0’s like this random number 100100100101110. A 32-bit processor can process 32 digits at a time whereas a 64 bit can theoretically process 64 bits. This means the processor can easily handle large data (numbers) and can be more efficient and faster while handling smaller data. But it is commonly confused with memory, it is the amount of information that can be stored without accessing the disk.

Software for a 64 bit processor has to be specifically designed to match that processor. This is why; software designed for 32 bit processor will not work properly in a 64 bit environment.

There are also significant mathematical limits between the two. A 64-bit processor could theoretically work with 1 terabyte (1000GB) of memory. On the other hand, 32-bit processor can handle a maximum of 4GB of memory, depending on how much your motherboard can support.

So, what does it mean for the average Joe?

Even though a 64 bit processor is capable of doing computation at a faster rate, there are not many software’s available to utilize its capability. But memory limitation of 32 bit processor is being exposed by high definition games. For this reason 64 bit processors are likely to become more popular.

Windows vista and windows 7 comes with both 32 and 64 bit versions. 64 bit version of windows can run some software designed for 32 bit version in compatibility mode, not always producing the same result. For now, 64 bit versions are used by large corporations requiring high computational capability. It will take some time before it penetrates every household and that time is not long.

Difference between 32 bit and 64 bit processor

• 64 bit processor can handle twice the amount of data compared to 32 bit processor.
• 32 bit processor can process 32 digits at a time whereas 64 bit can handle 64 digits.
• 32 bit processor can handle maximum of 4 gb of memory, 64 bit can handle up to 1 terabyte.
• A software made for 32 bit processor may not work properly in 64 bit environment.

Apply Distinct on Datatable

 

DataView view = new DataView(table);
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...);

 

winscp.exe COPIES FILES FROM UNIX TO WINDOWS

 

set LOGINAS=username:password@host

 

set SOURCE_PATH=/local/home

set DEST_PATH=d:\Test\

set SCRIPT_FILE=script.txt

 

set _Date=%date%

 

If "%_Date%A" LSS "A" (Set _NumTok=1-3) Else (Set _NumTok=2-4)

:: Default Delimiter of TAB and Space are used

For /F "TOKENS=2*" %%A In ('REG QUERY "HKCU\Control Panel\International" /v iDate') Do Set _iDate=%%B

For /F "TOKENS=2*" %%A In ('REG QUERY "HKCU\Control Panel\International" /v sDate') Do Set _sDate=%%B

IF %_iDate%==0 For /F "TOKENS=%_NumTok% DELIMS=%_sDate% " %%B In ("%_Date%") Do Set _fdate=%%D%%B%%C

IF %_iDate%==1 For /F "TOKENS=%_NumTok% DELIMS=%_sDate% " %%B In ("%_Date%") Do Set _fdate=%%D%%C%%B

IF %_iDate%==2 For /F "TOKENS=%_NumTok% DELIMS=%_sDate% " %%B In ("%_Date%") Do Set _fdate=%%B%%C%%D

Set _Today=%_fdate:~0,4%%_fdate:~4,2%%_fdate:~6,2%

 

set COPYFILE_1_PATRN=A1_TEST_%_Today%.txt

set COPYFILE_2_PATRN=B1_TEST_%_Today%.txt

 

Echo option batch abort>>%SCRIPT_FILE%

Echo option confirm off>>%SCRIPT_FILE%

Echo open %LOGINAS%>>%SCRIPT_FILE%

Echo cd %SOURCE_PATH%>>%SCRIPT_FILE%

Echo option transfer binary>>%SCRIPT_FILE%

Echo get %COPYFILE_1_PATRN% %DEST_PATH%>>%SCRIPT_FILE%

Echo get %COPYFILE_2_PATRN% %DEST_PATH%>>%SCRIPT_FILE%

Echo close>>%SCRIPT_FILE%

Echo exit>>%SCRIPT_FILE%

 

 

"C:\Program Files\WinSCP\winscp.exe" /console /script=%SCRIPT_FILE%

DEL %SCRIPT_FILE%

PAUSE

 

 

value from the enum ?

Question:

      Is there any way that I can access the assigned value from the enum?

 

                Eg: When my item is Red then I want get the corresponding value That’s ‘R’. Is that possible?

public enum Color

      {

          Red = 'R',

          Blue = 'B',

          Green ='G',

          Yellow ='Y',

          White = 'W'

      }

 

Answer:

 

Yes by this way –

 

    class Program

    {

        static void Main(string[] args)

        {

            Console.WriteLine((char)Color.Red);

        }

    }

 

    public enum Color

      {

          Red = 'R',

          Blue = 'B',

          Green ='G',

          Yellow ='Y',

          White = 'W'

      }

 

Tracking CPU and Memory usage per process

Just type perfmon into Start > Run and press enter. When the Performance window is open, click on the + sign to add new counters to the graph. The counters are different aspects of how your PC works and are grouped by similarity into groups called "Performance Object".

 

For your questions, you can choose the "Process", "Memory" and "Processor" performance objects. You then can see these counters in real time

 

You can also specify the utility to save the performance data for your inspection later. To do this, select "Performance Logs and Alerts" in the left-hand panel. (It's right under the System Monitor console which provides us with the above mentioned counters. If it is not there, click "File" > "Add/remove snap-in", click Add and select "Performance Logs and Alerts" in the list".) From the "Performance Logs and Alerts", create a new monitoring configuration under "Counter Logs". Then you can add the counters, specify the sampling rate, the log format (binary or plain text) and log location.

 

 

For more information follow this link.

 

http://stackoverflow.com/questions/69332/tracking-cpu-and-memory-usage-per-process