Rss Feed Like Us on facebook Google Plus

November 20, 2013

Ways to Prevent from Popular Online Scams

Online Scams can be done in many forms to your computer,phones or website. so this article going to cover some popular online scams and ways to prevent from it...
The use of Internet services or software with Internet access to defraud victims or to otherwise take advantage of them, for example by stealing personal information, which can even lead to identity theft. A very common form of Internet fraud is the distribution of rogue security software. Internet services can be used to present fraudulent solicitations to prospective victims, to conduct fraudulent transactions, or to transmit the proceeds of fraud to financial institutions or to others connected with the scheme.
Internet fraud can take many forms: identity theft, injecting malware, fraudulent transactions. It can occur through e-mail, smartphones, websites, and chat rooms. Here are some such scams and ways to avoid them.

These are the sites that are not legitimate and have malicious software to hack your personal information. A lot of such infected sites come up during festive season, when people are buying gifts online, and hackers build these using popular search items. Another variation of infection is legitimate sites that get heavy traffic and, hence, are injected with ads and images that have viruses. 
>> A good way to avoid these is to go with familiar, popular sites or install ad blockers on your browser.

2) Fake phone apps

Be very careful about the apps that you download on your phone. Android and Apple phones are particularly vulnerable to fake apps in their stores, and these can introduce malware that steals the datayour phone. 
>> To avoid fake apps, check the users' review about the game or app before you download it. You can also go to the developer's website and get more information about the app before zeroing in on it. Another safe option is to go for the most downloaded apps or those that come with the 'editor's tag'. Avoid the apps that are 'paid' but are being offered for free, or ask for too much information.

3) International dialling

If your Internet connection is through a modem using a local telephone number, beware. Some sites lure people into viewing content that requires them to download a dialler or viewer. If you do so, your computer will be disconnectedthe Net and will instead be used to dial an international number, resulting in high phone bills. 
>> To safeguard yourself, avoid sites that require you to download a program to view content. You can also have your line blocked making international calls. Also make sure your computer has anti-malware software to detect any illegal activity.

This is probably the oldest known scamming technique that is still going strong. Here e-mails, purportedly sent outwell-known institutions and social networking or payment sites, are used to draw out sensitive, personal informationpasswords and credit card details. These mails could also carry links to infected sites.

>> A preventive step is to never give out personal information and call up the company to crosscheck that the e-mail is genuine. Also scan the url for security (use of https in the address bar means it is safe).

5) Pharming

A combination of 'farming' and 'phishing', this term refers to the process by which a hacker gets a domain name for a site and then uses it to redirect this site's traffic to another, bogus website. It can comp romise serious information and cause heavy losses if the site being copied is that of a bank or taxation department. It can also be used to steal passwords, PIN or account numbers.

>> The best way to prevent this is to make sure you use secure Web connections (https) to access privacy-sensitive sites.

6) Wi-Fi hacking

If you use a public Wi-Fi connection, such as at airport terminals or coffee shops, to log into your account, you stand the risk of having your password and private information hacked. The hacker can also access your browsing history. This is especially true if you save the password to your account. 
>> If you are using a smartphone to access your account, try to use the 3G or 4G connection as it is more secure.

7) Auction/shopping scams

With online shopping and auction sites—wherein you put up household items and gadgets for bidding and sale— becoming popular, the scope of fraud has increased. You could be scammed out of your money by not receiving the goods at all, getting poor quality items, or beingged more than the price mentioned. Your credit card information could also be used fraudulently. Besides, the seller could be defrauded if he doesn't get any payment.

>> To avoid it, make sure you know as much as possible about the item and seller/buyer. The latter shouldn't have just an e-mail or a post office box address. Call him up and ask him about the address and extrages. Also go through the feedback.

8) Investing scams

Here, the prices of stocks are manipulated by sending out false information about the companies through e-mails, chat forums or Internet boards. This results in a rise or fall in the prices of stocks and the scamster benefits by selling or buying shares at the right time. In another variation of investing scam, which came under the Sebi scanner recently, companies were offering 'guaranteed return' schemes through e-mails, websites, blogs and social media platforms, and conning people out of their money. 
>> The best way to avoid it is to conduct your own research about the company, and not invest in schemes that promise outrageous returns.

