Difference Between Current Date & Given Date: Sql Server Query

Remove - Subscribe to: Posts (Atom) Blogger

1. Go to dashboard/ template/ edit HTML
2. Click the 'Expand Widgets Templates' box
3. Find:

SMS Blaster... Bulk SMS Sender... SMS Bomber

Here is a SMS Blaster tip, to irritate your friends or enemies....

Export Excel Data To Sql Server

Step 1:

Enable Ad hoc Distributed Queries

Run The Following Commands one after the Other

Which one To Follow??

One friend send me a message..

Contradictory proverbs

1. All Good Things Come To Those Who Wait
_But_
Time And Tide Wait For None

Removing the blogger bar(nav bar) in blogger

You can remove it just by editing the css.
For that,
1) Sign in to your account.
2) Click on the design tab.
3) Edit HTML

Very Very useful, Fastest Fox...

Hi guys,
Are you using Fire Fox..!!!..
Then have you tried Fastest Fox...
If Not!!! you are missing something...

Yes, its true..
With Fastest Fox you can have the best browsing experience..

It has many features..
One of the feature i like most is that...
It will load the next page automatically..
For Eg. If we searched for something in GOOGLE,
a list of results appear,
sometimes we cant find the required results in first page, at that time we will go for next page..
by clicking on next..
With Fastest Fox, the next page will be loaded automatically and appended at the bottom of the first page..
So that your internet connection is not idle wen we are reading the contents of the first page.
Hope you understand what i am saying..
If not, give a try to Fastest Fox, it will boost your browsing experience.
For installing Fastest Fox visit http://smarterfox.com
or just go to your addons page and serach for FastestFox
thats it..

Hope you will make use of it....

KB971033 update for windows 7 is preventing cracks for windows 7

Guys,
Dont install "KB 971033" update for Windows7
It is an optional update, if you install it(like me), it was identifying the genuinity of Windows 7 and your cracks will not work.

System.LINQ name sapce not found

One day while working with LINQ,
After creation of the application, while debugging
It said that the System.LINQ name space is not found....

How Do I Enable Line Numbering In VS 2008

One day after installing VS IDE, i got a silly problem,
I am unable to see the line numberings in the IDE.

Got the solution finally as
Go to-->Tools-->Options-->TextEditor-->All Languages

Selected Index Changed Event Problem in ASP.net

If you are not using AJAX Check that the DropDown List Should be enabled with postback=true for selected index changed event

Coming to me,
I had a problem of using Dropdown List With AJAX

System.ArgumentException: Keyword not supported: 'provider'.

I got this error for the first time i am using SQLServer database with my VS 2008.

I done every thing correctly but still i got this.

Finally i found the solution is that.

Here i am using SqlConnection so the provider should not be provided in the connection string

Boot MGR not found. Press Ctrl+Alt+Del to restart (Windows 7)

One day morning, when i on the computer.
It said,
Boot MGR not found.
Press Ctrl+Alt+Del to restart.
First i thought of re-installing fresh OS.
But,

TimeOut Problem In WCF or Web Service

When I am learning WCF services the first problem I faced is with the TIMEOUT.
I done everything correctly but the service is not running.
I googled about the problem.
Long looong posts about this problem.
Completely confused, hated WCF.
But,

How To Rename Your Long Free Website?

In this post you can see how you can make long urls offered by many of the free web hosting sites into a primary and short domain for free..

Change Any Link Into .TK extension below...
Or
You can download a small file(932 KB) for faster ACCESS.
Click Here To Download

Two Motor Cycles Become One Car

Wondered....

Yes, but it is not a complete buy 1 get 1 offer but a 1+1=1 offer..

Confused...

You can get out of your confusion just by seeing the design of it..

This is the real deal in modern wild design. This is the “Plug-In” affordable youth mobility project by Ramesh Gound. According to Gound, there is a big “buy 1 get 1 free” shopping attitude in the market around the Ahmedabad area of India. This simple concept gave Gound the idea to take two motorcycles and attach them in the middle. Each motorcycle is owned by its respective party, a young person with a big appetite for sports vehicles but a small pocketbook, then they attach. Once two motos attach in the middle, they become that fantastic sports car from heaven.

Two drive-by-wire bikes are owned by separate people. They wanna attach them for a longer drive or some sort of trip that’s not great for motorcycle, or hey, if they just wanna cruuuze… they attach in the center of the two.

The hood is made of D3O, which when the bikes are not attached, stows away in the bike configuration. This whole concept is aimed to take on congested cities such as Mumbai.


Here are the snapshots...

Very much excited...
But the real news is that this is a model designed by Ramesh Gound as the project in his final year Diploma project at National Institute of Design, Ahmedabad India sponsored by Renault Design India

Computers At Your Wrist...????

Yes, its very interesting, in the coming future, sony computers are being designed to fit for our wrists. Yeah its a future gadget from sony.

Our present need for internet connectivity is so profound that secondary devices like the Nextep Computer are bound to happen. Developed to be worn as a bracelet, this computer concept is constructed out of a flexible OLED touchscreen. Earmarked for the year 2020, features like a holographic projector (for screen), pull-out extra keyboard panels and social networking compatibility, make the concept plausible. Ten years from now is not too far away, so how many of you think we’d be buying such gadgets?

