Adsense tips and tricks to prevent AdSense Invalid clicks

AdSense - Invalid clicks
In some case it's possible that you getting clicks on AdSense,  but your adsense revenue not increasing so you may be depressed but its may due to that  Google AdSense 's monitoring system has considered it as AdSense - Invalid clicks.

  Google monitor all clicks and impressions on Google ads for any activity that may artificially drive up an advertiser's costs or a publisher's earnings.

How I can know my  AdSense - Invalid clicks
Because Google dose not charge for any AdSense - Invalid clicks ,so google also not pay you. You can check all Invalid clicks on 'Overview' page, under the Reports tab of you Adsense account.

What if I accidentally clicked on my own ads: Although publishers are not permitted to click on their own ads for any reason, Google do understand that accidental clicks may occur. Rest assured that your account is being properly credited for all clicks and impressions we consider to be valid.

So how can you be VICTIM of Invalid clicks

1. If you click on your website google ads FROM YOUR PC (same PC, which you use to login into Adsense Account).
2. If someone frequently clicks on your website adsense ads for ard. 5 - 10 times a day for ard. 5 - 6 days regularly.
3. If you send E-mail that requested to click on your site Google ads.
4. Ignore Adsense Program Policies & TOS
5. Buy, write, or use click-bot software. Click-bot software will go around your site and click on your ads. Most of the times, these click-bots are using proxies to avoid detection.
6. Extra words to make your visitors to notice your ads. Write “Click here” or “Please support us” or “Visit our sponsors”. Anything other than Google-approved “sponsored links” or “advertisements”.
7. Put your adsense code in email the email, usenet, RSS, etc.

Read more »

Detect Gtalk Invisible User

Detect G Talk Invisible -G talk Tips |  Find If user is invisible on Gtalk  or How to Detect invisible user in Gmail gtalk Chat?
G mail provide invisible mode facility in which any online user can read,write,even send E-mail without showing online on Google talk .

At some time when you want chat with any g talk user urgently and g talk user is showing offline in  google talk status doesn't mean that your friend is really offline.

Ya its fact Google talk  user might be in invisible mode in g talk, so displaying the  offline icon Google talk. At G talk tips  but know now How I can detect invisible  g talk user status (original status) .
Follow these step

1. Set the chat as off the record with target user how? ok Click on left corner of g talk messenger , Down arrow and select Go Off the record
   
2. you will see this message " You are now off the record (from now on, chats with ( gtalk user name ) will not be saved in ( gtalk user name ) 's Gmail account or yours) and there are two option Learn more Cancel "
   
   
   
   Note : This should be done when other gtalk user is online.
3. Now try sending chat to g talk user when he is invisible or offline.
4. In return if you see message in red color "“ did not receive your chat”. that means
   your gtalk friend is really offline in Gtalk. But if you have not receive error message from g talk it means   other side is invisible g talk user .

But always keep in mind  that when a chat is set off the record, it will no longer get stored in your Gmail account. If g talk user  is offline, your chat message will go to inbox as a mail. But when set chat off the record g talk can’t be delivered to inbox as mail

Read more »

Adsense Tips and Tricks

So in this post I will tell you about AdSense tips, learn how to improve your keywords and how to build theme-based content.
AdSense Tip

Position tips
Place the AdSense ads in a prominent place around the top/left part of your page or under your headlines, where your visitors are most likely to look at.

Improve keyword relevancy in adsense
Because its very helpful your site/blog because every internet visitor search on search engine for solution not for adsense, suppose you have business site and due to poor content on your own website google displaying auto parts Adsense its not good for you ,so keep relevancy with your site content and Google Adsense so when a visitor see relative keyword in google adsense on your site it may be that he/she click on Google Adsense

Right AdSense format
Wider formats are successful because the ads are compact, easy to read and are complementary to the content.

Read more »

PDF to HTML in Gmail

This is tech savy time so almost we have E-mail ID Gmail is one of the well known E-mail services provider.

If you have a Gmail ID then your friend,business partner,or family partner may be send you a PDF file in attachment,then its must you have install Adobe Reader in your personal computer to read that file but problem is that you have no install and don't want to install no problem :) now you can read a PDF file directly with out install Adobe Reader, how you can read it in your Gmail without Adobe Reader to read your PDF file click on view button .

You will see a “view” link in any email that contains a PDF attachment. The email has to actually contain the PDF and not just have a link to a PDF.

Read more »

How to open Multi Gtalk

Do you want to open multi Google talks so that you can chat easily,
To open multi Google Talk at same time just follow these steps:

1. Right-click on the desktop
2. Select New
3. Select Shortcut
4. Paste this into the text box: “c:\program files\google\google talk\googletalk.exe” /nomutex
5. Click Next
6. Name it whatever: Google Talk2 etc.
7. Click OK

More Detail (Second G talk hack tips)

