CDRoller - CD / DVD / BD / HD-DVD / Flash data recovery software. Download page

Q: I often get probs with the DVD-R disks I use in a sony camcorder dcr-dvd91, usually before finalising. Can your software recover data from these?
A: CDRoller is able to recover the video files (VOB files) from mini DVD-R/RW discs created by Sony DVD Camcorders. In order to read the "troubled" or non-finalized DVD discs, you should use the computer DVD-RW drive (dvd writer) instead of DVD-ROM drive (dvd reader). At first, we recommend to use Recover DVD Video option from the File Menu and follow the displayed instructions "step by step". Also, you can follow the instructions from the chapter 6.10 in User's Manual or Help File, trying some options from the forced scan list. To convert the recovered VOB files into MPEG ones, you can use Split Vdeo option. Further, just load MPEG files into your DVD mastering software and create a new DVD with recovered video.

CDRoller - CD / DVD / BD / HD-DVD / Flash data recovery software. Download page

 

Source : http://forums.afterdawn.com/thread_view.cfm/454076

Memorable quotes for Up in the Air (2009)

Ryan Bingham: How much does your life weigh? Imagine for a second that you're carrying a backpack. I want you to pack it with all the stuff that you have in your life... you start with the little things. The shelves, the drawers, the knickknacks, then you start adding larger stuff. Clothes, tabletop appliances, lamps, your TV... the backpack should be getting pretty heavy now. You go bigger. Your couch, your car, your home... I want you to stuff it all into that backpack. Now I want you to fill it with people. Start with casual acquaintances, friends of friends, folks around the office... and then you move into the people you trust with your most intimate secrets. Your brothers, your sisters, your children, your parents and finally your husband, your wife, your boyfriend, your girlfriend. You get them into that backpack, feel the weight of that bag. Make no mistake your relationships are the heaviest components in your life. All those negotiations and arguments and secrets, the compromises. The slower we move the faster we die. Make no mistake, moving is living. Some animals were meant to carry each other to live symbiotically over a lifetime. Star crossed lovers, monogamous swans. We are not swans. We are sharks.

Source : http://www.imdb.com/title/tt1193138/quotes

AutoComplete TextBox or ComboBox in Winforms using C#

AutoComplete TextBox or ComboBox in Winforms

In my previous article Implementing autocomplete textbox in gridview using Ajax autocomplete extender i explained how to create AutoComplete TextBox in ASP .NET using AJAX , in this example i am achieving the same in Windows forms application


For this i've created a database with a table containing names which will be shown in textbox as suggestions, for this we need to create a AutoCompleteStringCollection and then add the records in this collection using datareader to fetch records from database

Properties of TextBox that needs to be set

For autocomplete functionalty to work we need to define these 3 properties of textbox




1. AutoCompleteMode - we can choose either suggest or appned or suggestappend as names are self explanatory




2. AutoCompleteSource - this needs to be set as Custom Source




3. AutoCompleteCustomSource - this is the collection we created earlier

C# Code

The complete C# code will look like this

namespace AutoCompleteTextBox

{

    

    public partial class frmAuto : Form

    {

        public string strConnection = ConfigurationManager.AppSettings["ConnString"];

        AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();

        public frmAuto()

        {

            InitializeComponent();

        }



        private void frmAuto_Load(object sender, EventArgs e)

        {

            SqlDataReader dReader;

            SqlConnection conn = new SqlConnection();

            conn.ConnectionString = strConnection;

            SqlCommand cmd = new SqlCommand();

            cmd.Connection = conn;

            cmd.CommandType = CommandType.Text;

            cmd.CommandText = "Select distinct [Name] from [Names] order by [Name] asc";

            conn.Open();

            dReader = cmd.ExecuteReader();

            if (dReader.HasRows == true)

            {

                while (dReader.Read())

                    namesCollection.Add(dReader["Name"].ToString());



            }

            else

            {

                MessageBox.Show("Data not found");

            }

            dReader.Close();



            txtName.AutoCompleteMode = AutoCompleteMode.Suggest;

            txtName.AutoCompleteSource = AutoCompleteSource.CustomSource;

            txtName.AutoCompleteCustomSource = namesCollection;

            

        }



        private void btnCancel_Click(object sender, EventArgs e)

        {

            Application.Exit();

        }



        private void btnOk_Click(object sender, EventArgs e)

        {

            MessageBox.Show("Hope you like this example");

        }



    }

}

In the similar way we can also create a autocomplete type combobox




Source : http://www.dotnetfunda.com/articles/article225.aspx

leech

http://rapid8.com/


http://leechdl.com/


http://sv1.leech.vumanhthang.com/index.php


http://sv2.leech.vumanhthang.com/index.php


http://sv3.leech.vumanhthang.com/index.php


http://sv4.leech.vumanhthang.com/index.php


http://sv5.leech.vumanhthang.com/index.php


http://sv6.leech.vumanhthang.com/index.php


http://sv7.leech.vumanhthang.com/index.php


http://sv8.leech.vumanhthang.com/index.php




untuk yang vumanhthang, trik ini juga bisa


digunakan untuk download cepat dari ziddu


menggunakan leecher.

Batere direfill

Batere laptop di-refill?



Sekarang bukan hanya tinta printer yang bisa di-refill ulang (diisi ulang) tapi batere laptop pun dapat diisi ulang. Karena mahalnya batere baru laptop maka ada cara untuk menyelamatkan batere kita yang soak. Bayangkan jika kita harus membeli batere baru yang harganya dari 900ribu sampai 1,2juta-an, tentu berat bukan? Untuk mengakalinya adalah dengan cara refill. Harga me-refill bisa sampai sepertiga dari harga baru, tentunya menghemat kocek kantong kita. Dan tentunya kualitas dari refill-an tidak kalah dengan batere baru.




Apa itu refill batere ?


Refill batere adalah memperbaiki batere dengan cara mengganti cell/isi batere laptop yang lama dengan cell yang baru, tentunya dengan cara membongkarnya. Tidak semua batere laptop dapat di-refill, biasanya jika board circuit baterenya rusak maka refill tdk dpt dilakukan. Cell-cell batere laptop atau ponsel biasanya berupa lithium-ion, nah ini yg akan diganti. Cell yg sudah mati akan dibuang dan akan diganti oleh cell yang baru.




Berapa jumlah cell batere laptop kita ???


- setiap laptop biasanya ditawarkan jumlah cell yang berbeda kecuali batere Apple Mac yg rata2 sama. Ada 4 cell, 8 Cell, 9 Cell, 12 Cell, dan seterusnya. Semakin banyak cell maka akan semakin lama daya tahan memberikan supply daya listriknya ke laptop kita.. Dan laptop Apple Mac rata berjumlah 12 cell..




Ciri-ciri batere yg msh dapt di-refill :

• batere anda msh bisa bertahan beberapa menit;


• board circuit tidak rusak, cara mengetahui circuit tidak rusak adalah bila saat kita men-charge batere maka lampu indikator masih menyala (indikator kuning, orange, hijau). Jika sama sekali tdk menyala brrti tdk dpt di-refill.


• cell batere lithium-ion laptop kita mudah di pasaran, sebb ada beberapa cell yg khusus dan susah mencari sparepart cell nya di Indonesia.

Kerugian refill :

• batere tidak original sbb dibongkar dan diganti isi cell dalam batere


• jika refill tdk berhasil dilakukan (jarang terjadi) maka batere akan rusak permanen


• ada kasus walau jarang, indikator batere dilaptop tidak berfungsi seperti biasanya. Ini biasanya circuit rusak.

Keuntungan refill:

• batere akan kembali normal walau tidak 100% sperti baru


• menghemat biaya jika harus membeli batere baru


• jika batere belum dan jarang di pasaran maka akan membantu sekali utk memulihkan fungsi baterenya.

digudang betere jg bisa :




akarta :


Dani di Wasabi : 08170811311


Nanda: 08121090706


Cak Uding: 081510000108


Achobule: 08568016054




di daerah Jakarta Kota dan sekitarnya:


Indarmin: 08128597755




www.gudangbatere.com




atau




www.jakartanotebook.com




atau di




mangga dua mall dan roxy mangga 2... tapi lupa lantai berapa

source : http://www.macclubindonesia.com/forums/showthread.php?t=25619

DOS Batch - FTP Scripts

File Transfer with FTP, One-File Solutions.

Classic FTP	Executing a FTP script.
FTP - Simple Single Batch	FTP script and batch in a single file.
FTP - Automatic Login	Automatically login to your FTP session with a single click.
FTP Scripts Sharing Login Info	Manage the FTP login separately from your FTP scripts.
FTP - Resolving Environment Variables	Creating FTP script on the fly at runtime and using variables within the FTP script.
FTP - Download Only New Files	Ftp script to download only files that don`t exist in local folder, i.e. to avoid overwrite
FTP - Upload Only New Files	Ftp script to upload only files that don`t exist in remote folder, i.e. incremental upload.

---

TOP


2008-01-01

Classic FTP - Executing a FTP script

Description:	The FTP command support the "-s:ftpscript.txt" option. The FTP commands listed in ftpscript.txt will automatically run after FTP starts. The FTP command can be started from a batch file. Example: FTP -v -i -s:ftpscript.txt See also command line help: "C:>ftp -?"
Script:	1. 2. 3. 4. 5. 6. 7. 8. 9. 10. open example.com username password !:--- FTP commands below here --- lcd c:\MyLocalDirectory cd public_html/MyRemoteDirectory binary mput "*.*" disconnect bye
Script Output:	Script Ouput ftp> open example.com User (Username:(none)): ftp> !:--- FTP commands below here --- ftp> lcd c:\MyLocalDirectory Local directory now c:\MyLocalDirectory. ftp> cd public_html/MyRemoteDirectory ftp> binary ftp> !: mput "*.*" ftp> disconnect ftp> bye

---

TOP


2008-01-01

FTP - Simple Single Batch - FTP script and batch in a single file

Description:	Embed FTP script into a batch script. Add this line at the beginning of the FTP script: @ftp -i -s:"%~f0"&GOTO:EOF The "FTP -s:ftpscript.txt" option executes a FTP script wheres "%~f0" resolved to the name of the running batch file. "GOTO:EOF" ends the batch script and makes sure the FTP script doesn`t run as part of the batch. Good: You end up with only one file that contains the batch script and the FTP script combined. Minor flaw: The batch command in the first line causes an "Invalid command." error when executed in FTP context, however the FTP execution will continue. Features: Single file to distribute combining batch and FTP script
Script:	1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. @ftp -i -s:"%~f0"&GOTO:EOF open example.com username password !:--- FTP commands below here --- lcd c:\MyLocalDirectory cd public_html/MyRemoteDirectory binary mput "*.*" disconnect bye
Script Output:	Script Ouput ftp> @ftp -i -s:"%~f0"&GOTO:EOF Invalid command. ftp> open example.com User (Username:(none)): ftp> !:--- FTP commands below here --- ftp> lcd c:\MyLocalDirectory Local directory now c:\MyLocalDirectory. ftp> cd public_html/MyRemoteDirectory ftp> binary ftp> !: mput "*.*" ftp> disconnect ftp> bye

---

TOP


2009-12-06

FTP - Automatic Login - Automatically login to your FTP session with a single click

Description:	If you frequently find yourself calling FTP from the command line, each time having to login and change directory and change FTP modes, until you finally get where you want be in order to do some real work then you may wish to get there with a singe click. This little batch can connect to your FTP server and logs you in before it gives you the prompt. You can easily add more FTP commands to it, like changing directories or switching to binary mode or whatever you like to be done before taking over control on the FTP prompt. The FTP connection information is embedded within the batch itself. The batch connects to an FTP server by executing itself in FTP context using the FTP -s option. Once executing in FTP context it executes all FTP commands listed in the file. By omitting the final FTP "bye" command it will stop at the FTP prompt and wait for user input. Optionally a FTP script can be provided as input stream, that way multiple FTP scripts can share the same login information. Example: FtpLogin.bat <script1.ftp
Script:	Download: FtpLogin.bat 1. 2. 3. 4. 5. @ftp -i -s:"%~f0"&GOTO:EOF open example.com username password pwd
Script Output:	Script Ouput ftp> @ftp -i -s:"%~f0"&GOTO:EOF Invalid command. ftp> open example.com Connected to example.com. 220- 220 FTP Server ready User (example.com:(none)): 331 Password required 230 User logged in ftp> pwd 257 "/" is the current directory ftp>

---

TOP


2009-12-06

FTP Scripts Sharing Login Info - Manage the FTP login separately from your FTP scripts

Description:

If you have multiple FTP scripts that all use the same login information to your FTP site then you may wish to manage the login information separately from your FTP scripts in a single place. That way if the username, password or hostname for the FTP connection changes you only need to edit a single place instead of having to edit all FTP scripts one by one. This automatic login script (also described in detail earlier) can be used to execute different FTP scripts that share the same login information stored within the batch file. Example: FtpLogin.bat script1.ftp Note: The FTP scripts passed into the batch must have the login sequence removed. Note: The FTP script executes even if the connection sequence fails potentially causing `Not connected` and other errors. This is no different from regularly executing FTP with -s option.

Script:

Download: FtpLoginSharing.bat 1. 2. 3. 4. @type %1|ftp -i -s:"%~f0"&GOTO:EOF open example.com username password

---

TOP


2008-10-17

FTP - Resolving Environment Variables - Creating FTP script on the fly at runtime and using variables within the FTP script

Description:

This batch executed the FTP script embedded within the batch. All variables in the FTP script will be resolved. The FOR loop extracts the FTP script into a temporary file. It the ECHO command is being CALLed for each line in order to resolve the variables. Variables can be used within the FTP script the same way as in a batch script, including any string manipulation and command line arguments like %1 %2 %~n0 %* and so on. All batch lines start with semicolon so that they will be ignored by the FOR loop. Semicolon is the default end-of-line (EOL) character used by the FOR command.

Script:

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. ;@echo off ;(for /f "usebackq delims=" %%A in ("%~f0") do call echo.%%A)>"%temp%\%~n0.ftp" ;ftp -i -s:"%temp%\%~n0.ftp" ;GOTO:EOF open example.com username password !:--- FTP commands below here --- cd public_html/%COMPUTERNAME% binary hash on %* disconnect bye

---

TOP


2010-02-05

FTP - Download Only New Files - Ftp script to download only files that don`t exist in local folder, i.e. to avoid overwrite

Description:

This batch connects twice to the FTP server. First time it retrieves a list of files on the FTP server. This list is being trimmed to contain only files that don`t already exist locally. The files in the trimmed list are then downloaded during a second connection. Note: Since all files are passed into the FTP`s MGET command there might be a limit to the number of files that can be processed at once.

Script:

Download: BatchFtpDownloadOnlyNewFiles.bat 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 43. 44. 45. 46. 47. 48. 49. 50. 51. 52. 53. 54. 55. 56. 57. 58. 59. 60. 61. 62. 63. 64. 65. 66. 67. 68. 69. 70. @Echo Off REM -- Define File Filter, i.e. files with extension .txt Set FindStrArgs=/E /C:".txt" REM -- Extract Ftp Script to create List of Files Set "FtpCommand=ls" Call:extractFileSection "[Ftp Script 1]" "-">"%temp%\%~n0.ftp" Rem Notepad "%temp%\%~n0.ftp" REM -- Execute Ftp Script, collect File Names Set "FileList=" For /F "Delims=" %%A In ('"Ftp -v -i -s:"%temp%\%~n0.ftp"|Findstr %FindStrArgs%"') Do ( Call Set "FileList=%%FileList%% "%%A"" ) REM -- Extract Ftp Script to download files that don't exist in local folder Set "FtpCommand=mget" For %%A In (%FileList%) Do If Not Exist "%%~A" Call Set "FtpCommand=%%FtpCommand%% "%%~A"" Call:extractFileSection "[Ftp Script 1]" "-">"%temp%\%~n0.ftp" Rem Notepad "%temp%\%~n0.ftp" For %%A In (%FtpCommand%) Do Echo.%%A REM -- Execute Ftp Script, download files ftp -i -s:"%temp%\%~n0.ftp" Del "%temp%\%~n0.ftp" GOTO:EOF :extractFileSection StartMark EndMark FileName -- extract a section of file that is defined by a start and end mark :: -- [IN] StartMark - start mark, use '...:S' mark to allow variable substitution :: -- [IN,OPT] EndMark - optional end mark, default is first empty line :: -- [IN,OPT] FileName - optional source file, default is THIS file :$created 20080219 :$changed 20100205 :$categories ReadFile :$source http://www.dostips.com SETLOCAL Disabledelayedexpansion set "bmk=%~1" set "emk=%~2" set "src=%~3" set "bExtr=" set "bSubs=" if "%src%"=="" set src=%~f0& rem if no source file then assume THIS file for /f "tokens=1,* delims=]" %%A in ('find /n /v "" "%src%"') do ( if /i "%%B"=="%emk%" set "bExtr="&set "bSubs=" if defined bExtr if defined bSubs (call echo.%%B) ELSE (echo.%%B) if /i "%%B"=="%bmk%" set "bExtr=Y" if /i "%%B"=="%bmk%:S" set "bExtr=Y"&set "bSubs=Y" ) EXIT /b [Ftp Script 1]:S !Title Connecting... open example.com username password !Title Preparing... cd public_html/MyRemoteDirectory lcd c:\MyLocalDirectory binary hash !Title Processing... %FtpCommand% %FtpCommand% !Title Disconnecting... disconnect bye

---

TOP


2010-02-05

FTP - Upload Only New Files - Ftp script to upload only files that don`t exist in remote folder, i.e. incremental upload

Description:

This batch connects twice to the FTP server. First time it retrieves a list of files on the FTP server. Local files that are are not in this list will then be uploaded during a second connection. Note: Since all files are passed into the FTP`s MPUT command there might be a limit to the number of files that can be processed at once.

Script:

Download: BatchFtpUploadOnlyNewFiles.bat 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 43. 44. 45. 46. 47. 48. 49. 50. 51. 52. 53. 54. 55. 56. 57. 58. 59. 60. 61. 62. 63. 64. 65. 66. 67. 68. 69. 70. 71. 72. 73. 74. @Echo Off Setlocal Enabledelayedexpansion REM -- Define File Filter, i.e. files with extension .txt Set FindStrArgs=/E /C:".txt" REM -- Extract Ftp Script to create List of Files Set "FtpCommand=ls" Call:extractFileSection "[Ftp Script 1]" "-">"%temp%\%~n0.ftp" Rem Notepad "%temp%\%~n0.ftp" REM -- Execute Ftp Script, collect File Names Set "FileList=" For /F "Delims=" %%A In ('"Ftp -v -i -s:"%temp%\%~n0.ftp"|Findstr %FindStrArgs%"') Do ( Call Set "FileList=%%FileList%% "%%A"" ) REM -- Extract Ftp Script to upload files that don't exist in remote folder Set "FtpCommand=mput" For %%A In (%FileList%) Do set "Exist["%%~A"]=Y" For /F "Delims=" %%A In ('"dir /b "%localdir%"|Findstr %FindStrArgs%"') Do ( If Not defined Exist["%%~A"] Call Set "FtpCommand=%%FtpCommand%% "%%~A"" ) Call:extractFileSection "[Ftp Script 1]" "-">"%temp%\%~n0.ftp" rem Notepad "%temp%\%~n0.ftp" For %%A In (%FtpCommand%) Do Echo.%%A REM -- Execute Ftp Script, download files ftp -i -s:"%temp%\%~n0.ftp" Del "%temp%\%~n0.ftp" GOTO:EOF :extractFileSection StartMark EndMark FileName -- extract a section of file that is defined by a start and end mark :: -- [IN] StartMark - start mark, use '...:S' mark to allow variable substitution :: -- [IN,OPT] EndMark - optional end mark, default is first empty line :: -- [IN,OPT] FileName - optional source file, default is THIS file :$created 20080219 :$changed 20100205 :$categories ReadFile :$source http://www.dostips.com SETLOCAL Disabledelayedexpansion set "bmk=%~1" set "emk=%~2" set "src=%~3" set "bExtr=" set "bSubs=" if "%src%"=="" set src=%~f0& rem if no source file then assume THIS file for /f "tokens=1,* delims=]" %%A in ('find /n /v "" "%src%"') do ( if /i "%%B"=="%emk%" set "bExtr="&set "bSubs=" if defined bExtr if defined bSubs (call echo.%%B) ELSE (echo.%%B) if /i "%%B"=="%bmk%" set "bExtr=Y" if /i "%%B"=="%bmk%:S" set "bExtr=Y"&set "bSubs=Y" ) EXIT /b [Ftp Script 1]:S !Title Connecting... open example.com username password !Title Preparing... cd public_html/MyRemoteDirectory lcd c:\MyLocalDirectory binary hash !Title Processing... %FtpCommand% %FtpCommand% !Title Disconnecting... disconnect bye

Source : http://www.dostips.com/DtTipsFtpBatchScript.php

Virtual PC/Windows CE Emulator Problem

Consider the following scenario. You install a Microsoft Windows CE emulator, Microsoft eMbedded Visual C++, Microsoft Visual Studio 2003, or Windows CE Platform Builder on a computer that is running Windows XP or Windows XP Service Pack 2 (SP2). The computer has Data Execution Prevention (DEP) hardware. You restart the computer. In this scenario, you receive the following error message:

Virtual PC/Windows CE Emulator

A driver is installed that causes stability problems with your system. This driver will be disabled. Please contact the driver manufacturer for an update that is compatible with this version of Windows.

Solved:
To resolve this problem and to run Window CE 4.x Emulator, disable hardware-based DEP on the computer that is running Windows XP SP2. To do this, follow these steps:
Click Start, click Run, type sysdm.cpl, and then click OK.
In the System Properties dialog box, click the Advanced tab.
Under Start and Recovery, click Settings.
In the Startup and Recovery dialog box, click Edit.
Disable PAE mode by removing the /pae option if it exists.
If you are using Windows XP SP2, remove the /noexecute option if it exists, and then add the /execute option.
On the File menu, click Save.
To exit Notepad, click Exit on the File menu.
To close System Properties, click OK two times.
Restart your computer.

Source : http://support.microsoft.com/kb/891667

Motherboard kena listrik statik