Technology Is Booming...

Copy protected dvd burning software

There will be some DVD's which are copy protected, here is a software to copy those copy protected DVD's

Generally in we cant see the data in them with normal windows explorer, so use this software.

Download the IsoBuster Software from the below download link and after installing it you can view the files and copy them to your system.

Download

System Is Restarting Automatically (Pendrive Inserted)

I found my system is restarting automatically, whenever a pendrive is inserted. I found the solution that there is a files system error in my pendrive..

So, if your system is restarting whenever a pendrive is inserted then it may have certainly 2 reasons

Due to a virus in the pendrive
or
Due to a file system error in pendrive

If it is due to virus then scan it with a powerful antivirus.

If it is due to file system error follow these steps.

Step 1: After restart, open My Computer and right click on the pendrive icon and select properties.

Step 2: Select the tools tab and click on the Check Now button. Then it will check any file system errors in the pen drive.

Thats it your problem will be solved..

Hope this helpsss..

Comment below..

Remove Khatra.exe/Xplorer.exe/gHost.exe Viruses

If your computer has any of the viruses Khatra.exe or Xplorer.exe or gHost.exe then here is the step by step procedure to remove them....

Step 1: Open TaskManager by pressing Ctrl+Alt+Delete (if taskmanager is disabled see how to enable it here)

Step 2: Now inside the task manager, press the Processes tab and search for the following processes

regsvr.exe
gHost.exe
khatra.exe
Xplorer.exe

If those processes exists, select them and click End Process.

Step 3: Now download the small(333KB) application (link at bottom) and install it.

Step 4: Now run the application and search for the files gHost.exe, khatra.exe, Xplorer.exe one after the other and delete them.

Step 5: Finally go to run and type regedit and search for the above three files using Ctrl+F and delete any entries

Thats it the virus is deleted Successfully..

Download Link:

Ziddu : Download Application Here(recommended) 333 KB
Mediafire : Download Application Here 333 KB

Hope this helpsss...

Comment Below..

Task manager Disabled..?

Due to some system viruses there are some cases in which our taskmanager is disabled, in this post we will see how to enable it again in a step by step procedure...

Step 1: Go to run box by pressing win+r buttons or from start menu.

Step 2: Type gpedit.msc and press enter.


Step 3: Inside the group policy editor navigate to UserConfiguration>Administrative Templates>System>Ctrl+Alt+Delete options in the left side panel.


Step 4: Now double click on the Remove Task Manager option in the Right Panel

Step 5:
In the pop up window select the Disable option and press OK

Thats it...

Hope this helps...

Comment below...

Free Undete- Recover The deleted files

This is a small and powerful program that can be used to restore your deleted files effectively.

It is very easy to use.

1. Just run the program after downloading it.
2. Now select the partition in which the file is deleted.
3. Press the scan button.
4. It will display the list of deleted files.
5. Select the required file and press UNDELETE.

Thats it...

Download Link:
Ziddu : Download (recommended)
Mediafire : Download

Hope this helpss..

Write your comment below...

Protect your GMAIL Account.

In the present days some illegal websites are inserting dangerous codes into them and hacking our gmail accounts. So, every person has to take care about your gmail account.

So, whenever you logged into your account, check the details of the last login. This can be seen at the bottom of the gmail page after you have logged in.

You can also see the last 10 login details by click on the "details" link at the bottom of the page.
It will pop up a window and show the details as follows

Press the Sign Out All Other Sessions button For Safety.

In this way you can protect GMail from unauthorized access.

If you found that some one other than you is using your account, then change your password immediately.

If someone has already changed your password then send a mail to the GMAIL team describing the situation, then they will reset your password.

Note : GMAIL Account creation date will be asked for resetting the password. So remember it for safety

Hope this helps..
Say thanks if helps...

How to type special symbols through keyboard

For typing special symbols through keyboard press and HOLD the ALT button and press the corresponding number below..