1. First, create one copy of the Google Talk shortcut on your desktop - leave the original intact.
2. Right click on this shortcut and choose Properties.
   The Target box will show you the path of the EXE for Google Talk - something like “C:\Program Files\Google\Google Talk\googletalk.exe”
   
3. Change this to: “C:\Program Files\Google\Google Talk\googletalk.exe” /nomutex and click OK.
   
4. Now you can login with as many gmail accounts as you like.Enjoy!

Read more »

Change Facebook Theme Color, Appearance, Skin, Style or Template

It is a fact that almost everyone is on Facebook but it is also a fact that not everyone is happy with the default blue theme on Facebook. Some even consider it a turnoff while visiting Facebook.

It is relatively easy to change the Facebook theme to a stylish one using a Firefox addon and a custom theme which are available free of cost on the internet.

The final outcome would be something like in the image.

Requirement: The basic requirement for this to work is to have Mozilla Firefox 3.5 or higher.

Steps: The following steps should be carried out to successfully change Facebook theme.

1. Open Mozilla Firefox and install 'Stylish' addon.
2. Follow the basic steps and install the addon.
3. Restart Firefox after successfully installing the stylish addon.
4. Login to your Facebook Account and click on the small 'S' button in your Firefox status bar.
5. Click on "Find Styles for this Site" to open a new tab with free themes to use for Facebook.
6. Click on any theme and a preview will be shown.
7. If everything is fine in the previewed theme, click on "Install with Stylish" button at the top right corner of the page.
8. A dialog box will open.
9. Click on Install in the dialog box.

Now whenever you open Facebook, it will show the theme that you have installed with Stylish instead of the boring old blue theme.

Read more »

Download Facebook Account 's Information and Pictures

The download will be in the form of a zip file containing all your profile pictures, wall posts and videos. Your messages, friend list, photos, events, likes ( and almost everything you have ever uploaded on Facebook )also will be included in the downloaded zip file. Upon unzipping the downloaded zip file, you will find a simple HTML file of your profile with offline links to the above stated things.

Downloading your account will not mean that Facebook will delete your profile. It will only serve as a backup and a leisure activity to give time to on Sundays.

You can simply download your account by following the steps given below:-

1. Login to Facebook.
2. Click on Account.
3. Navigate to Account Settings.
4. Click on Download Your Information Link above the Deactivate your account link.

This link will only be available after you have entered your security question and confirmed your password. This additional security has been wisely added by Facebook so that no one else downloads your personal information.

Although this will be a good feature, Facebook will offer no way to re-import this information from your hard drive to your account or to a new account, if you wish to take a little break from Facebook.

Note: This feature is still not available on Facebook and will be available shortly as soon as Facebook completes testing it. I will update this post when this feature is publicly available.

Update: You can download your Facebook Account now as this feature is publicly available.

Read more »

How to Access Blocked Websites

Most of us find ourselves in situations where a website we wish to visit is blocked by a software or by our ISP (Internet Service Provider). So the question arises, how can we access blocked websites. The answer to this is simple: Proxy Servers. Before going into details, let us know a bit about proxy servers. 

Proxy Server

A proxy server acts as an intermediate source between the user and server the site being contacted is hosted on. Users send requests to proxy servers which convey them to the site's server. The reply received to the proxy server is forwarded to the user's computer. This gives an impression to ISP's and softwares that the user is visiting the site on which proxy server is hosted but in reality, s/he is visiting the site which was blocked. Thus, proxy servers provide extra security to users by making them browse the web almost anonymously.

Commonly Blocked Web Sites

The sites which are most commonly blocked by ISP's at workplaces, schools and offices are social networking sites like Facebook, Orkut and Twitter. In some countries, social bookmarking sites like Digg and Reddit are also blocked. Countries like Saudi Arabia, Pakistan, China have even blocked access to mainstream media websites like The New York times. A proxy server can be used to visit them and also to access websites which are restricted to particular countries and block users from other countries from accessing them. So, a proxy server becomes an absolute necessity for users who must visit blocked sites and supporters of free uncensored information.

Types of Proxy Servers

There are two types of Proxy Servers. First, the ones which are hosted on a website and have interactive design and second, the ones which do not have a website and interactive layout and only work on the basis of IP Addresses and Port Numbers. Proxy servers are also segregated on the basis of anonymity into Anonymous, Transparent and High Anonymous.

How to Find Proxy Servers

A simple google search containing the word "proxy servers" is likely to return a lot of proxy servers. But most of them are likely to be proxy servers which you can setup using IP Address and Port Number. So, in order to find interactive proxy servers, you will have to search "Facebook Proxy Server" or "Orkut Proxy Server". A search like this is most likely to return interactive proxy servers with which you can access your website by simply entering the URL in URL field. If you want additional security and anonymity, you can opt for a paid proxy server.