9) Employment fraud

There are two variants of this scam. The more common one involves job offers by recruiters that require you to pay an advance fee or make a deposit, without the job ever materialising. The second one typically offers you the job of a 'representative' of an overseas company and your task is to collect customers' deposits in your account and remit most of it to the company abroad. In doing so, you could not only be a victim of identity theft, but also have money stolenyour account.

>> Avoid any such offers without verifying the company and do not give out personal information.

10) Click scams 

Have you ever clicked on the game strips or dancing/jumping figures that pop up and move across your screen while you are on social networking or other sites? 
>> Don't click on on the game strips or dancing/jumping figures . These could be fake and could lead you to click on concealed links, which either make your personal information public or provide access to confidential information stored on your computer.
Read More

November 19, 2013

Charge your Smart Phone with Sunglasses

What can you do with your sunglasses when the Sun goes down? You can use them to chargeyour smartphone! An Indian designer based in the US has turned a pair of sunglasses into a smartphone charging device by adding solar panels to them.

Sayalee Kaluskar's The Ray-Ban Shama Shades are part of a project at Miami Ad School - San Francisco, CNET reported. The shades have a small solar panel on each arm, and that's apparently enough to charge a smartphone when the Sun goes down.

According to, Kaluskar placed small solar panels on each side of the frame, allowing the sunglasses to harness solar energy during the day.

At night, the frames can be detached and used to charge a smartphone, the report said. Kaluskar worked with Ramiro Ramirez on the project as part of their student work.

Experts say people are keen on tapping solar energy on the go, provided they can harness enough of it to be useful.
Read More

November 18, 2013

Retrieve Data from Client Machine DataBase on Web using Javascript Active-X object

To Retrieve data from Local database you can use JavaScript simulation using Active-X
object on your Website.

If all of your users are on Windows computers, you could use ADO or ODBC to connect to a corresponding database. checkout the example

This script will work only on Internet Explorer