Download the following symbols in a text file here
Download:
http://www.mediafire.com/file/mhnwtww0dmi/Symbols.txt

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 0
49 1
50 2
51 3
52 4
53 5
54 6
55 7
56 8
57 9
58 :
59 ;
60
63 ?
64 @
65 A
66 B
67 C
68 D
69 E
70 F
71 G
72 H
73 I
74 J
75 K
76 L
77 M
78 N
79 O
80 P
81 Q
82 R
83 S
84 T
85 U
86 V
87 W
88 X
89 Y
90 Z
91 [
92 \
93 ]
94 ^
95 _
96 `
97 a
98 b
99 c
100 d
101 e
102 f
103 g
104 h
105 i
106 j
107 k
108 l
109 m
110 n
111 o
112 p
113 q
114 r
115 s
116 t
117 u
118 v
119 w
120 x
121 y
122 z
123 {
124 |
125 }
126 ~
127 ⌂
128 Ç
129 ü
130 é
131 â
132 ä
133 à
134 å
135 ç
136 ê
137 ë
138 è
139 ï
140 î
141 ì
142 Ä
143 Å
144 É
145 æ
146 Æ
147 ô
148 ö
149 ò
150 û
151 ù
152 ÿ
153 Ö
154 Ü
155 ¢
156 £
157 ¥
158 ₧
159 ƒ
160 á
161 í
162 ó
163 ú
164 ñ
165 Ñ
166 ª
167 º
168 ¿
169 ⌐
170 ¬
171 ½
172 ¼
173 ¡
174 «
175 »
176 ░
177 ▒
178 ▓
179 │
180 ┤
181 ╡
182 ╢
183 ╖
184 ╕
185 ╣
186 ║
187 ╗
188 ╝
189 ╜
190 ╛
191 ┐
192 └
193 ┴
194 ┬
195 ├
196 ─
197 ┼
198 ╞
199 ╟
200 ╚
201 ╔
202 ╩
203 ╦
204 ╠
205 ═
206 ╬
207 ╧
208 ╨
209 ╤
210 ╥
211 ╙
212 ╘
213 ╒
214 ╓
215 ╫
216 ╪
217 ┘
218 ┌
219 █
220 ▄
221 ▌
222 ▐
223 ▀
224 α
225 ß
226 Γ
227 π
228 Σ
229 σ
230 µ
231 τ
232 Φ
233 Θ
234 Ω
235 δ
236 ∞
237 φ
238 ε
239 ∩
240 ≡
241 ±
242 ≥
243 ≤
244 ⌠
245 ⌡
246 ÷
247 ≈
248 °
249 ∙
250 ·
251 √
252 ⁿ
253 ²
254 ■

How to type special symbols through keyboard

For typing special symbols through keyboard press and HOLD the ALT button and press the corresponding number below..

Download the following symbols in a text file here
Download:
http://www.mediafire.com/file/mhnwtww0dmi/Symbols.txt

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 0
49 1
50 2
51 3
52 4
53 5
54 6
55 7
56 8
57 9
58 :
59 ;
60 <
61 =
62 >
63 ?
64 @
65 A
66 B
67 C
68 D
69 E
70 F
71 G
72 H
73 I
74 J
75 K
76 L
77 M
78 N
79 O
80 P
81 Q
82 R
83 S
84 T
85 U
86 V
87 W
88 X
89 Y
90 Z
91 [
92 \
93 ]
94 ^
95 _
96 `
97 a
98 b
99 c
100 d
101 e
102 f
103 g
104 h
105 i
106 j
107 k
108 l
109 m
110 n
111 o
112 p
113 q
114 r
115 s
116 t
117 u
118 v
119 w
120 x
121 y
122 z
123 {
124 |
125 }
126 ~
127 ⌂
128 Ç
129 ü
130 é
131 â
132 ä
133 à
134 å
135 ç
136 ê
137 ë
138 è
139 ï
140 î
141 ì
142 Ä
143 Å
144 É
145 æ
146 Æ
147 ô
148 ö
149 ò
150 û
151 ù
152 ÿ
153 Ö
154 Ü
155 ¢
156 £
157 ¥
158 ₧
159 ƒ
160 á
161 í
162 ó
163 ú
164 ñ
165 Ñ
166 ª
167 º
168 ¿
169 ⌐
170 ¬
171 ½
172 ¼
173 ¡
174 «
175 »
176 ░
177 ▒
178 ▓
179 │
180 ┤
181 ╡
182 ╢
183 ╖
184 ╕
185 ╣
186 ║
187 ╗
188 ╝
189 ╜
190 ╛
191 ┐
192 └
193 ┴
194 ┬
195 ├
196 ─
197 ┼
198 ╞
199 ╟
200 ╚
201 ╔
202 ╩
203 ╦
204 ╠
205 ═
206 ╬
207 ╧
208 ╨
209 ╤
210 ╥
211 ╙
212 ╘
213 ╒
214 ╓
215 ╫
216 ╪
217 ┘
218 ┌
219 █
220 ▄
221 ▌
222 ▐
223 ▀
224 α
225 ß
226 Γ
227 π
228 Σ
229 σ
230 µ
231 τ
232 Φ
233 Θ
234 Ω
235 δ
236 ∞
237 φ
238 ε
239 ∩
240 ≡
241 ±
242 ≥
243 ≤
244 ⌠
245 ⌡
246 ÷
247 ≈
248 °
249 ∙
250 ·
251 √
252 ⁿ
253 ²
254 ■

See Password behind The Dots(asterisk)

Here is a software to see the passwords that are behind...

Server Busy....

To download a software that logs all your passwords click me

See Password behind the dots

When we type the passwords in forums, email clients, login boxes, etc all those passwords will be in encrypted format.
To see the passwords behind the doubts there are softwares...

Here u will see a software to log all the passwords we have used in several password boxes..

This is a very small tool (25KB) and uses less resources.

Download Links

Ziddu Download (recommended)

Mediafire Download

For More Details On the working of the software click me

Hope this helps...

Thank you..

Comment below...

See Password behind the dots