Note: The reason why links to proxy servers are not given is that most proxy servers stay up for short periods of time. Thus, a list containing outdated proxy servers will be of no use.

How to Setup Proxy Servers

If you wish to visit your blocked website using an interactive proxy server, you do not need any setup. But, if you wish to use proxy servers using IP Address, you must set them up.

Google Chrome and Internet Explorer Users

Google Chrome uses the same network settings as Internet Explorer. So, in order to use a proxy server in Google Chrome, you have to setup proxy server in Internet Explorer. You can setup a proxy server in Internet Explorer by following the instructions given below:-

1. Start Internet Explorer.
2. Click on Tools, Internet Options.
3. Click on Connections Tab, select your Network Connection and click on Settings.
4. Check on Use a Proxy Server for this Connection.
5. In the Address field, add the IP Address of your Proxy server and In the Port field, enter the Port Number of your Proxy Sever.
6. Click on OK and OK again.

Mozilla Firefox Users

Mozilla Firefox users can setup Proxy Servers by following the instructions given below:-

1. Start Mozilla Firefox.
2. Click on Tools, Options.
3. Click on Advanced Tab.
4. Click on Network tab.
5. Click on Settings.
6. Circle Manual Proxy Configuration.
7. Enter the IP Address and Port Number in the appropriate category. In most cases, it will be a HTTP server.  

After you have successfully setup the proxy server, you will be able to access blocked websites.

Read more »

Improve Cyber Security

How to make your PC secure from all the threats in the online world and improve cyber security? Not sure? Then read on. Here is a list of things you should know to improve your online cyber security:-

1. Anti-virus : Probably, one of the first thing which comes into one's mind when thinking about security. An anti-virus is an inevitable tool for the security of a PC. One can either choose a paid version of the anti-virus of his choice or opt for the equally effective free antivirus (only for private users). Before choosing the anti-virus, it is necessary to check whether the anti-virus has resident protection or not. Resident Protection automatically detects viruses when they are loaded into the memory and takes the appropriate action. Thus saving a user from sitting hours in front of the PC scanning viruses. It is important to check regularly for updates. Also do a quick scan (scanning Windows folder, registry, documents and recent downloads) at least once a week and a full scan at least once a month, even if your PC appears fine.

2. Anti-spyware: A spyware is a program which collects private information and sends it to its programmer. Spywares are considered more dangerous than viruses as they steal private information like Windows registration number, bank accounts, credit card's information, site logins, which can be used to harm a user in all possible ways. Login Accounts to social networks like Facebook and Orkut seem to be the prime target. Thus, it is necessary to have a good anti-spyware software with resident protection ,registry monitoring and browser monitoring. Again it is the user's choice to either opt for a paid one or for a free one. It is important to enable the automatic update function in the anti-spyware software and to do a quick scan of the PC once a week. It is also necessary do a full scan once every month for best results.



3. Firewall: A firewall prevents unauthorized or malicious applications from reaching a computer. A firewall is basically needed to protect a PC against Trojans, spyware, worms, hackers, hijackers and other known and unknown threats. However a firewall must not be assumed an alternative to the anti-virus or anti-spyware software. Before choosing a firewall, the most important thing to keep in mind is the ease of use and the amount of customization possible. An often overlooked factor upon choosing a firewall is the amount of resources consumed by it. Keeping all these factors in mind, a good firewall software(free or paid) must be chosen. It is important to read the alerts displayed by it carefully, and select an appropriate action to do.

4. Anti-spam: Anti-spam software has become important because of the amount of spams received by internet users frequently. These scams are the most common cause of cyber crime. Installing one and using it is easy. So don't worry about how to use one. But the only difficult thing is to be patient with it. Its performance will improve over time. You can download any of the free anti-spam available over the web or can opt for a paid version.


5. Windows Update: A very important factor for PC security is updating Windows. It is important to enable Automatic Updates in Windows which helps to get all the latest security fixes. Getting these updates will help Windows work better and will make one's working more secure.


6. Backing Up: It is important to back up all your important data to have a copy of it whenever needed in case of a virus attack. A back up comes in handy in such unexpected situations.

Read more »

Making Blogger Title Tags SEO Friendly