Cape` otak atik Motherboard e.. rupanya listrik statik... ini sering terjadi pada Motherboard Next Group.. Setelah Listrik statik di kosongkan... Motherboard sehat lagi..

Cirinya :
- PowerSupply Hidup
- FAN & Coller Prossessor Hidup
- Led Power Nyala (Warna Hijau) & Led Proses Mati
- No Beep (Tidak ada Bunyi Nuut saat komputer start)

Resolved :
- Konslet-kan aliran listrik Power Suppy (dalam kondisi OFF)
- atau dalam kondisi hidup sepaskan semua koneksi Power Supply kecuali Listrik 220v, Hidupkan Power Supply dengan menghubungkan jumper on-off (kabel warna Hijau dan Hitam). Tes semua tegangan supply pake Multimeter atau Sambungkan ke perangkat lain.

menghilangkan listrik statis -menekan tombol power berulang-ulang setelah pc mati setelah memutus kabel AC

Source :
http://forum.ihsana.com/viewtopic.php?f=5&t=66
http://aldonz.multiply.com/?&preview=&item_id=46&page_start=40
http://ekoprihastopo.blogspot.com/2009/02/dampak-perpindahan-listrik-statis.html

10 skill yg diperlukan IT developer 5 tahun ke depan!

1: One of the “Big Three” (.NET, Java, PHP)

Unless there is a radical shift in the development world (akin to an asteroid hitting Redmond), most developers will need to know at least one of the Big Three development systems — .NET (VB.NET or C#), Java, or PHP — for the near future. It’s not enough to know the core languages, either. As projects encompass more and more disparate functionality, you’ll need to know the associated frameworks and libraries more deeply.

2: Rich Internet Applications (RIAs)

Love it or hate it, in the last few years, Flash is suddenly being used for more than just animations of politicians singing goofy songs. Flash has also sprouted additional functionality in the form or Flex and AIR. Flash’s competitors, such as JavaFx and Silverlight, are also upping the ante on features and performance. To make things even more complicated, HTML 5 is incorporating all sorts of RIA functionality, including database connectivity, and putting the formal W3C stamp on AJAX. In the near future, being an RIA pro will be a key resume differentiator.

3: Web development

Web development is not going away anytime soon. Many developers have been content to lay back and ignore the Web or to just stick to “the basics” their framework provides them with. But companies have been demanding more and more who really know how to work with the underlying technology at a “hand code” level. So bone up on JavaScript, CSS, and HTML to succeed over the next five years.

4: Web services

REST or SOAP? JSON or XML? While the choices and the answers depend on the project, it’s getting increasingly difficult to be a developer (even one not writing Web applications) without consuming or creating a Web service. Even areas that used to be ODBC, COM, or RPC domains are now being transitioned to Web services of some variety. Developers who can’t work with Web services will find themselves relegated to legacy and maintenance roles.

5: Soft skills

One trend that has been going for quite some time is the increasing visibility of IT within and outside the enterprise. Developers are being brought into more and more non-development meetings and processes to provide feedback. For example, the CFO can’t change the accounting rules without working with IT to update the systems. And an operations manager can’t change a call center process without IT updating the CRM workflow. Likewise, customers often need to work directly with the development teams to make sure that their needs are met. Will every developer need to go to Toastmasters or study How to Win Friends and Influence People? No. But the developers who do will be much more valuable to their employers — and highly sought after in the job market.

6: One dynamic and/or functional programming language

Languages like Ruby, Python, F#, and Groovy still aren’t quite mainstream – but the ideas in them are. For example, the LINQ system in Microsoft’s .NET is a direct descendent of functional programming techniques. Both Ruby and Python are becoming hot in some sectors, thanks to the Rails framework and Silverlight, respectively. Learning one of these languages won’t just improve your resume, though; it will expand your horizons. Every top-flight developer I’ve met recommends learning at least one dynamic or functional programming language to learn new ways of thinking, and from personal experience, I can tell you that it works.

7: Agile methodologies

When Agile first hit mainstream awareness, I was a skeptic, along with many other folks I know. It seemed to be some sort of knee-jerk reaction to tradition, throwing away the controls and standards in favor of anarchy. But as time went on, the ideas behind Agile became both better defined and better expressed. Many shops are either adopting Agile or running proof-of-concept experiments with Agile. While Agile is not the ultimate panacea for project failure, it does indeed have a place on many projects. Developers with a proven track record of understanding and succeeding in Agile environments will be in increasingly high demand over the next few years.

8: Domain knowledge

Hand-in-hand with Agile methodologies, development teams are increasingly being viewed as partners in the definition of projects. This means that developers who understand the problem domain are able to contribute to the project in a highly visible, valuable way. With Agile, a developer who can say, “From here, we can also add this functionality fairly easily, and it will get us a lot of value,” or “Gee, that requirement really doesn’t match the usage patterns our logs show” will excel. As much as many developers resist the idea of having to know anything about the problem domain at all, it is undeniable that increasing numbers of organizations prefer (if not require) developers to at least understand the basics.

9: Development “hygiene”

A few years ago, many (if not most) shops did not have access to bug tracking systems, version control, and other such tools; it was just the developers and their IDE of choice. But thanks to the development of new, integrated stacks, like the Microsoft Visual Studio Team System, and the explosion in availability of high quality, open source environments, organizations without these tools are becoming much less common. Developers must know more than just how to check code in and out of source control or how to use the VM system to build test environments. They need to have a rigorous habit of hygiene in place to make sure that they are properly coordinating with their teams. “Code cowboys” who store everything on a personal USB drive, don’t document which changes correspond to which task item, and so on, are unwelcome in more traditional shops and even more unwelcome in Agile environments, which rely on a tight coordination between team members to operate.

10: Mobile development

The late 1990s saw Web development rise to mainstream acceptance and then begin to marginalize traditional desktop applications in many areas. In 2008, mobile development left the launch pad, and over the next five years, it will become increasingly important. There are, of course, different approaches to mobile development: Web applications designed to work on mobile devices, RIAs aimed at that market, and applications that run directly on the devices. Regardless of which of these paths you choose, adding mobile development to your skill set will ensure that you are in demand for the future.

Source:
http://techrepublic.com.com/
http://www.indowebster.web.id/showthread.php?t=55458&pagenumber=

Rayuan Gombal

1. Tadi Malam Aku Kirim Bidadari Untuk Menjaga Tidurmu. Eh, Dia Buru-Buru Balik. Katanya, 'Ah, Masa Bidadari Disuruh Jaga Bidadari?'




2. Kalau Kamu Nanya Berapa Kali Kamu Datang Ke Pikiranku, Jujur Aja, Cuma Sekali. Abisnya, Ga Pergi2 Sih!




3. Sempet Bingung Jg, Kok Aku Bisa Senyum Sendiri. Baru Nyadar, Aku Lagi Mikirin Kamu.




4. Kalau Suatu Saat Kamu Hancurkan Hatiku... Akan Kucintai Kamu Dengan Kepingannya Yang Tersisa.




5. Berusaha Melupakanmu, Sama Sulitnya Dengan Mengingat Seseorang Yang Tak Pernah Kukenal.




6. Kalau Kamu Ajak Aku Melompat Bareng, Aku Ngga Bakalan Mau. Mending Aku Lari Ke Bawah, Bersiap Menangkapmu.




7. Aku Pernah Jatuhkan Setetes Air Mata Di Selat Sunda. Di Hari Aku Bisa Menemukannya Lagi, Itulah Waktunya Aku Berhenti Mencintaimu.




8. Ga Usah Janjiin Bintang Dan Bulan Untuk Aku, Cukup Janjiin Kamu Bakal Selalu Bersamaku Di Bawah Cahayanya.




9. Kalau Kamu Nanya Mana Yg Lebih Penting Buat Aku: Hidupku Atau Hidupmu, Aku Bakal Jawab Hidupku.. Eits, Jangan Marah Dulu, Karena Kamulah Hidupku.




10. Pertama Ketemu, Aku Takut Ngomong Sama Kamu. Pertama Ngomong Sama Kamu, Aku Takut Kalau Nanti Suka Sama Kamu. Udah Suka, Aku Makin Takut Kalau Jatuh Cinta. Setelah Sekarang Cinta Sama Kamu, Aku Jadi Bener2 Takut Kehilangan Kamu. Kamu Emang Menakutkan!




11. Ketika Hidup Memberiku Seratus Alasan Untuk Menangis, Kau Datang Membawa Seribu Alasan Untuk Tersenyum.




12.Jika Aku Bisa Jadi Bagian Dari Dirimu, Aku Mau Jadi Airmatamu, Yang Tersimpan Di Hatimu, Lahir Dari Matamu, Hidup Di Pipimu, Dan Mati Di Bibirmu




13. Orang Bilang Bulan Itu Indah...Tapi Aku Bilang Tidak. Orang Bilang Planet Venus Itu Cantik...Tapi Menurut Aku Tidak. Aku Bilang Bumi Itu Indah Dan Cantik...Karena Ada Kamu.

mysql update from another table

Recently I needed to update a bunch of rows in mysql with information from another table. I will explain how to do this simple process.

1. Open up phpmyadmin or similar database editor


2. view the sql query below

Code (sql)

1. 
   
   
   


2. 
   
   UPDATE updatefrom p, updateto pp
   
   


3. 
   
   SET pp.last_name = p.last_name
   
   


4. 
   
   WHERE pp.visid = p.id
   
   

Lets say we have 2 tables one named main and one named updateto and one named updatefrom, In the first line we assign variables to these t tables (p and pp) from there we can call column names using this format table.columname. If we had first_name and last_name in both tables and wanted to update the "updateto" table with the info from "updatefrom" this is how you would write it.

Source : http://worcesterwideweb.com/2007/07/03/mysql-update-from-another-table/

Buat Webcam Jadi CCTV

Buat Webcam Jadi CCTV

Bahan:


1-Webcam (milik saya sturdy)


2-Kabel utp cat 5, 10 meter (dengan menggunakan kabel usb perpanjangan biasa yang ada dipasaran [biasanya 3 meter seharga 5 rb-an], webcam tidak akan terdeteksi pada PC, karena adanya distorsi)


3-Kipas angin yang dapat geleng-geleng


4-Bekas colokan usb yang "female"


Pada awalnya saya ingin membuat wajan bolik untuk menyedot sinyal hotspot. Saya merancang kabel utp cat 5 produk America sepanjang 10 meter, kemudian saya solder sesuai dengan gambar berikut:














Setelah merakit kabel-kabel tersebut, maka saya mencolokkan kabel utp dengan kabel webcam yang saya beli seharga 50 rb-an. Saya membeli yang merk sturdy 1,3 mega pixel.


Yang menjadi unik dan special dari artikel ini adalah, saya meletakkan webcam tersebut tepat diatas kipas angin maspion yang berputar-putar (geleng-geleng) sehingga jangkauan tangkapan webcam bisa menyapu 180 derajat toko saya.








Laptop saya hubungkan ke sebuah monitor sehingga bisa dilihat (baca: menakut-nakuti) para konsumen yang akan berlaku culas.


Semoga bermanfaat.

source : http://pagesangan.wordpress.com/2010/04/20/buat-webcam-jadi-cctv/

all about ipaq 6365

iPAQ 6365 adalah produk yang menyediakan konektivitas dan mobilitas yang tinggi bagi pada penggunanya.


Dengan fitur2 GSM/GPRS, Bluetooth dan WIFI, pengguna iPAQ 6365 dapat berkomunikasi kapan saja dan di mana saja mereka berada. Download email, browsing internet dapat dilakukan melalui GPRS atau WIFI (jika terdapat hotspot). Transfer file dan data dapat dilakukan melalui koneksi Infra Red atau Bluetooth.


Tak salah jika iPAQ 6365 Community terbentuk atas dasar kelengkapan fitur yang tersedia.




Bukan hanya itu saja, nilai investasi yang ditanamkan dalam device ini cukup baik. Dengan angka di bawah Rp 6 juta, bisa dikatakan bahwa iPAQ 6365 adalah convergent device terlengkap dan termurah.


Kalau dibandingkan dengan produk-produk sejenis, biasanya mematok harga di atas Rp 7 juta


atau bahkan sampai Rp 10 juta yang mana membuat nilai investasi awal terlalu tinggi.




Tidak hanya dukungan fitur lengkap dan harga cukup terjangkau, iPAQ6365 juga didukung oleh


layanan purna jual yang bisa dibilang sempurna untuk saat ini. Dengan 1 tahun International Warranty dan 3 tahun Extended Warranty, HP selalu mereplace device-device yang bermasalah. Hal ini merupakan salah satu alasan bahwa investasi iPAQ 6365 merupakan investasi yang cukup menguntungkan.


Dengan semua dukungan yang ada, maka iPAQ 6365 adalah device yang layak untuk dipakai sebagai salah satu penunjang mobilitas kerja.




Spesifikasi Teknis iPAQ 6365


- Processor : TI OMAP 1510 *running @200 MHz


- RAM : 64MB (20MB non volatile)


- ROM : 64MB


- SDIO : 1 slot


- GSM : 4 band (800/900/1800/1900)


- WIFI : 802.11b


- Bluetooth : v1.1


- Camera : 0.3 Mpixel


- GPRS


- Infra Red


- Battery : removable 1800MAh


- OS : Windows Mobile 2003 Phone Edition

- Thumb keyboard included




Review Singkat iPAQ 6365


Penggunaannya memang perlu learning terlebih dahulu, apalagi kalau baru pertama kali menggunakan PocketPC.


Dari segi Operating System mungkin tidak terlalu bermasalah, karena berbasiskan Windows Mobile 2003 dimana interface nya sangat mirip dengan OS berbasiskan Windows 98/Me/XP.




Daya tahan batere 1800MAh nya sangat baik. Penggunaan normal (cuma sekali2 dipakai) bisa tahan sampai 3 hari. Kalau agak intens menggunakan Bluetooth, WIFI dan GPRS Connection, baterai bisa bertahan 1-2 hari. Kalau dipakai terus menerus non stop dengan fungsi Bluetooth dan WIFI On,


bisa bertahan sekitar 7 jam. Ketahanan baterai yang tinggi ini disebabkan pemakaian processor TI OMAP yang hemat konsumsi daya. Untuk pemakaian heavy duty, sudah tersedia battery 3600MAh.




Jika baterai sudah habis, tidak perlu khawatir data akan hilang karena iPAQ 6365 mempunyai backup battery terpisah sehingga data akan tetap aman sampai sekitar 5 jam.




Untuk performa, iPAQ 6365 termasuk sedang bahkan cenderung lambat. Boot up memakan waktu sekitar 30 ******* Untuk transfer file dan browsing file2 di dalam memory, terasa lebih lambat daripada PDA2 lainnya.




Kecepatan backup data dengan menggunakan software default iPAQ Backup juga dapat diandalkan. Backup/Restore dapat dilakukan dengan mudah dan cepat.




Ketersediaan software pendukung third party juga sudah sangat lengkap. Anda bisa menemukan berbagai macam software pendukung mobilitas Anda. Mulai dari software keuangan, office, presentasi, CAD, picture editing, games, multimedia dll.




Konektivitas WIFI sangat mengagumkan. Ketika menemukan hotspot, cuma memerlukan waktu 3-5 detik untuk terkoneksi dengan hotspot. Setelah itu Anda bisa menjelajahi dunia maya dengan bebas. Sebagai informasi hotspot WIFI dapat ditemukan di pusat-pusat keramaian seperti mall, cafe, hotel, dll. Ada yang gratis, ada juga harus membeli voucher.




Untuk urusan multimedia, secara default iPAQ 6365 dapat digunakan untuk menjalankan file-file MP3, WMV, WMA, 3GP.


Untuk menjalankan file-file selain itu (MPG, AVI, MOV, RM) harus menginstall software-software yang mendukung format tersebut.




Untuk urusan potret memotret, bisa menggunakan kamera terintegrasi 0.3MPixel. Kualitas gambar yang dihasilkan memang tidak setajam produk2 sejenis dari merk lain. Namun cukup fungsional. Kelemahannya jika memotret dalamruangan gelap.




Akhir kata, iPAQ 6365 adalah device terintegrasi yang bisa mendukung mobilitas Anda dalam bekerja dimana saja dan kapan saja. Dengan dukungan layanan purna jual yang sangat baik, maka investasi device ini tidak sia-sia…




Kekurangan :


1. Dalam cahaya yang kurang camera kurang begitu bagus hasilnya..


2. Speakerphone (bukan earphone) utk handsfree yang ada dibelakang device volumenya tidak terlalu besar dan terdengar terlalu banyak treble nya dibanding bass.


3. Bila sedang telepon, lalu ada message masuk, kadang2 hang


4. Bila hang, ada telepon masuk, si penelepon akan mendengar nada masuk, tapi tidak diangkat. 5. Blom ada banyak carrying / leather case


6. Kalo lagi telpon trus ada sms masuk dan vibrationnya di-hidupkan, orang yg telpon kira ada traktor di deket kita


7. Tombol volume up-down agak2 keras dan agak sulit diraba.




Note : Sebagian besar kekurangan diatas sdh diperbaiki melalui update ROM versi terakhir 1.11.10




Kelebihan :


1. Wifi, Bluetooth, GPRS, Camera, dan Telepon 4 band dlm 1 device


2. Predictive text input di sms bisa bahasa Indonesia juga by learning kata2 yang sering kita gunakan.


3. Bluetooth HF bisa dipake dengerin MP3


4. Ada tumbnail keyboard


5. Batere lebih tahan lama dibanding PDA phone lainnya yg berbasi PPC 2003


6. Replace-able batere


7. Good hand-grip dgn lapisan rubber di ke-2 sisinya


8. Standard carrying case nya (belt clip)


9. Garansi 1 tahun dari HP, lebih baik dr yg lainnya




1. Memori di 6365 terdiri dari 64 MB RAM, 64 MB ROM dan Storage Card (SD card, eksternal, kalau ada). Dari 64 MB ROM, sekitar 20 MB bersifat user accessible, lazim disebut iPAQ File Store (IFS). Data yang disimpan di IFS, tidak akan hilang kalau kehabisan batere atau habis hard reset sekalipun (di IFS tidak akan hilang). 64 MB RAM semuanya user accessible, dynamically adjusted. Maksudnya selain untuk RAM (Main Memory) juga untuk Storage. Lihat di Start-Setting-System-Memory-Main. Geser slider ke kiri berarti more RAM to run program, ke kanan more Storage untuk install program di Main Memory. Kalau lihat di File Explorer, semua folder kecuali IFS dan Storage Card, disimpan di RAM.




2. Semua shortcut ada di WindowsStart Menu. Dengan Resco Explorer kita bisa perbaiki dead link/shortcut tersebut. Tetapi persoalannya tidak sesimple itu, karena beberapa program tergantung pada *.dll dan juga registry entry. That's why ai selalu bilang ALWAYS REINSTALL AFTER HARD RESET.




3. Dulu saran kalo program bersifat Today Plugin, install di Main Memory, yang butuh akses agak cepat di IFS, etc…, tapi sekarang nggak lagi. SEMUA INSTALL DI STORAGE CARD, kecuali ada program yang insist di Main Memory. Tapi dengan beberapa trik, masih mau juga kok dipindahin. Preference ai adalah the more RAM you have the better. IMHO you won't get signinificant advantage by installing apps. in RAM. IFS (dan juga Storage Card) dipake untuk menyimpan dokumen.




4. SMS/Email tidak bisa disimpan ke SC (hanya attachment yang bisa). Say goodbye to SMS/Email dan juga MMS after hard reset. Ini bug dari OS, nothing we can do about it. Beberapa s/w seperti Jeyo Mobile Companion, SMS backup, mungkin bisa membantu, tapi buat ai tetap nggak 100% perfect.




4. Yang terakhir, jangan lupa pakai ROM terbaru. Last version adalah 1.11.10.




TIPS : mengingat kita sadari bahwa prosesor iPAQ ini tidak sebesar XDA atau yg lainnya walaupun PDA lain juga bukannya tidak pernah hang..tp untuk menghindari terjadinya hang maka kita perlu atasi dengan cara :


- Install software sesuai kebutuhan kita


- Install aplikasi yang berat atau besar di SD/MMC


- Sering2lah menutup aplikasi yang sedang berjalan/running aplication


- Install software Space Maker atau yg sejenis utk menghapus file2 yg tidak perlu.


- Sering2lah membersihkan temporary files.


- Kalau habis remove program/uninstall, folder program kosongnya juga kalau bisa di delete via File Explorer atau Resco File Explorer (apabila sdh install software ini..)


Mudahan ini bisa mengatasi kekurangan yang ada di 6365..so far selama saya melakukan cara diatas tidak pernah hang lagi..









Cara Install dan Program yang wajib di install, by Simon :


1. Instalasi software bisa di 3 tempat : Main Memory, iPAQ File Store dan Storage Card/SD Card (kalau udah beli)…


Beberapa software memang harus di install di Main Memory agar berjalan dgn lancar contohnya :


- Pocket Mechanic


- Pocket Plus


- Battery Pack Pro


- Smart Filter


- Photo Contacts


- World Mate Pro


- Journal Bar


- Pocket Controller


Biasanya software2 yang berhubungan dengan Layar Today harus diinstall di Main Memory..


Tapi bisa juga diinstall di iPAQ File Store… Misalnya :


- World Mate


- Memmaid


- Smart Filter




Jangan sekali2 menginstall software2 yang di atas ke dalam Storage Card/SD Card karena ketika iPAQ di Power Off kemudian di On kembali, kemungkinan terjadi hang… Hal ini disebabkan iPAQ memerlukan waktu sekitar 1-2 detik untuk membaca SD Card… Secepat apapun SD Card, tetap masih lebih cepat Main memory dan iPAQ File Store…




Software2 yang bisa diinstall di SD Card adalah software2 yang tidak berjalan secara realtime di Layar Today… Misalnya : Games atau software2 tambahan seperti : eWallet, FlexWallet, Converter, Calculator, Tweaks, dll…


Ini ABC-nya Pocket PC jadi harap mencatatnya..




2. Software2 bagus sudah banyak dibahas di forum, tinggal check saja archive nya…


Bagus kan ada 2 kategori : Bagus untuk dipakai dan bagus untuk dilihat… :)




3. Kalau jadi lelet iPAQnya, kamu baru install program apa? Biasanya yang bikin lelet itu Battery Pack Pro… Jangan diinstall deh, pakai saja Pocket Plus atau PowerLevel…




Tips hemat battery, by : Simon


1. Set Infra Red Off


2. Set Standby Period 24 hours


3. Set Backlight Off on battery : 1 min


4. Set PDA Off on battery : 2-3 min


5. Set brightness kira2 75%


Setting GPRS IPAQ 6365


1. Masuk ke menu utama tampilan ' Windows'


2. Polih 'Start' yang ada di pojok kiri atas


3. Pilih 'Setting'


4. Di menu setting, pilih ' Connection '


5. Pilih ' GSM / GPRS Settings '


6. Isi data berikut:


7. Country ( Indonesia )


8. Operator ( Pilih salah satu operator yang digunakan), jika tidak ada pilih ' Create a connection '


9. Pilih country ( Indonesia )


10. Enter the connection name:


T-Sel : Telkomsel


IM3 : M3-GPRS


XL : XL-GPRS


Matrix : Sat-gprs


Klik Next


11. Select the network to use ( GPRS Connection ), klik Next


12. Isi configuration of your GPRS connection :


13. APN:


T-Sel : Telkomsel


IM3 : www.indosat-m3.net


XL : www.xlgprs.net


Matrix : Satelindogprs.com


14. Name / Username :


T-Sel : wap


IM3 : gprs


XL : xlgprs


Matrix : ( kosongkan )


15. Password :


T-Sel : wap123


IM3 : im3


XL : proxl


Matrix : ( kosongkan )


Klik Next


16. Pilih static IP Address


17. Masukkan IP address


T-Sel : 10.1.89.130


IM3 : 10.19.19.19


XL : 202.152.240.50


Matrix : 202.152.162.250


Klik Next


18. Pilih Dynamic DNS Address, klik Next


19. Masukan service center number untuk sms, klik Next


20. Masukan MMS center Address


T-Sel : MMS


IM3 : MMS-M3


XL : MMS-XL


Matrix : MMS Sat


21. APN :


T-Sel : mms


IM3 : mms.indosat-m3.net


XL : www.xlmms.net


Matrix : mms.satelindogprs.com


22. Name / username :


T-Sel : wap


IM3 : mms


XL : xlgprs


Matrix : satmms


23. Password :


T-Sel : wap123


IM3 : im3


XL : proxl


Matrix : satmms


Klik 'OK' yang ada di pojok kanan atas.


24. Isi WAP parameter


25. IP Address :


T-Sel : 10.1.89.130


IM3 : 10.19.19.19


XL : 202.152.240.50


Matrix : 202.152.162.250


26. Port ( 9201 )


27. Klik 'OK' yang ada di pojok kanan atas.




Setting GPRS dan MMS with Matrix di HP 6365


1. Tap di kotak "G" di atas layar


2. Akan keluar warning message "Unrecognized SIM .." - Pilih "Yes"


3. Di tab Country pilih "Indonesia"


4. Tap tombol "Create a new connection"


5. Masukkan Account : Satgprs


6. Masukan APN : satelindogprs.com


7. Kosongkan User Name dan Password


8. Pilih "Next"


9. Pilih IP Static, Masukkan IP : 202.152.162.250


10. Kosongkan DNS


11. Masukkan SMS Center : +62816124


12. Masukkan MMS Center Address : Sat-MMS


13. Masukan APN : mms.satelindogprs.com


14. Masukan User ID : satmms


15. Password : satmms


16. Pilih "Next"


17. Masukkan IP Address untuk WAP : 202.152.162.88


18. Masukkan Port : 9201


19. Finish.




Untuk GPRS sudah dicoba dan berjalan oke, tapi untuk saat ini ada kesulitan koneksi… Kayanya ada maintenance dari Satelindo.. Soalnya waktu tgl 12 Oct pagi-siang saya masih bisa konek GPRS, tapi waktu jam 11 malam sampai saat ini ngga bisa konek..


Saya pikir ada something wrong dengan 6365, tapi ternyata ketikan dicoba dengan kartu HALO (T-Sel) tidak ada masalah sama sekali…


Kalau sudah setting spt di atas, kemudian Bro ada Soft Reset ntar waktu detect GPRS Network


akan keluar message : "Unrecognized SIM. Do you want to configure your GPRS/GSM Setting ?" …


Pilih No aja…




Step by step setting connect internet PC via cradle, by Cris.


1. Masuk Ke Setting terus ke Connections


2. Pilih Connnections (gambarnya komputer dengan banyak device)


3. Kemudian di My Home network pilih Edit My Proxy Server


4. Kasih tanda conteng di pilihan 'This network connects to the internet'.


5. Soal proxy server(i.e. server yang mengatur lalu lintas keluar masuk data dari internet ke komputer user vice versa ->artian singkatnya, di google banyak kalo mau ^^) ini tergantung dari jaringan ISP teman teman sekalian tapi memang biasanya ada.




Misalnya saya memakai layanan cable cbn. Cbn memiliki proxy server. Kemudian di tulisan 'This network uses proxy a proxy server to connect to internet' saya tulis Proxy server: proxy.cbn.net.id




Untuk yang di perkantoran bisa tanyakan kepada network adminnya soal proxy servernya. Pasti tahu. Ndak mungkin ndak tahu. Kalo ndak tahu, wah perlu dipertanyakan tuh apa bener network admin




Browse ke PC lewat Bluetooth, by Nabely M. :


Waktu handshake dengan USB bluetoothnya PC, kita pilih service untuk network access.


Sebelum browsing, kita juga harus samakan IP Address. Klik Network Connections di PC, lalu klik-kanan -> properties di Bluetooth Network (berlaku sama dengan WiFi tetapi yang kita atur koneksi yang bernama Wireless Network)lalu double klik Internet Protocol (TCP/IP) dan set IP addressnya menjadi seperti 192.168.y.xxx (x adalah 0-255 dan y biasanya 0 atau 1). Subnet mask menjadi 255.255.255.0 dan klik OK.




Kemudian di iPAQ 6365 kita, goto Start->Settings->Connections->Connections lalu pilih halaman Advanced->Network Card. Tap Bluetooth PAN User Driver dan samakan tipe IPnya tapi xxxnya ga boleh sama.




Setelah itu ya sama seperti jaringan komputer (LAN) biasa saja, tinggal di share kemudian bisa di browse lewat PDA.




Cara browsenya bisa pake Resco File Explorer atau File Explorer bawaan. Kalo pake File Explorer, kita tinggal tap tombol Open di bawah kiri lalu masukkan nama komputer anda (lihat/ganti nama komputer propertiesnya My Computer/System Properties) diawali dengan dua ". Seperti \Server atau \KomputernyaBudi.




Kalo di Resco, tap tombol yang ada di bagian kanan bawah di sebelah tombol Infra Red (Beam File). Lalu pilih Map Drive. Prinsipnya sama dengan Network Drive mapping jadi kita tidak bisa mapping ke \NamaComputer tetapi harus ke \NamaComputerNamaShareFolder seperti \ServerGames atau \komputerSayaMy Music.




Trik di atas berlaku sama bila melalui koneksi Ad-Hoc WiFi.




Ingat:


PC tidak bisa berbalik browse isi file PDA. PDA tidak pernah terhubung dengan Network neighbourhood, jadi kalo di PC kita view Workgroup Computer di PC, tidak akan ada PDA kita tertera di situ.




Kalo kita mau internetan menggunakan internetnya PC di PDA, kita handshake dulu dengan PC, lalu pilih Serial Port (kalo ga salah, gw lupa) dan PC konek ke internet, otomatis akan ada pesan di PDA "This Network Connects Me To" pilih aja the Internet.




Kalo dial-up connectionnya di share (klik-kanan properties di koneksinya di Network Connections lalu centhang semua yang ada di halaman Advanced di bagian "Internet Connection Sharing") maka PC bisa otomatis konek ke internet jika PDA kita request internet connection lewat Bluetooth.


Selamat mencoba!




Trick Sync, by Nabeli :


Begini, saya menemukan suatu trik yang unik:


Pernah ga kalian menemui suatu computer yang sudah terhubung dengan internet, lalu anda mendownload program dari internet buat PDA namun tidak menginstallnya karena anda tidak bawa datacable?




Begini, kasusnya waktu itu adalah saya menemui sebuah laptop berwifi dan terhubung ke internet. Karena waktu itu saya sudah mendownload beberapa program PDA (dari #pocketwarez @ EfNet) saya lantas bingung bagaimana installnya ke PDA. Akhirnya saya mendownload ActiveSync, namun jika AS baru saja diinstall dan belum ada known partnerships,


dia tidak akan mengenali iPAQ 6365 jika kita beusaha connect wirelessly (Bluetooth or Wifi). Seperti yg tertera di link yang Bung Zainul kirim, requirementnya adalah previous partnerships dengan PDA yg sama menggunakan data cable.


Tetapi di sini kasusnya adalah tidak membawa data cable. Lantas bagaimana caranya?




Kebetulan di rumah saya melihat lagi di PC saya (yang tentu sudah pernah terhubung dengan PDA saya melalui USB Crade). Ketika saya perhatikan di Registry (ketik run -> Regedit). Saya perhatikan bahwa informasi tentang partnerships tersimpan di:


[HKEY_CURRENT_USERSoftwareMicrosoftWindows CE Services]


Kita dapat 'trick the laptop' dengan export key tersebut (File ->Export) lalu menyimpannya dalam PDA kita atau disket/UFD.




Kemudian, pada komputer target (sang laptop) kita bisa mentransfer file *.reg yg telah kita buat tadi dengan menggunakan iRDA (biasanya laptop berwifi sudah punya iRDA) atau menggunakan disket/UFD.


Double click file *.reg dan klik 'Yes'. Lalu secara otomatis di ActiveSync laptop akan tercatat partnership dengan PDA anda layaknya di PC rumah anda. Setelah itu establish wifi connection yg sudah diajarkan dalam link dari bung Zainul dan sync menggunakan cara yang sama pula.




Biasanya untuk Sync information, akan muncul pesan Synchronization Error. Tidak apa2. Toh kita tidak berniat Sync info, yg penting bisa explore device dan install program dari situ.


Selamat mencoba!




Teknik Active Sync via USB Bluetooth :


Activesync via BT sudah berhasil belum? Kalau belum saya coba bantu ya …..


Dengan asumsi USB BT sudah terpasang dan drive USB BT sudah terinstall dengan baik, lakukan step berikut:


*** Jalankan di PC


1. synchronize Activesync via USB cradle


2. Lepas USB cable dan pasang USB BT


3. Click kanan pada icon BT, pilih advance configuration


4. Masuk ke tab Accessibility, cek option "Let Other BlueTooth device discover this computer".


5. Masuk ke tab Service, Periksa service "Bluetooth serial port" harus started dan diarahkan ke COM7.


6. Jalankan activesync, click File | Connection Setting, cek option "Allow serial cable or infrared connection to this COM port", arahkan ke COM7 atau serial port yang sesuai di registrasi BT.


*** Jalankan di iPAQ


7. Activekan bluetooh select ke "ON".


8. Masih di menu bluetooth, pilih Menu | Add Device, tunggu proses discovering beberapa saat sampai nama komputer muncul di daftar "Select device"


9. Setelah nama komputer muncul, sorot ke nama komputer tsb dan click Add.


10. Masukan PIN Code, misalnya 123


11. Perhatikan icon BT pada kanan bawah sesaat berubah warna menjadi hijau tanda menerima sinyal di BT di iPAQ. Double click icon BT, kemudian masuk PIN Code yg sama spt pada step 10 yaitu 321.


12. Mungkin di iPAQ anda akan muncul konfirmasi "This bluetooth device support headset profile", jawab NO


13. Sekarang kita coba synchonize via BT, masuk ke menu ActiveSync kemudian pilih menu | connect via Bluetooth.


14. Jika nasib anda mujur icon BT di PC akan kembali berwarna hijau. Double click icon tsb kemudian click OK untuk konfirmasi dan si hijau activesync berputar spt biasa.


15. :-)


Selamat mencoba,




Tips ActiveSync pake BT Dongle, by Ardy :


Ternyata simple sekali, syaratnya PC dan iPAQ nya di 'Paired' dulu ya.


Step2xnya:


1. Aktifkan Ms. ActiveSync di PC


2. Masuk Ke Connection Setting, Pilih (tick) 'Allow Serial Cable or InfraRed Connection to This COM Port:


3. Pilih salah satu COM port yg available (standardnya COM4)


4. Klik OK




Setelah itu kita harus setting di iPAQ6365, sbb:


1. Masuk ke iPAQ Wireless


2. Nyalakan BlueTooth


3. Masuk ke Manager. Pilih menu 'New' lalu pilih 'ActiveSync via Bluetooth'.


4. Ikuti petunjuknya, secara otomatis iPAQ akan discover services yg disediakan.


5. Voila…. connected.




Jika memakai "PocketController", sbb:


1. Masuk ke menu 'Tools -> Configure'


2. Pilih 'New Connection…'


3. Isi 'Connection Name' dgn nama yg diinginkan


4. Pilih 'Device Manufacturer' dgn 'HP(Compaq)'


5. Pilih 'Device Type' dgn 'iPAQ 6315′


6. Pilih 'Connection Type' dgn 'ActiveSync (Serial)'


7. Pilih 'OK'


8. Setelah itu tinggal connect saja.


Selamat Mencoba.


~ Ardy ~




How to access Internet via ActiveSync, by Julius :


You can use the O2 Xda II to access the Internet though ActiveSync, if your PC have access to Internet.


Connect ActiveSync with your PC. No matter using USB, Serial, Bluetooth or Infra Red.




When you tap in the network signal icon, you will see "The Internet PC connection"




credit for: http://pagesangan.wordpress.com

Source : http://www.indowebster.web.id/showthread.php?t=88922

SQL: If Exists Update Else Insert

This is a pretty common situation that comes up when performing database operations. A stored procedure is called and the data needs to be updated if it already exists and inserted if it does not. If we refer to the Books Online documentation, it gives examples that are similar to:

IF EXISTS (SELECT * FROM Table1 WHERE Column1='SomeValue')


UPDATE Table1 SET (...) WHERE Column1='SomeValue'


ELSE


INSERT INTO Table1 VALUES (...)

This approach does work, however it might not always be the best approach. This will do a table/index scan for both the SELECT statement and the UPDATE statement. In most standard approaches, the following statement will likely provide better performance. It will only perform one table/index scan instead of the two that are performed in the previous approach.

UPDATE Table1 SET (...) WHERE Column1='SomeValue'


IF @@ROWCOUNT=0


INSERT INTO Table1 VALUES (...)

The saved table/index scan can increase performance quite a bit as the number of rows in the targeted table grows.

Just remember, the examples in the MSDN documentation are usually the easiest way to implement something, not necessarily the best way. Also (as I re-learned recently), with any database operation, it is good to performance test the different approaches that you take. Sometimes the method that you think would be the worst might actually outperform the way that you think would be the better way.

Source : http://blogs.msdn.com/b/miah/archive/2008/02/17/sql-if-exists-update-else-insert.aspx