When we type the passwords in forums, email clients, login boxes, etc all those passwords will be in encrypted format.
To see the passwords behind the doubts there are softwares...

Here u will see a software to log all the passwords we have used in several password boxes..

This is a very small tool (25KB) and uses less resources.

Download Links

Ziddu Download (recommended)

Mediafire Download

For More Details On the working of the software click me

Hope this helps...

Thank you..

Comment below...

Manual Creation Of System Restore Point

Manual creation of System Restore point involves following steps..

Step 1: Right Click on MyComputer And select properties.

Step 2: (XP users go to step 3)Now click on System Protection Link On Top of the left hand side.


Step 3: Select the system protection tab, and click on the create button.


Step 4: It will guide you through the wizard. Give the name of the restore point and press ok.


For automatic procedure of Creating Restore point Click me

Thats it...

Hope this helpss...

Comment below..

Problem in saving a file after editing in the windows directory..!!

There will be some cases in which we have to edit the pre-defined windows files in notepad(generally). But while saving them after editing, a SaveAs box appears instead of saving(especially in vista and windows 7).
In that time follow these steps..

Step 1: Save the file in another location (say Desktop), but notice that the file extension is same while saving. (in general .file or .inf etc)

Step 2: Then Copy the file from desktop in the windows directory.

Thats it...

Problem solved..

Small tip for basic pc users...

Comment below...

Thank you..

How to block a particular website..?

There are many software's on the internet to block particular sites from viewing..

But the problem is, all those programs should be run in the background and will use some system resources, which results in the PC SLOW DOWN. So here is the procedure for blocking a website without any software.

Step 1: Navigate to C:\Windows\System32\drivers\etc (where c is my Windows OS Installation drive)

Step 2: Then right click on the file HOSTS and open it with notepad.

Step 3: See for the line "127.0.0.1 localhost", at the end of this line press Enter and add as 127.0.0.2 www.orkut.com if you want to block orkut and in the next line 127.0.0.3 www.facebook.com if you want to blocl facebook also and so on...


Step 4: Save the file. If you have any problems in saving the file see this.

That's it.. you have done....

Hope this helps...

Comment below....

How to block a particular website..?

There are many software's on the internet to block particular sites from viewing..

But the problem is, all those programs should be run in the background and will use some system resources, which results in the PC SLOW DOWN. So here is the procedure for blocking a website without any software.

Step 1: Navigate to C:\Windows\System32\drivers\etc (where c is my Windows OS Installation drive)

Step 2: Then right click on the file HOSTS and open it with notepad.

Step 3: See for the line "127.0.0.1 localhost", at the end of this line press Enter and add as 127.0.0.2 www.orkut.com if you want to block orkut and in the next line 127.0.0.3 www.facebook.com if you want to blocl facebook also and so on...


Step 4: Save the file. If you have any problems in saving the file see this.

That's it.. you have done....

Hope this helps...

Comment below....

Create Restore Point Quickly

In Windows XP, Vista and even Windows 7, the restore point facility is very much useful in many times..
So frequently creating restore point is very important..

How to create Restore point...!!!!
For manual Creation See Me

Creating restore point has some procedure which u can see here but, in this post you can see how to create restore point very Very quickly.. With a single click...

Here is a small software for that, this is a very small utility (377 KB) and uses no system resources when not runned and uses very less system resources while running(creating restore point)...

Download Links:

Ziddu : Download Here (Recommended)

Mediafire : Download Here

Hope this helpss...

Comment Below

Create Restore Point Quickly

In Windows XP, Vista and even Windows 7, the restore point facility is very much useful in many times..
So frequently creating restore point is very important..

How to create Restore point...!!!!

Creating restore point has some procedure which u can see here but, in this post you can see how to create restore point very Very quickly.. With a single click...

Here is a small software for that, this is a very small utility (377 KB) and uses no system resources when not runned and uses very less system resources while running(creating restore point)...

Download Links:

Ziddu : Download Here (Recommended)

Mediafire : Download Here

Hope this helpss...

Comment Below

Desktop Software for Who-Is (IP) Identification, SmartWhoIs (FULL)..!!

SmartWhoIs is a handy desktop tool, which gives the information of the ip-addresses, viz., where the ISP is located and the contact mail id for the ISP provider, so that whenever we find a user with a particular ip address is mis behaving on the net, then we can contact the ISP provider..



This is a very small desktop tool, very handy in some times...

This tool is also available as addon for many web browsers like Firefox, Internet Explorer and also for Outlook Express..

Download:
Click Here For Download Page

Desktop Software for Who-Is (IP) Identification, SmartWhoIs (FULL)..!!

SmartWhoIs is a handy desktop tool, which gives the information of the ip-addresses, viz., where the ISP is located and the contact mail id for the ISP provider, so that whenever we find a user with a particular ip address is mis behaving on the net, then we can contact the ISP provider..



This is a very small desktop tool, very handy in some times...

This tool is also available as addon for many web browsers like Firefox, Internet Explorer and also for Outlook Express..

Download:
Click Here For Download Page

Record Computer Activities Secretly