One of the biggest problems I face with Blogger blogs is the inability to create custom SEO and human friendly title tags. Blogger does not give us any option to change the way title tags are in post pages. Titles of post pages in Blogger are always in the following form:
[Blog Title] : [Post Title]
In this case when you have a bit long Blog Name, all your pages in the Search Engine index would start with the blog name taking most of the previous space. That way it wouldn’t be relevant to the content of the post in most cases
The following form of title would be considered good:
[Post Title] : [Blog Title]
Or if your blog’s name is too long you can use just the title:
[Post Title]
People have always been trying to come up with ways to create custom title tags in Blogger, some used a hack few months back known as the Widget Based Title Tag hack which NO longer works from quite some time. Even I used that method here on my blog. But, as I said, after sometime Blogger wouldn’t let that hack work. Again some people found a slightly different method that WORKED but pissed off the HTML compliance really bad as title tag was placed outside of the <head> tag. So the fact is before 9th May there really was no way you could have custom titles and those who already had the hack working, couldn’t edit the Template code anymore without switching back to the normal title structure.
The Method
Below I’m outlining a very simple and 100% working way of having custom titles in Blogger:
<b:if cond='data:blog.pageType == &quot;item&quot;'>
<title><data:blog.pageName/> | <data:blog.title/></title>
<b:else/>
<title><data:blog.pageTitle/></title>
</b:if>
Copy and paste the above code replacing the <data:blog.pageTitle/> line in your template code.
Or if you want the posts to have just the post title in the title tag and NO blog name or if your blog name is too long, you may use the following code, again replace <data:blog.pageTitle/> line with this code.
[Go to Layout->Edit HTML to place these codes.]
NOTE: Titles of pages are very critical when it comes to Search Engines not just from SEO point of view but also from human perspective. It’s a known fact that even if your website ranks higher but has irrelevant (same looking titles) for all the pages, chances are peoples would rather click on lower ranking pages having relevant titles.

Read more »

Add 'Link to This Post' widget on Blogger

When it comes to Search Engine rankings, link popularity is no doubt one of the most important factors especially organic link popularity.
Nowadays Search Engines’ algorithms have become so intelligent and sophisticated that they could differentiate between different types of links; paid, reciprocal, organic etc. to name some, automatically and not let discouraged factors manipulate rankings much (in some cases by even penalizing those site).
Coming to Organic Link Building, there is no better way to do (or at least increase) Link Building than to ask or encourage your visitors. You see, I’ve it at the bottom of this post. This way you are asking peoples for links as well as providing them with the HTML code to ease the process a bit. Now if peoples like our post or site and HTML code is what they have to copy and paste, you stand a better chance of getting links than with many other techniques. One more BIG advantage is that as the code would generate anchor text (text of the hyperlink) same as the post title, again odds are that you’d get your main and relevant keywords in the links; rather than ‘this great post’ which some peoples prefer!
Below is the code that does this:
<!-- By http://technary.com/ -->
<div align='center' style='border: 1px solid #646464; padding: 10px; margin: 20px;'> 
<p style='font-size: 150%; background: #C8C8C8; padding: 5px;'>Show Some Love!</p>
<p>If you like this post please consider 
  making a reference to it from other Blogs, Forums, Profiles etc. by copying 
  and pasting the following HTML code. Thank You!<br/>
  <br/>
<textarea cols='40' id='bloglinking' name='bloglinking' onFocus='select()' rows='3'>&lt;a href=&quot;<data:post.url/>&quot;&gt;<data:post.title/>&lt;/a&gt;</textarea><br />
    <!--My Link-->
    <font color="#999999" size="1"><em>Link To This Post </em>Widget by <a href="http://learning-computer-programming.blogspot.com/">Learning 
    Computer Programming</a></font></p>
    <!--/My Link-->
</div> First, you may want to change text so as to be unique in asking people to link to you ;-).
WARNING: You must not delete my link
Now you are ready with code, open your Blog’s Dashboard move to Layout -> Edit HTML, tick Expand Widget Template check box. Now there are two places where you can place it, either at the top or at the bottom (like mine) of the post, I personally prefer it at the bottom.
To place it at the TOP, find some code that looks like below (in the middle of the code listing):
...
...
<div class='post-header-line-1'/>
<div class='post-body'>
[--PUT THE CODE HERE--]
<p><data:post.body/></p>
<div style='clear: both;'/> <!-- clear for photos floats --></div>
<div class='post-footer'>
<p class='post-footer-line post-footer-line-1'><span class='post-author'>
<b:if cond='data:top.showAuthor'>
<data:top.authorLabel/> <data:post.author/>
</b:if>
...
...
And place our code as and where stated.
To have it at the BOTTOM, paste the code in a slightly different place as::
...
...
<div class='post-header-line-1'/> <div class='post-body'>
<p><data:post.body/></p>
<div style='clear: both;'/> <!-- clear for photos floats --></div>
<div class='post-footer'>
[--PUT THE CODE HERE--]
<p class='post-footer-line post-footer-line-1'><span class='post-author'>
<b:if cond='data:top.showAuthor'>
<data:top.authorLabel/> <data:post.author/>
</b:if>
...
...

Read more »

Changing Templates without loosing Widgets