<script id="clientEventHandlersJS" type="text/javascript">
        function GetData() {
            var connection = new ActiveXObject("ADODB.Connection");
            var connectionstring = "Data Source=AJIT-LAPTOP\\sqlexpress;Initial Catalog=user;User ID=ajit;Password=ajit;Provider=SQLOLEDB";
            if (connection) {
                var rs = new ActiveXObject("ADODB.Recordset");
    //FOR Single Record
                var userid = document.getElementById("txtuserid").value;
      "select password from userdetail where userid='" + userid + "'", connection);
                if (!rs.EOF) {
                    var c1 = rs.fields("userid").value;
                else {
                    alert("Record Not Found");
              //For Multiple Records
          rs.Open ("select col1,col2 from tbl_test", conn,0,1);
          while (! rs.EOF)
             c1 = rs.fields("col1").value;
             c2 = rs.fields("col2").value;
             document.write(c1+' - '+c2+'<br>');
             rs.MoveNext ();
                rs = null;
                return true;
            else {
                return false;


<form id="form1" runat="server">
               USER ID: <input type="text" id="txtuserid" runat="server" />
                <input type="button" id="btn" onclick="javascript:return GetData()" style="width: 80px;
                    height: 30px;" value="OK" runat="server" />

Read More

November 17, 2013

AngularJS open-source JavaScript framework, maintained by Google

Its provide browser-based applications with MVC capability, in an effort to make easier development and testing.The library reads in HTML that contains additional custom tag attributes; it then obeys the directives in those custom attributes, and binds input or output parts of the page to a model represented by standard JavaScript variables. The values of those JavaScript variables can be manually set, or retrieved from static or dynamic JSON resources.


Angular JS Script:

 <script src=""></script>

Angular directives:AngularJS directives allow developer to specify custom and reusable HTML tags that moderate the behavior of certain elements.

1: ng-app 
Declares angularJS as a root element of the application allowing behavior to be modified through custom HTML tags.
<html ng-app>

2: ng-bind
Automatically changes the text of a HTML element to the value of a given expression.
<div ng-controller="Ctrl"> 
 Enter name: <input type="text" ng-model="name"><br> 
 Hello <span ng-bind="name"></span>

3: ng-model
Similar to ng-bind, but allows two-way data binding between the view and the scope.
 <input type="text" ng-model="name">

4: ng-class 
Allows class attributes to be dynamically loaded.  
<span class="base-class" ng-class="..">

5: ng-controller 
Specifies a JavaScript controller class that evaluates HTML expressions. 
<body ng-controller="...">

6: ng-repeat
Instantiate an element once per item from a collection. 

7: ng-show & ng-hide
Conditionally show or hide an element, depending on the value of a boolean expression. 
<div class="check-element animate-show" ng-show="checked">

8: ng-switch
Conditionally instantiate one template from a set of choices, depending on the value of a selection expression.  

9: ng-view
The base directive responsible for handling routes that resolve JSON before rendering templates driven by specified controllers. 

10: ng-if 
Basic if statement directive which allow to show the following element if the conditions are true.

<!doctype html>
<html ng-app>
<script src=""></script>
<input type="text" ng-model="yourName" placeholder="Enter a name here">
<h1>Hello {{yourName}}!</h1>

Learn More...
Read More

November 7, 2013

How to use Cursor in SQL Server

A cursor is a set of rows together with a pointer that identifies a current row.

Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time. For example, you can use cursor to include a list of all user databases and make multiple operations against each database by passing each database name as a variable. it's like record-set in ASP and Visual Basic

Declaring a Cursor

Before using cursor, you first must declare the cursor, i.e. define its scrolling behavior and the query used to build the result set on which the cursor operates. To declare cursor, you can use a syntax based on the SQL-92 standard and a syntax using a set of Transact-SQL extensions.

FOR select_statement
[FOR {READ ONLY | UPDATE [OF column_name [,...n]]}]

cursor_name - the name of the server side cursor, must contain from 1 to 128 characters.

INSENSITIVE - specifies that cursor will use a temporary copy of the data instead of base tables. This cursor does not allow modifications and modifications made to base tables are not reflected in the data returned by fetches made to this cursor.

SCROLL - specifies that cursor can fetch data in all directions, not only sequentially until the end of the result set. If this argument is not specified, FETCH NEXT is the only fetch option supported.

select_statement - the standard select statement, cannot contain COMPUTE, COMPUTE BY, FOR BROWSE, and INTO keywords.

READ ONLY - specifies that cursor cannot be updated.

UPDATE [OF column_name [,...n]] - specifies that all cursor's columns can be updated (if OF column_name [,...n] is not specified), or only the columns listed in the OF column_name [,...n] list allow modifications.

Opening a Cursor

Once a cursor has been declared, you must open it to fetch data from it. To open a cursor, you can use the following syntax:
OPEN { { [GLOBAL] cursor_name } | cursor_variable_name}

GLOBAL - if this argument was not specified and both a global and a local cursor exist with the same name, the local cursor will be opened; otherwise, the global cursor will be opened.

cursor_name - the name of the server side cursor, must contain from 1 to 128 characters.

cursor_variable_name - the name of a cursor variable that references a cursor.

After a cursor is opening, you can determine the number of rows that were found by the cursor. To get this number, you can use @@CURSOR_ROWS scalar function.

Fetching a Cursor

Once a cursor has been opened, you can fetch from it row by row and make multiple operations on the currently active row in the cursor. To fetch from a cursor, you can use the following syntax:
        [    [    NEXT | PRIOR | FIRST | LAST
                | ABSOLUTE {n | @nvar}
                | RELATIVE {n | @nvar}
{ { [GLOBAL] cursor_name } | @cursor_variable_name}
[INTO @variable_name[,...n] ]

NEXT - the default cursor fetch option. FETCH NEXT returns the next row after the current row.

PRIOR - returns the prior row before the current row.

FIRST - returns the first row in the cursor.

LAST - returns the last row in the cursor.

ABSOLUTE {n | @nvar} - returns the nth row in the cursor. If a positive number was specified, the rows are counted from the top of the data set; if 0 was specified, no rows are returned; if a negative number was specified, the number of rows will be counted from the bottom of the data set.

RELATIVE {n | @nvar} - returns the nth row in the cursor relative to the current row. If a positive number was specified, returns the nth row beyond the current row; if a negative number was specified, returns the nth row prior the current row; if 0 was specified, returns the current row.

GLOBAL - if this argument was not specified and both a global and a local cursor exist with the same name, the local cursor will be fetched; otherwise, the global cursor will be fetched.

cursor_name - the name of the server side cursor, must contain from 1 to 128 characters.

cursor_variable_name - the name of a cursor variable that references a cursor.

INTO @variable_name[,...n] - allows data returned from the cursor to be held in temporary variables. The type of variables must match the type of columns in the cursor select list or support implicit conversion. The number of variables must match the number of columns in the cursor select list.

Closing a Cursor
When you have finished working with a cursor, you can close it to release any resources and locks that SQL Server may have used while the cursor was open.
To close a cursor, you can use the following syntax:

CLOSE { { [GLOBAL] cursor_name } | cursor_variable_name }

GLOBAL - if this argument was not specified and both a global and a local cursor exist with the same name, the local cursor will be closed; otherwise, the global cursor will be closed.

cursor_name - the name of the server side cursor, must contain from 1 to 128 characters.

cursor_variable_name - the name of a cursor variable that references a cursor.

Note. If you have closed a cursor, but have not deallocated it, you can open it again when needed.

Deallocating a Cursor
When you have finished working with a cursor and want to completely release SQL Server resources that were used by a cursor, you can deallocate a cursor.
To deallocate a cursor, you can use the following syntax:

DEALLOCATE { { [GLOBAL] cursor_name } | @cursor_variable_name}

GLOBAL - if this argument was not specified and both a global and a local cursor exist with the same name, the local cursor will be deallocated; otherwise, the global cursor will be deallocated.

cursor_name - the name of the server side cursor, must contain from 1 to 128 characters.

cursor_variable_name - the name of a cursor variable that references a cursor.

Note. Deallocating a cursor completely removes all cursor references. So, after a cursor is deallocated, it no longer can be opened.

DECLARE @ColExpir datetime
DECLARE @ColFallprotec datetime
DECLARE @ColWorkid int
SELECT Table_Training_Detalis.DateExpires,Table_Training_Detalis.Worker_ID
FROM   Table_Courses 
OPEN @MyCursor
INTO @ColExpir,@ColWorkid
update Table_Workers set WHIMIS= @ColExpir where Worker_ID=@ColWorkid
INTO @ColExpir,@ColWorkid
CLOSE @MyCursor
Read More

October 28, 2013

Dynamic Google Chart with , C Sharp

To display live data on your site using Google chart with and C#.

  • Google chart tools are powerful, simple to use, and free. Try out our rich gallery of interactive charts and data tools
to create Dynamic Google chart with, we have to fetch data in Data Table with your preferred back-end server, checkout following steps...
  1. Fetch data in Data Table..
  2. Convert Data into JSON format
  3. Pass JSON Data to Script with web method
  4. Pass JSON Data to google.visualization.DataTable()
  5. Execute Google Chart Script - new google.visualization.ColumnChart("HtmlElementID")
Below is Code Example with three types of chart..(Column Chart, Line Chart, Combo Chart)

1. SCRIPT ( Design Page chart.aspx)

<script src="//" type="text/javascript"></script>
    <script type="text/javascript" src="//"></script>
    <script type="text/javascript">
        google.load('visualization', '1', { packages: ['corechart'] });
    <script type="text/javascript">
        $(document).ready(function () {
                type: 'POST',
                dataType: 'json',
                contentType: 'application/json',
                url: 'Chart.aspx/GetData',  // Your aspx page url with web method..
                data: '{}',
                    function (response) {

        function drawVisualization(dataValues) {
            var data = new google.visualization.DataTable();
            data.addColumn('string', 'Product Catalogue');
            data.addColumn('number', 'Total Sales');
            data.addColumn('number', 'MOP');
            for (var i = 0; i < dataValues.length; i++) {
                data.addRow([dataValues[i].ColumnName, dataValues[i].Value, dataValues[i].Value2]);
            var options = {
                title: 'Total Sales by Years',
                is3D: true,
                hAxis: { title: 'Product Catalogue', titleTextStyle: { color: 'red'} }
            new google.visualization.ColumnChart(document.getElementById('Div1')).
                draw(data, options);

            new google.visualization.LineChart(document.getElementById('Div2')).
            draw(data, options);

            new google.visualization.ComboChart(document.getElementById('visualization')).
            draw(data, {
                title: 'Total Sales by Years',
                width: 600,
                height: 400,
                is3D: true,
                vAxis: { title: "Total Sales" },
                hAxis: { title: "Produt Catalogue" },
                seriesType: "bars",
                series: { 1: { type: "line"} }

2. HTML ( Design Page chart.aspx)

    <form id="form1" runat="server">
        <div id="visualization" style="width: 600px; height: 350px;">
        <div id="Div1" style="width: 600px; height: 350px;">
        <div id="Div2" style="width: 600px; height: 350px;">

3. Code Behind ( chart.aspx.cs)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.Services;

public partial class Chart : System.Web.UI.Page
    protected void Page_Load(object sender, EventArgs e)


    public static List<Data> GetData()
        SqlConnection conn = new SqlConnection("--YOUR CONNECTION STRING--;");
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        string cmdstr = @"select productcatalogue,convert(decimal,sum(localamt)) as totalsales ,convert(decimal,sum(mop)) as mop
                        from [salesdata] group by productcatalogue ";
        SqlCommand cmd = new SqlCommand(cmdstr, conn);
        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        dt = ds.Tables[0];
        List<Data> dataList = new List<Data>();
        string cat = "";
        decimal val = 0;
        decimal val2 = 0;
        foreach (DataRow dr in dt.Rows)
            cat = dr[0].ToString();
            val = Convert.ToDecimal(dr[1]);
            val2 = Convert.ToDecimal(dr[2]);
            dataList.Add(new Data(cat,val,val2));
        return dataList;
public class Data
    public string ColumnName = "";
    public decimal Value = 0;
    public decimal Value2 = 0;
    public Data(string columnName, decimal value, decimal value2)
        ColumnName = columnName;
        Value = value;
        Value2 = value2;

Read More

October 9, 2013

NOBEL PRIZE WINNERS 2013 Peter Higgs, Francois Englert ARTICLE

Nobel Prize for Physics 2013 winners Peter Higgs, Francois Englert(theorists of Higgs boson, the key to the universe)

Peter Higgs (Britain) and Francois Englert (Belgium) won the Nobel Prize for physics for the
year 2013 on Tuesday (09-10-2013) for predicting the existence of the Higgs boson particle that explains how elementary matter attained the mass to form stars and planets. The winners were much heralded following last year’s discovery of the Higgs by physicists at the CERN particle physics lab near Geneva, Switzerland, using its Large Hadron Collider (LHC). It is probably the least surprising Nobel of the year. Because people have been speculating for months that the award was going to be centered around the discovery of the Higgs Boson.

50 Years after their original work, the new building block of nature was finally detected in the year 2012 at the European Organization for Nuclear Research (CERN) center's giant, underground particle-smasher near Geneva. The discovery was hailed as one of the most important in physics.
"The awarded theory is a central part of the Standard Model of particle physics that describes how the world is constructed," the Royal Swedish Academy of Sciences said in a statement.

The nobel prize for physics in the year 2012 won by Serge Haroche of France and David Wineland of America.
Note : Following reported observation of the Higgs-like particle in July 2012, several Indian media outlets reported on the supposed neglect of credit to Indian physicist Satyendra Nath Bose after whose work in the 1920s the class of particles "bosons" is named, although physicists have described Bose's connection to the discovery as tenuous.
Read More

October 8, 2013

SIDBI NOTES Objectives and Functions

Small Industries Development Bank of India 

(SIDBI) - Objectives and Functions
The Small Industries Development Bank of India (SIDBI in short) was established in the year 1990 (Date : 2nd April 1990) under the Small Industries Development Bank of India Act 1989 as a subsidiary of Industrial Development Bank of India.It is the principal financial institution for promotion, financing and development of small, tiny and cottage sector. Originally, it was a refinancing organization. But today, it finances on its own. At present it has grown into a multifaceted organization offering a seamless chain of financial services.

Capital :
The authorized capital of SIDBI is Rs. 250 crores which would be enhanced upto Rs. 1000 Crore. It also took over the outstanding portfolio of IDBI relating to small scale sector held under Small Industries Development Fund as on 31st March 1990 worth over Rs. 4000 crore.

Objectives :
Technological Up-gradation : Initiating steps for technological up-gradation and modernization of existing units.

Market Expansion : Expanding the channels for marketing the products of the small scale sector.
Employment Oriented Industries : Promotion of employment oriented industries, especially in semi-urban areas to create more employment opportunities and thereby checking migration of population to urban areas.
Co-ordination of Activities : To co-ordinate the functions of institutions engaged in similar activities.

Functions / Schemes :Following are the major functions of SIDBI
Refinance : It refinances loans and advances provided by the existing lending institutions to the small scale units.

Discounting Bills : It discounts and re-discounts bills arising from sale of machinery to and manufactured by small scale industrial units.

Seed Capital / Soft Loan : It extends seed capital / soft loan assistance under National Equity Fund, Mahila Udyam Nidhi and Mahila Vikas Nidhi and seed capital schemes.

Refinance for Exports : It grants direct assistance and refinance loans extended by primary lending institutions for financing exports of products manufactured by small scale units.

Factoring Services : It provide services like factoring, leasing, etc, to small units.
Financial Support to SSICs : It extends financial support to State Small Industries Corporation for providing scare raw materials to and marketing the products of the small scale units.

Assistance to NSIC : It provides financial support to National Small Industries Corporation for providing, leasing, hire-purchase and marketing help to the small scale units.
Co-promotes State Level Venture Funds : SIDBI Co-Promotes state level venture funds in association with respective state government.

Setting Up of Incubation Centers : SIDBI takes initiative for setting up of incubation centers under its National Programme for Innovation and Incubation for Small Industries with a view to harnessing the entrepreneurial talents.

Financing Projects Relating to Transport Health : SIDBI finances projects relating to transport, health care and tourism sectors and also to the professional and self-employed persons setting up small-sized professional ventures.

Promotional Role of SIDBI :SIDBI plays a key role in implementation of government policies and initiatives for the sector. It facilitates creation of an environment for self-sustaining and growing SSI units. Some of the institutions SIDBI that promoted includes :
  • SIDBI Venture Capital Ltd.
  • Credit Guarantee Fund Trust for Small Industries.
  • Technology Bureau for Small Enterprises.
  • SIDBI Foundation for Micro Credit.
Performance and Progress :
  • SIDBI retained its position in the top 30 Development Banks of the World in the latest ranking of The Banker, London (25th Rank).
  • The cumulative sanctions and disbursements of SIDBI since its inception stood at Rs. 75,255 Crore and Rs. 52,312 crore respectively during financial year 2002.
  • The aggregate sanctions of SIDBI during financial year 2002 amounted to Rs. 9.025 crore as against Rs. 10,821 crore in financial year 2001.
  • As regards financial performance, the profit before tax in financial year 2002 stood at Rs. 405 crore as against Rs. 477 crore in the previous year.
  • Disbursements were also lower at Rs. 5,919 crore as against Rs. 6,441 crore in previous year. 
  • SIDBI has been permitted to raise finances upto Rs. 2,730 crore the year 2013 onward by the Reserve Bank of India.
The coming years would be crucial for SIDBI. The major challenges includes,
  • The accelerated pace of deregulation of financial sector.
  • Softer interest rate.
  • Expected decline in availment of refinance by banks which, hitherto formed major chunk of the bank's business.
Read More

© 2011-2016 Techimpulsion All Rights Reserved.

The content is copyrighted to Tech Impulsion and may not be reproduced on other websites.