There are some times it is required to record what happening in your computer...
Mainly for parents to have a look at what the children are doing on the computer. For this purpose this small program SECRET AGENT is very much useful..

Secret Agent helps in recording the screen secretly.

If enabled, it will automatically records the screen either at the start up or at the specified time, based on the user setting..

Download Links

Ziddu : Click Me To Download

Note: If you found your children doing wrong things dont show the video recorded, stay as you dont knowthe things and give counselling..

Hope you like this.. Comment below...

Record Computer Activities Secretly

There are some times it is required to record what happening in your computer...
Mainly for parents to have a look at what the children are doing on the computer. For this purpose this small program SECRET AGENT is very much useful..

Secret Agent helps in recording the screen secretly.

If enabled, it will automatically records the screen either at the start up or at the specified time, based on the user setting..

Download Links

Ziddu : Click Me To Download


Note: If you found your children doing wrong things dont show the video recorded, stay as you dont knowthe things and give counselling..

Hope you like this.. Comment below...

Motorola Phone Tools 5.0 Free Download

For use with all motorola phones that have a data system cable, or usb cable or bluetooth!
With Lifetime Updates via online update!

Synchronization
Synchronize your PC contacts and calendar with your phone. Motorola Phone Tools works with Outlook, Outlook Express or Lotus Notes.

Backup/Restore
Backup or restore your phone's contact and calendar data at any time.

Phonebook
Use the phonebook to manually manage or edit your contacts on your phone and PC.

Calendar
Use the calendar to manually manage or edit your appointments on your phone and PC.

MMS Studio
Compose multimedia messages with pictures, sounds and titles and send them to your friends with the MMS Studio.

Image Studio
Edit pictures and use them as wallpapers and screensavers with the Image Studio.

Melody Studio
Edit your favorite music files or audio CD tracks and use them as ringtones with the Melody Studio.

Video Studio
Compose video with sound and titles and transfer them to your mobile device with the Video Studio.

File Transfer Studio
Transfer your photos, videos and ringtones to your PC and vice versa with the File Transfer Studio.

Use Mobile Phone Tools with your laptop to create a complete mobile office. Install it on your laptop and synchronize your PC and your cell phone. Your contacts, calendar and tasks will always be in sync and you?ll be able to get on line almost anywhere.

Features:

Get online, even if there's no networks. Connect your laptop to your cell phone, and using your cell phone as a modem, get connected to the Internet. Mobile PhoneTools v3 uses new communication technologies (GPRS, UMTS, GSM) for efficient, high-speed connections. Includes a GPRS connection wizard as well as parameters for the major cell phone operators to make it easy to configure.

Synchronize you cell phone with your PC. Send and receive email, synchronize your cell phone contacts and calendar with your PC via MS Outlook. Mobile phone Tools has complete Outlook integration.

Manage communications efficiently from your mobile office: Send and receive email, send SMS, MMS and fax messages from the convenience of your laptop using your cell phone to get you online.

Explore the multimedia features of your phone. Mobile phone Tools includes ringtone software so you can make your own ringtones and transfer them to your phone via Bluetooth, infrared or cable. Plus wallpaper and video editing tools to personalize your cell phone exactly the way you want.

Homepage - www.motorola.com

Download links:

Rapidshare : Download

Motorola Phone Tools 5.0 Free Download

For use with all motorola phones that have a data system cable, or usb cable or bluetooth!
With Lifetime Updates via online update!

Synchronization
Synchronize your PC contacts and calendar with your phone. Motorola Phone Tools works with Outlook, Outlook Express or Lotus Notes.

Backup/Restore
Backup or restore your phone's contact and calendar data at any time.

Phonebook
Use the phonebook to manually manage or edit your contacts on your phone and PC.

Calendar
Use the calendar to manually manage or edit your appointments on your phone and PC.

MMS Studio
Compose multimedia messages with pictures, sounds and titles and send them to your friends with the MMS Studio.

Image Studio
Edit pictures and use them as wallpapers and screensavers with the Image Studio.

Melody Studio
Edit your favorite music files or audio CD tracks and use them as ringtones with the Melody Studio.

Video Studio
Compose video with sound and titles and transfer them to your mobile device with the Video Studio.

File Transfer Studio
Transfer your photos, videos and ringtones to your PC and vice versa with the File Transfer Studio.

Use Mobile Phone Tools with your laptop to create a complete mobile office. Install it on your laptop and synchronize your PC and your cell phone. Your contacts, calendar and tasks will always be in sync and you?ll be able to get on line almost anywhere.

Features:

Get online, even if there's no networks. Connect your laptop to your cell phone, and using your cell phone as a modem, get connected to the Internet. Mobile PhoneTools v3 uses new communication technologies (GPRS, UMTS, GSM) for efficient, high-speed connections. Includes a GPRS connection wizard as well as parameters for the major cell phone operators to make it easy to configure.

Synchronize you cell phone with your PC. Send and receive email, synchronize your cell phone contacts and calendar with your PC via MS Outlook. Mobile phone Tools has complete Outlook integration.

Manage communications efficiently from your mobile office: Send and receive email, send SMS, MMS and fax messages from the convenience of your laptop using your cell phone to get you online.