The other day when I was trying to change the Template of this blog I faced a rather disheartening problem. Blogger said that all the Widget along with their data will be lost when changing to a third-party template. As you can see I have a link list (big one) on the sidebar, it has links to all my posts so far (>180!), man could I afford to loose that? Of course NOT!
Good thing was switching to one of the templates provided by Blogger wouldn’t make me loose those widgets. Bad thing is I don’t like those templates. Those are all too old, excessively used everywhere and 2-column ones.
So what did I do to save my widgets when changing to a third party Blogger template? Read along to know…(this might look like a crappy landing page that’d sell you something, believe me its NOT!)
If you too are facing the same problem you can take these steps to save your widgets:
STEPS:
1. Start off by going to Layout-> Edit HTML then click on Expand Widget Template check box.
2. Search for <b:widget in the template code and copy the widget section code.
e.g.:
...
<div id='sidebar-wrapper'>
<b:section class='sidebar' id='sidebar' preferred='yes'>
<b:widget id='HTML1' locked='false' title='Search this Blog' type='HTML'>
<b:includable id='main'>
<!-- only display title if it's non-empty -->
<b:if cond='data:title != &quot;&quot;'>
<h2 class='title'><data:title/></h2>
</b:if>
<div class='widget-content'>
<data:content/>
</div>

<b:include name='quickedit'/>
</b:includable>
</b:widget>
<b:widget id='LinkList1' locked='false' title='Recent Posts' type='LinkList'>
<b:includable id='main'>

<b:if cond='data:title'><h2><data:title/></h2></b:if>
<div class='widget-content'>
<ul>
...
Do it as many times as needed to copy all the widgets. Paste them one after to other in Notepad. You can leave the unnecessary ones such as Header, Blog (There is a widget for this too, shows the posts) etc. the code of which would look something like below:
No need to copy these:

• <b:widget id='Header1' locked='true' title='For Testing Purpose (Header)' type='Header'>
• <b:widget id='Blog1' locked='true' title='Blog Posts' type='Blog'>

3. Now copy the new template code by opening the XML file in another Notepad. Paste it in Blogger deleting the old template code.
4. Find the following line in the newly pasted template code:
...
<div id='sidebar-wrapper'>
<b:section class='sidebar' id='sidebar' preferred='yes'>
[--PASTE WIDGETCODE HERE--]
5. Paste all the widget codes previously copied there right after the <b:section line.
6. Save the template.
7. If you had not copied some unnecessary widget codes from the original template, Blogger might ask you to confirm their deletion. Confirm this and SAVE the template.
8. Done!
Doing this you’d save existing widget from getting deleted when switching template but the widgets will NOT be arranged or placed in any meaningful manner (they’d all be in a sidebar). To re-arrange them in the manner you want just go to Layout-> Page Elements and drag drop the widgets as required, click save. You’re done!

Read more »

View Crystal Report in Visual Basic 6

This sample code view the crystal report file (Employee.rpt) , please don't forget to add the Crystal Report Component or you got an error.

Private Sub cmdEmployee_Click()

On Error GoTo errHandler

    If Right(App.Path, 1) = "\" Then

        rep1.ReportFileName = App.Path + "Employee.rpt"

    Else

        rep1.ReportFileName = App.Path + "\" + "Employee.rpt"

    End If

    rep1.Action = 1

    Exit Sub

errHandler:

    MsgBox Str(Err.Number) + " " + Err.Description

End Sub

Read more »

Get Computer Name in Visual Basic 6

Private Declare Function GetComputerName Lib "kernel32" Alias "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long

Function Get_CompName() As String
    ' Returns the name of the local computer.
    Dim BUFFER As String * 512, length As Long
    length = Len(BUFFER)
    If GetComputerName(BUFFER, length) Then
        ' this API returns non-zero if successful,
        ' and modifies the length argument
        Get_CompName = Left(BUFFER, length)
    End If
End Function

Read more »

Create a Hot Key in Visual Basic

What is a Hot Key Control
A hot key is a key combination that the user can press to perform an action quickly. For example, a user can create a hot key that activates a given window and brings it to the top of the z-order. The hot key control displays the user's choices and ensures that the user selects a valid key combination. Here's the code below on how to create a hot key control.

Declare Function SendMessage Lib "user32" Alias _

"SendMessageA" (ByVal hwnd As Long, _

ByVal wMsg As Long, ByVal wParam As Long, _

lParam As Long) As Long

Declare Function DefWindowProc Lib "user32" _

Alias "DefWindowProcA" (ByVal hwnd As Long, _

ByVal wMsg As Long, ByVal wParam As Long, _

ByVal lParam As Long) As Long

Public Const WM_SETHOTKEY = &H32

Public Const WM_SHOWWINDOW = &H18

Public Const HK_SHIFTA = &H141 'Shift + A

Public Const HK_SHIFTB = &H142 'Shift * B

Public Const HK_CONTROLA = &H241 'Control + A

Public Const HK_ALTZ = &H45A

'The value of the key-combination has to

'declared in lowbyte/highbyte-format