Explore the multimedia features of your phone. Mobile phone Tools includes ringtone software so you can make your own ringtones and transfer them to your phone via Bluetooth, infrared or cable. Plus wallpaper and video editing tools to personalize your cell phone exactly the way you want.

Homepage - www.motorola.com

Download links:

Rapidshare : Download

Remove user name from the start menu..?

In windows XP generally, name of the user is displayed in the start menu. To remove the name follow these registry steps.

Step 1: Go to Run box by pressing Win+R button


Step 2: Now type regedit.exe and press OK.

Step 3: Now Navigate to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer and then create a DWORD with name NoUserNameInStartMenu and with value 1.

That's it.. Restart the system...

Say thanx if u dont know this previously...

How to create a DWORD in registry

There are many times windows users are required to create new DWORD's in registry..

Here is the procedure for creating a DWORD

Step 1: Go to Run box by pressing Win+R button


Step 2: Now type regedit.exe and press OK.

Step 3: Now navigate to the required path and Right Click on the open area select New---> DWORD (32 Bit) Value


Step 4: Then give the name for it, every DWORD has its own value, to change the value double click on it. Then a popup will come through which you can set the value.

For more detail explanation see This YouTube Video

Thats It...
Its a simple thing, anyhow if you learn some thing then say thanks....

Remove user name from the start menu..?

In general name of the user is displayed in the start menu. To remove the name follow these registry steps.

Step 1:

Remove user name from the start menu..?

In windows XP generally, name of the user is displayed in the start menu. To remove the name follow these registry steps.

Step 1: Go to Run box by pressing Win+R button


Step 2: Now type regedit.exe and press OK.

Step 3: Now Navigate to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer and then create a DWORD with name NoUserNameInStartMenu and with value 1.

That's it.. Restart the system...

Say thanx if u dont know this previously...

No icons and start menu on the desktop when booting..?

There are some case due to viruses that you cannot see any icons or even the start menu on the desktop.
Then Follow these steps:

Step 1: Open the task manager by pressing Ctrl+Alt+Delete.

Step 2: Then Click On the New Task


Step 3: Then type regedit.exe and press ok, to open the registry editor.

Step 4: In the left panel navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Execution Options

Step 5: After clicking on the "Image File Execution Options" you will find 2 Subkeys on the right panel with names "explorer.exe" and "iexplorer.exe" right click on those keys and press delete.

That's It... Now Restart the system..


NOTE : This method works if the problem is due to virus. If it not works it may due to the corruption of the file explorer.exe.

How to create a DWORD in registry

There are many times windows users are required to create new DWORD's in registry..

Here is the procedure for creating a DWORD

Step 1: Go to Run box by pressing Win+R button


Step 2: Now type regedit.exe and press OK.

Step 3: Now navigate to the required path and Right Click on the open area select New---> DWORD (32 Bit) Value


Step 4: Then give the name for it, every DWORD has its own value, to change the value double click on it. Then a popup will come through which you can set the value.

Thats It...
Its a simple thing, anyhow if you learn some thing then say thanks....

No icons and start menu on the desktop when booting..?

There are some case due to viruses that you cannot see any icons or even the start menu on the desktop.
Then Follow these steps:

Step 1: Open the task manager by pressing Ctrl+Alt+Delete.

Step 2: Then Click On the New Task


Step 3: Then type regedit.exe and press ok, to open the registry editor.

Step 4: In the left panel navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Execution Options

Step 5: After clicking on the "Image File Execution Options" you will find 2 Subkeys on the right panel with names "explorer.exe" and "iexplorer.exe" right click on those keys and press delete.

That's It... Now Restart the system..


NOTE : This method works if the problem is due to virus. If it not works it may due to the corruption of the file explorer.exe.

How To Delete A Friend In Orkut

There are some times in which we have to delete the friends in our orkut account. Here is the step by step procedure for that..

Step 1: Login to your Account
Step 2: In the friends panel on the right click on the manage button

Step 3: Then select the check box for whom you want to delete.
Step 4: Then, from the "actions" Drop down menu select remove friends.
Step 5: Press OK in the popup.

Thats it..

Say thanks If you like the post...

Send Free Sms To The World Using Small Desktop Application

Here is a small application from which you can send sms all around the world(maximum). To maximum number of providers..




Download Link
http://www.ziddu.com/download/9909678/FreeSMS_1.4.8.exe.html

Download & Enjoy..

This is a test post

This is a test post.. Actually the site is under construction So catch you soon Admin

Usage Of Win Rar Software For Many Uses

Win rar is a great tool for many purposes

Many files available in the internet are of this format

U can compress the data using this and u can create exe files using this small software.

U can create exe files using the sfx option in it. Put a deep glance on every option it provides.

Many people uses only the basic features, but it is useful in many other ways very easily, which can be understood by any normal pc user by observing all the options in it.

If u have any doubts regarding it, post it as a comment here, i will try to solve..

Thank You

So download and keep a copy of it in ur pc

Download:
http://www.ziddu.com/download/8649677/winrar351.exe.html

Creating Stored Procedures in DataBases

Useful INSERT, UPDATE & DELETE Queries that must be Glanced

The Following Query is for the people who have some basic idea about databases, tables, SELECT statements, Sub-Queriesand these are some of the useful statements, mainly used in developing real time projects, so just remember their usage.

INSERT

INSERT Customers (FirstName, LastName, City, State, PIN) VALUES ('John', 'Wesley', 'Hyderabad', 'AP', '500020')

Care Should be taken that number of coloumns is equal to the number of values, not more-not less. No need to have all the coloumns but all the coloumns which are not nulls are mandatory.

Care should be taken in matching the data types. No need to put single quotes for numbered data types but all other datatypes should be single quoted.

UPDATE

UPDATE Customers SET City = 'Delhi', PIN = '552520' WHERE LastName = 'Wesley'

Updates are Very very Dangerous among all Queries, so use them with extreme caution. If u leave the WHERE clause u will be in big trouble. So first check ur WHERE clause with a SELECT statement, before performing an UPDATE.

DELETE

DELETE Customers WHERE LastName = 'Wesley'

Deletes are aslso very dangerous, so take the same precautions mentioned for UPDATES. Note that some rows cannot be deleted which are related with foreign keys.

Hope this small Article is useful. Our tutorials are short and simple but Useful.

Use UPDATES and DELETES with extreme caution.

Next Lesson Is About Stored Procedures

Useful SQL Sub-SELECT(Sub Queries) Queries That Must Be Glanced

The Following Query is for the people who have some basic idea about databases, tables and SELECT statementsand these are some of the useful statements, mainly used in developing real time projects, so just remember their usage.

SELECT * FROM Orders WHERE OrderID IN
(SELECT DISTINCT OrderID FROM OrderItems WHERE ProductID = 3)

Sub Queries are very much useful in sutuations when it is not easy to express all the rows that need to be selected. In many real time situations these can be help ful, so understand them carefully.

Mainly These Are Useful in INSERTS, UPDATES and DELETES.

I am stoping here, bcoz all the sub queries syntaxes aresimilar but it is that how logically we think about the situation plays the key role.

Hope this article may be useful.

If u found any complex queries, post them as comments to share your knowledge with others.

Useful SQL Statements That Must Be Glanced

Useful SQL Statements That Must Be Glanced

Useful SQL Statements That Must Be Glanced

Useful SQL SELECT Statements That Must Be Glanced

The Following Queries are for the people who have some basic idea about databases and tables and these are some of the useful statements, mainly used in developing real time projects, so just remember their usage.

SINGLE TABLE

General Queries

SELECT FirstName AS 'First Name', LastName AS 'Last Name' FROM Customers

SELECT FirstName + ' ' + LastName AS 'Customer Name' FROM Customers

SELECT * FROM Products WHERE ProductID = 3

SELECT * FROM Products WHERE ProductPrice > 30

SELECT * FROM Products WHERE ProductID <> 2

SELECT * FROM Orders WHERE OrderDateTime > '1/10/2006'

(Note If You Dont Specify Time It Assumes 12.00A.M, Midnight)

Arithmetic Functions

SELECT Sum(TAX) AS 'TaxesCollected FROM Orders

SELECT Count(*) AS 'Total Orders' FROM Orders

(Shows NUMBER of Records, but not their values)

SELECT ProductID, ProductPrice AS 'Regular Price', ProductPrice - 10 AS 'Sales Price'

SELECT ProductID, ProductPrice AS 'Regular Price', ProductPrice * .9 AS 'Sales Price'

(10% Discount)

SELECT Min(ProductPrice) FROM Products

(Shows Only One Min Value In The Coloumn)

SELECT Max(ProductPrice) FROM Products

(Shows Only One Min Value In The Coloumn)

SELECT Avg(ProductPrice) FROM Products

(Shows Only Average of all Values In The Coloumn)

Date Functions

SELECT OrderID, Month(OrderDateTime), Day(OrderDateTime) From Orders

SELECT GetDate() (Returns the current date and Time)

--- Use The below functions to return the required value from date datatype.

--- yy = year

--- mm = month

--- dd = day

--- hh = Hour

--- mi = Minute

--- weekday = (Sunday through Saturday)

SELECT datename(mm,OrderDateTime) FROM Orders

(datename function gives detail info as sunday,etc)

SELECT datepart(mm,OrderDateTime) FROM Orders

(datepart function gives only no of the month Eg. 1 for january)

SELECT datediff(dd, GetDate(), OrderDateTime) FROM Orders

(Returns Diff Btn Two Dates)

SELECT dateadd(dd, 5, OrderDateTime) FROM Orders

(adds 5 days)

String Functions

SELECT substring(ProductDescription, 3, 5) FROM Products

--Starting At the 3rd Character and retriving next 5 characters

SELECT right(ProductName,5) FROM Products

--Select theRight Most 5 Characters

SELECT left(ProductName,5) FROM Products

--Select the Left Most 5 Characters

Upper Case

SELECT upper(ProductName) FROM Products

Lower Case

SELECT lower(ProductName) FROM Products

Reverse