'That means as a hex-number: the last two

'characters specify the lowbyte (e.g.: 41 = a),

'the first the highbyte (e.g.: 01 = 1 = Shift)

Private Sub Form_Load()

Me.WindowState = vbMinimized

'Let windows know what hotkey you want for

'your app, setting of lParam has no effect

erg& = SendMessage(Me.hwnd, WM_SETHOTKEY, _

HK_ALTZ, 0)

'Check if succesfull

If erg& <> 1 Then

MsgBox "You need another hotkey", vbOKOnly, _

"Error"

End If

'Tell windows what it should do, when the hotkey

'is pressed -> show the window!

'The setting of wParam and lParam has no effect

erg& = DefWindowProc(Me.hwnd, WM_SHOWWINDOW, _

0, 0)

End Sub

Read more »

How to Hide Application in Windows Task List

This code will hide your application in windows tasklist using visual basic when user press the ctr + alt + delete in keyboard. This type of program is very useful if you don't want your users/clients to close the application through windows tasklist. 

Here's the code sample below.

Declare Function SetWindowPos Lib "user32" (ByVal hwnd _

As Long, ByVal hWndInsertAfter As Long, ByVal x As Long, _

ByVal y As Long, ByVal cx As Long, ByVal cy As Long, ByVal _

wFlags As Long) As Long

Declare Function FindWindow Lib "user32" Alias _

"FindWindowA" (ByVal lpClassName As String, ByVal _

lpWindowName As String) As Long

Const SWP_HIDEWINDOW = &H80

Const SWP_SHOWWINDOW = &H40

Private Sub Command1_Click()

Dim Thwnd as Long

Thwnd = FindWindow("Shell_traywnd", "")

Call SetWindowPos(Thwnd, 0, 0, 0, 0, 0, SWP_HIDEWINDOW)

End Sub

Private Sub Command2_Click()

Dim Thwnd as Long

Thwnd = FindWindow("Shell_traywnd", "")

Call SetWindowPos(Thwnd, 0, 0, 0, 0, 0, SWP_SHOWWINDOW)

End Sub

Read more »

Visual Basic SQL Select Statement

The SELECT statement is used to select data from a database.

The result is stored in a result table, called the result-set.

SQL SELECT Syntax is
 

This statement select only one column of the database field.

SELECT column_name(s)  FROM table_name

This SQL statement select all the fields of the database using the (*) asterisk

SELECT * FROM table_name

Here's the sample SQL statement below.

Figure 1

Select IDNo,LastName,FirstName,MI FROM EmployeeTbl Where  IDNo= '12345' 

Figure 2

Select * FROM EmployeeTbl Where IDNo='12345'

A SQL SELECT statement can be broken down into numerous elements, each beginning with a keyword. Although it is not necessary, common convention is to write these keywords in all capital letters. In this article, we will focus on the most fundamental and common elements of a SELECT statement, namely

• SELECT
• FROM
• WHERE
• ORDER BY

The SELECT ... FROM Clause

The most basic SELECT statement has only 2 parts: (1) what columns you want to return and (2) what table(s) those columns come from.
If we want to retrieve all of the information about all of the customers in the Employees table, we could use the asterisk (*) as a shortcut for all of the columns, and our query looks like

SELECT * FROM Employees

If we want only specific columns (as is usually the case), we can/should explicitly specify them in a comma-separated list, as in

SELECT EmployeeID, FirstName, LastName, HireDate, City FROM EmployeesTable

The WHERE Clause

The next thing we want to do is to start limiting, or filtering, the data we fetch from the database. By adding a WHERE clause to the SELECT statement, we add one (or more) conditions that must be met by the selected data. This will limit the number of rows that answer the query and are fetched. In many cases, this is where most of the "action" of a query takes place.
We can continue with our previous query, and limit it to only those employees living in London:
SELECT EmployeeID, FirstName, LastName, HireDate, City FROM Employees WHERE City = 'London'

The ORDER BY Clause

Until now, we have been discussing filtering the data: that is, defining the conditions that determine which rows will be included in the final set of rows to be fetched and returned from the database. Once we have determined which columns and rows will be included in the results of our SELECT query, we may want to control the order in which the rows appear—sorting the data.

To sort the data rows, we include the ORDER BY clause. The ORDER BY clause includes one or more column names that specify the sort order. If we return to one of our first SELECT statements, we can sort its results by City with the following statement:

SELECT EmployeeID, FirstName, LastName, HireDate, City FROM EmployeesTable
ORDER BY City

Read more »

Sample Code to Fill Datagrid View in Visual Basic.Net

Sample on how to Fill the Datagrid View in Visual Basic .Net

'Here's the code below.

Dim query as string="Select * from EmployeeTable"
Dim da as new oledbdataadapter(query,con)

dim ds as new dataset

da.fill(ds,"EmployeeTable")

me.dgv.datasource=ds
me.dgv.datamember="EmployeeTable"

ds.dispose

con.close

Read more »

Connect Oracle Database using Visual Basic

'How to connect Oracle Database from Visual Basic

'Sample code and connection strings to connect Oracle using Visual Basic:

Dim conn As ADODB.Connection

' Open a Conn_Dataection using Oracle ODBC.

Set Conn_Data = New ADODB.Connection

Conn_Data.ConnectionString = "Driver={Microsoft ODBC for Oracle};" & "UID=user_name;PWD=user_passsword"

Conn_Data.Open

'Open the table as in:

Dim rs_Data As ADODB.Recordset

' Open the table.

Set rs_Data = New ADODB.Recordset

rs_Data.Open "TableName", Conn_Data, adOpenDynamic, adLockOptimistic, adCmdTable

'Enter the user name password and table name as per the database.

'it must be valid one.

'To reads the data from the table and displays the values in a ListBox

' List the data.

Do While Not rs_Data.EOF

    txt = ""

    For Each fld In rs_Data.Fields

        txt = txt & Trim$(fld.Value) & ", "

    Next fld

    If Len(txt) > 0 Then txt = Left$(txt, Len(txt) - 2)

    List1.AddItem txt

    rs_Data.MoveNext

Loop

'Finally close the recordset and close the Conn_Dataection:

rs_Data.Close

Conn_Data.Close

Read more »

Password Generator in Visual Basic

'A sample visual code on how to generate a best random password generator

Public Function GeneratePassword(ByVal lngLength As Long) _

  As String

On Error GoTo Err_Proc

 

 Dim iChr As Integer

 Dim c As Long

 Dim strResult As String

 Dim iAsc As String

 Randomize Timer

 For c = 1 To lngLength

  

   'Randomly decide what set of ASCII chars we will use

   iAsc = Int(3 * Rnd + 1)

  

    'Randomly pick a char from the random set

   Select Case iAsc

     Case 1

       iChr = Int((Asc("Z") - Asc("A") + 1) * Rnd + Asc("A"))

     Case 2

       iChr = Int((Asc("z") - Asc("a") + 1) * Rnd + Asc("a"))

     Case 3

       iChr = Int((Asc("9") - Asc("0") + 1) * Rnd + Asc("0"))

     Case Else

       Err.Raise 20000, , "GeneratePassword has a problem."

   End Select

  

   strResult = strResult & Chr(iChr)

 Next c

 GeneratePassword = strResult

Exit_Proc:

 Exit Function

Err_Proc:

 MsgBox Err.Number & ": " & Err.Description, _

    vbOKOnly + vbCritical

 GeneratePassword = vbNullString

 Resume Exit_Proc

End Function

Read more »

Poll your twitter followers using tools

To make things easier for you, there are a few great tools to create Twitter polls. All of these services are super easy to use. All you need to do is fill out the form with your question and answers and post to Twitter.

TwtPoll

Its the best twitter polling to your followers.

PollDaddy

 

StrawPoll

Read more »

Creating a Better Twitter Username

If you have chosen a bad name when you signed  up with Twitter, change it as soon as possible and if you are new to the service, I suggest you take some time and get a good username. With Twitter’s rapid growth it’s probably already too late to get the name you want for your Twitter profile. But don’t give up and settle for some crap name. As I will show you below, there’s always something to come up with.

If your preferred username is taken or you don’t want to use your name, be creative. Make it meaningful. Make it funny. Make it easy to read and remember! Do something that interests us. It will pay off. But don’t use any bad words in your name.
If you desired username is already in use, Twitter allows underscore, characters and numbers in your username, if you need them. I will use the name John Smith to show you a few different ways of creating a Twitter username. Keep in mind that a Twitter username can only be 15 characters long.

Read more »

Find who tweets about your Website or Blog

If you want to stay on top of what is going on with your or someone else’s online brand (blog or website), you will want to pay attention to what is being said or who links to it. Searching for keywords and hashtags on Twitter will not be good enough for you. You will want to search for website links as well. But since pretty much everyone on Twitter uses an URL shortening service, Twitter’s search will not return good results. Don’t get me wrong, Twitter’s search is great, but it has a few shortcomings. One of them is that it can’t catch those tweets that have linked to a website or blog, because the URL have been shortened. This is where BackTweets comes into play.

With BackTweets you can search for links on Twitter. You simply enter the URL you want to search for and it will automatically resolve shortened URLs and return a chronological list of tweets with the requested link.
In addition, BackTweets provides an RSS feed so that you can be notified automatically as new relevant tweets appear.
With this tool I am able to find many tweets that I was unable to find with Twitter search. BackTweets has become one of the Twitter tools that I use on a regular basis. And if you need to stay on top of what’s being said on Twitter, you should take a closer look at it too.