SELECT reverse(ProductName) FROM Products

Wild Cards With LIKE

--% = any

SELECT * FROM Customers WHERE FirstName LIKE 'J%'

Using IN to filter data

SELECT * FROM Customers WHERE STATE IN ('AP', 'UP', 'TN')

Sorting data

ASC for Ascending, DESC for Descending, default is ASC

SELECT * FROM Customers ORDER BY lastname ASC

SELECT * FROM Customers ORDER BY lastname, firstname (Ordering 1st by lastname then by firstname)

GROUP BY statement

SELECT CustomerID, count(*), sum(shipping) FROM Orders GROUP BY CustomerID

Here GROUP BY is a little bit tricky, but easy when understand clearly. The above statement returns ???? We know that each customer can have several orders and their corresponding shipping values. If we want to have the total number of orders we simply use count(*), but if we want to know total number of orders placed by EACH AND EVERY CUSTOMER, we have to group them using GROUP BY. Hope you understand well.

HAVING statement

SELECT CustomerID, count(*), sum(shipping) FROM Orders GROUP BY CustomerID HAVING count(*) >= 5

Hope u understand this. In general the HAVING statement is used along with the GROUP BY.

TWO RELATED TABLES

While Going through these statements, one should have a brief idea about primary key and foreign key working. Hope u know those things, if not please refer to them.

Joins

The first and the interesting thing is JOINS, these are little bit tricky but after u understand we can play with them.

There are 2 types of Joins

1. Inner Joins

2. Outer Joins

Frankly speaking, i hav never came through outer joins while developing websites, all our real time needs are covered with inner joins so here i am going to speak about INNER Joins.

SELECT Products.ProductID, Products.ProductName, ProductTypes.ProductTypeName FROM Products INNER JOIN ProductTypes ON Products.ProductTypeID = ProductTypes.ProductTypeID

Confused..!!!, Dont worry i know thi is a little bit tricky, i will tell a SHORT CUT for this, but before that try to understand this traditional statement.

To Understand this imagine that there are two tables "Products' & 'ProductTypes', by their names u can understand what data they contain, they both contain one common coloumn primary key i.e., ProductID

Now try to understand the above query again, the '.' is a connectivity between table and its coloumn. Observe the FROM keyword it should give the table details which are linked. Here the products table is linked with ProductTypes table so we used a Inner Join btn(between) them. Now the ON keyword, its requirement is very much needed, here it filters the details by telling that the ProductID's should match in both tables. If it is not mentioned the data will repeat many times. These queries need some practice. Hope i have contributed something for u.

SELECT p.ProductID, p.ProductName, pt.ProductTypeName FROM Products p INNER JOIN ProductTypes pt ON p.ProductTypeID = pt.ProductTypeID

This is same as the earlier but just used alias names for the tables, hope u dont need explanation

Using WHERE with JOIN

SELECT p.*, pt.ProductTypeName FROM Products p INNER JOIN ProductTypes pt ON p.ProductTypeID = pt.ProductTypeID WHERE p.ProductPrice > 30

THREE or MORE RELATED TABLES

SELECT c.LastName, o.OrderID, p.ProductName FROM Customers c
INNER JOIN Orders ON c.CustomerID = o.CustomerID
INNER JOIN OrderItems oi ON o.OrderID = oi.OrderID
INNER JOIN Products p ON p.ProductID = oi.ProductID ORDER BY c.LastName, o.OrderID

However, i think i covered the major real time useful queries which will be helpful in ur projects, there may be something that i left. If u find anything, post them as a comment.

Advise: Always try the queries on the database in offline before making the application online.

Hope this article may be useful.

Next Lesson is about Sub Queries Or Sub-Select Statements

Imp Data Types and When To Use Them

These are some of useful Data Types Just Have A Glance And Go

Big Numbers - int
Date & Time - smalldatetime
Small Numbers - smallint
Lots Of Text - varchar(max)
Yes/No - bit
Text Containing Unicode Symbols -nvarchar

GTALK Auto Reply

This is a small windows application, which takes the GMail's Username and Password and sends auto instant messages to the people who sends an IM to it.

It Will Run in the system tray and to logout just close it.

Download Link :

http://www.ziddu.com/download/8649114/GtalkAutoreply.rar.html

Password

mydoubts.wordpress.com

Remove Windows Not Genuine Notification

Follow These Steps To Remove the Windows Not Genuine Notification From Your PC.

Step 1:

Go to Task Manager(Press ctrl+Alt+Del)
kill the process named 'wgtray.exe'

Step2:

Restart The System In Safe Mode
(For this press F8 while booting & select Safe Mode)

Step3:

Go to C:\WINDOWS\system32
delete the file named 'wgtray.exe'

Step4:

Go to C:\WINDOWS\system32\dllcache
delete the file named 'wgtray.exe'

Step5:

Go To Registry Editor
(For this type 'regedit' in run box)

Step6:

Go to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogonnotify
and delete the 'wgalogon' folder

Step7:

del all wgatray.exe in regedit by searching

Step8:

Now reboot the system normally.


That's it No More Not Genuine Notification