Read more »

5 Best ways to share Videos on Twitter

Video sharing is surely possible on Twitter.

Use the following websites to share your videos on Twitter.

• TwitVid.io is really simple to use. Log in with your Twitter credentials, choose a video file and post. Works pretty much the same as TwitPic.
• Twiddeo is a powerful but simple service that let’s you do one thing very well: Twitter updates with Video. Upload from the web, your cameraphone and record from your webcam.
• TwitC is a great tool for sharing photos, videos, and a myriad of different file types with Twitter, it’s a multipurpose hosting service for Twitter.
• TwitLENS is another tool that handles both video and photo sharing. What I like about it is that it supports Twitter OAuth for secure login.
• TweeTube allows you to share webcam videos, YouTube videos, photos and website URLs. The site looks neat.

Read more »

Twitter Tips for Beginners

When you first join Twitter, fill in your bio page and don’t forget to add the link to your website. First thing people will look at is your profile and they will want to see your place on the web. If there’s nothing to see in your bio, chances of anyone following you go down dramatically.
Use an avatar that is actually showing you, preferably your face and not your dog or cat. Group pictures are not a good idea either, because people don’t know which one is you. And try to upload a photo that is not all blurry and out of focus.

Don’t use too many one word tweets, write full sentences and don’t forget about grammar. It is very annoying to read all small letters without punctuation.
If you really want to autofollow back when someone follows you, please don’t use an autoreply to ask me to visit your site. If someone is going to follow you they will check out your site anyway.
Do not follow hundreds of people right away. It looks suspicious if you follow many and nobody follows you back. If you do this they will think you are using a bot and most probably will not follow you back.
Don’t rush to build up your network, you can start by following your friends. Then you can check out the people your friends are following, you may even know some of them.

Read more »

8 Twitter tools to Manage and Analyze followers

Twitter Analyzer

Twitter Analyzer is very advanced Twitter analytic system. Unlike many other Twitter tools, Twitter Analyzer does not require you to enter you Twitter password. You simply type in the @name of who you’d like to analyze and it will show you really many statistics about that user and his followers.
It can show you who are your closest friends on Twitter by showing you who retweets your messages. You can see who is writing about you,  how popular are you and your friends, map locations of your friends and much more. All that in very nice and easy to read graphs. I could keep going on, but take a look for yourself.

Tweet Stats

TweetStats is another great tool to analyze Twitterers. Similar to Twitter Analyzer, but with fewer options. Type the Twitter ID that you would like to analyze and TweetStats will then automatically generate a detailed report about the tweeting style and trend of the user.

It will show you tweeting density of a user, so you can see at what time of the day they tweet the most, as well as number of tweets in a particular month, day, or week. You can as well see what interface (web, TweetDeck, etc) they use the most for tweeting.

Manage your friends and followers with tags

With Twittangle you can rate and tag your friends and filter them on a timeline. You can also create custom groups of your followers and filter your timeline by that group. It’s quite an effective tool.

Friend or Follow?

Who are you following that’s not following you back? Who’s following you that you’re not following back? Find out on FriendOrFollow. All you need to do here is enter your Twitter name and it will show you the results. Too bad it only shows you stats, so you will have to manually follow or unfollow those people.

What is your Twitter Karma?

Twitter Karma is one of my favorite tools to manage followers. It shows you who does not follow you back, who are those that only follow you and you don’t follow them and more. With just a few clicks you can mark those you don’t want to follow anymore and it will automatically unfollow them. Additionally, you can mark those that you want to follow and it will follow them all at once. You can mass follow, unfollow, delete and block people with Twitter Karma, which would take you ages to do on Twitter itself.

Tweepler

Tweepler displays a list of new followers of your Twitter account. Click on the left arrow to follow them back or the right arrow to ignore them. Ignore only archives them out of the way and only acts for organizational purposes. Do not confuse this ignore with Twitter’s block functionality, it is not the same.
Optionally click the More Details link. This will show you detailed information like average tweets, total tweets, number of followers, number following and the followers to following ratio.

Tools to identify and unfollow inactive accounts

Over time many of your followers have probably become inactive for various reasons. If you follow back most people that follow you, then you will eventually get some inactive followers. There’s no point following dead accounts that give no value. With these tools you can find inactive accounts and unfollow them with ease.
Here are a few web based Twitter tools that will automatically unfollow inactive accounts: Huitter, MyCleenr and UnTweeps.
Twittoria is another tool that will identify inactive accounts, but will not automatically unfollow them. You will have to do that manually.

Learn more about your followers

With TwitterSheep you can see what types of people are following you and your tweets. Enter your twitter ID and within seconds, a tag cloud will be generated. Below is a word cloud generated from bios of my followers. Looks like my followers are mostly into social media, marketing, blogging and internet stuff.

Read more »