Friday, 27 June 2014


Excel Tab Home:


Cell:Area where pointer points is called cell.

Copy: To copy particular cell . Cut: To cut particular cell. Paste:To paste particular cell.
Format Painter: It is used to copy format of cell/cells and apply it to area of interests.
Font Selector: Select font from drop down.Size Selector:Select size of font.
Font Size Increase/Decrease: Click to increase/decrease the font.
Bold,Italic,Under Line. Border Selector: Select border according to your choice.Cell Color: Change cell color,Font Color: Change font color.
Alignment:To change alignment.
Orientation:Horizontal, Vertical.
Increase/Decrease Intends:Increase intends between border.

This portion is for currency format choose currency format accordingly. 
Conditional formatting: This is used to change formatting according to certain condition.
Format as table: To format the data in to table select any temple from here.

Insert: Insert Cell,Row,Column.
Delete:Delete Cell,Row,Column.
Auto Sum:Formula to sum cell.
Fill:To fill cell.
Clear: To clear format ,content,comment hyperlink
Sort & Filter:Sort the data accordingly.
Find & Search:To find particular value.
Posted By:Tanuj Kumar 
Wants to learn about Technology Goto Geniuslake
Read More
Posted on 9:17:00 pm

Thursday, 26 June 2014


Global Positioning System:

  • ·         Global: All over the world
  • ·         Positioning: Find location of particular object.
  • ·         System: A Group of hectic equipment.
Definition: combined-A system which is used to find location of particular object in the world is called GPS.
Global Positioning System

Required items:
1. GPS tracking device: A GPS tracker essentially contains GPS module to receive the GPS signal and calculate the coordinates, it may be a mobile phone, vehicle, personal asset. It contains large memory to store the location.
Additionally tracking devices contains the GSM/GPRS modem to transmit this information to a central server either via SMS or via GPRS in form of IP packets.
2. Satellite: Satellite receive signal from GPS tracking device later transferred to centralized server through signal towers. Satellite is very complicated machine, specially made for signal transmission.
3. Server: Server is used to store tracked information and later transmit to local system who wants to track the GPS device.
4. Cell tower: Cell tower receive information from satellite or directly from tracking device and transmit it to server.
5. Internet enable tracking computer: Now objective is to track location of any GPS enable object through computer. Computer simple send request to ISP Server who have stored updated location information received from satellite through cell towers.
Working: Working is very simple of GPS System.
GPS enable device send location information to Satellite/Towers after equal interval of time. ISP Server stores this updated data to their server.
If someone request for specific the location data ISP Server provide it to customer.

  • ·         GPS system is becoming very popular due to its accuracy.
  • ·         By GPS you can track any GPS enabled Vehicle/Device/Personal asset.
  • ·         It’s very helpful in landing and aero planes.
  • ·         Also used to track courier vehicle. One and most important use to track criminal vehicle.

·         Useful to find lost GPS enabled mobile device.

Posted By:Tanuj Kumar 

Read More
Posted on 6:12:00 pm

Monday, 23 June 2014

An apple a day keeps the doctor away

An apple a day keeps the doctor away:

An apple a day keeps the doctor away

In our childhood, we all have heard the phrase An apple a day keeps the doctor away but did we ever analyze this fact. Does Apple really help us in maintaining health? Well, let’s evaluate some of the major constituents of apple and their effect on our health.

Pectin: Pectin is a type of soluble fiber which helps us to lower down the blood pressure, cholesterol and also glucose levels. It also improves our digestive system.

Boron: A nutrient present in apples which promotes strong bones and healthy brain.

Quercetin: This beneficial nutrient reduces the risk of Cancer like Lung Cancer etc. Quercetin also helps in prevention of Alzheimer's disease.

Phytonutrients:  Apples also contains a number of Phytonutrients in abundance which majorly includes Vitamin A, Vitamin, E and Beta carotene. These components play a key role to destroy the activities of free radicals which can cause severe damage to our body, and helps in preventing diseases like diabetes, cardiovascular disease and Asthma.

Conclusion: In literal terms if we eat an apple a day, the chances of illness will be very much less and can definitely reduce our frequency to doctor’s clinic in the long run. Not, only that I would also like to suggest my friends, please include variety of fruits in our daily life like citrus fruits, tropical fruits and berries which are highly nutritional and rich in vitamins.

Posted By:Abhishek Jalan 

Read More
Posted on 8:59:00 pm

Thursday, 19 June 2014

Cyber Crime

Cyber Crime:

Cyber Crime

I would like to discuss on a very stimulating topic i.e. Cyber Crime, or in other terms the crime committed by means of computers over internet. The illicit use of computer to promote fraudulent activities like child pornography, stealing personal identifiable information or violating policies of any association , all such actions can be categorized under Cyber Crime. Most of the misconducts are triggered via Internet and its study has gained importance in recent decades, because the use of internet is seen in every sector of society like business, entertainment, medical services, sports, media industry.
Maximum of the law-breaking cyber-criminal crooks target information that are owned by any individuals, corporations or governments. These attacks never exist in any physical form; it always takes place in virtual form. One of the major aspects of these crimes is that it can be easily committed from a remote distance in a matter of seconds and it becomes very difficult to trace evidence or punish criminals because it might require global co-operation.  With the advancement of various technologies criminals can easily hide their identity physically or virtually over the internet which sometimes becomes very challenging to locate.
Different forms of Cyber Crimes:
Hacking: It is a form of crime in which criminal’s access personal or sensitive information stored in systems database belonging to any individual or organization from a remote location. The actual owner may not be aware that his confidential information is being accessed by other person. The criminals mostly use special software for such activity.

Copyright Violation:  It generally takes place when someone publishes articles or content which is owned by some other people. Some others forms of illegal activity which comes under copyright infringement are downloading pirated music, movies, games and software.

Cyber Stalking: It is a form of online harassment wherein the prey or target is tortured by a series of online messages, emails.

Phishing: It is one of the major forms of cyber-crime and the people who are mostly affected is individuals  who are using internet as a medium for cash transactions and other banking related services.
The criminal attempts to acquire sensitive information like username, password and credit card details to withdraw money or to purchase stuffs online illicitly.

Malicious Software: It is also known as Malware which is basically a computer code and once it runs successfully; it can give partial or full control to your computer and the criminals can easily access any sensitive information or can damage your data.

Child abuse: This is also one of the major forms of cybercrimes wherein criminals forces minors via chat or emails for any adult or pornographic act.

Preventative measures of cybercrime:

It is a phenomenal task to tackle with cybercrime. However, I would like to highlight few tips to my friends which they should always follow.

Strong Password: Always use altered ID/password for various accounts that you own and never make mistake of writing it down physically over a piece of paper. You should always change your password regularly and make sure your device is fully protected and secured

Use Social media sites cautiously:  Be sensible while posting anything on social media sites. Once, the content is live on internet, it stays there forever!

Protect your personal identifiable information: Be careful while revealing any personal information such as name, address, phone number or financial information over the internet. Always prefer secure website for online transactions.

Avoid being scammed: Think multiple times before you click any link which asks you for any personal information. Please verify the source, and never reply to such fraudulent emails.

Call the right person for help: Never Panic!  In case you are duped or come across illegal online content or suspect any fraudulent activity like commercial spam. Please report to your local police or if you need to secure your computer system, try to consult certified computer professional.

Posted By:Abhishek Jalan 
Read More
Posted on 1:55:00 pm

Saturday, 14 June 2014

Amazing facts about Cucumber

Amazing facts about Cucumber

Its summer seasons are we are facing too hot.
Uses For Cucumbers -

Cucumbers are rich in minerals, especially potassium, which is great for detoxification, since it eliminates toxins, but you can also use it for many other purposes in summer seasons.
1. Aids in digestion -

Everyone has busy life, This daily busy life destroy our eating habit results mis-digestion.

Special in summer seasons it happens. Water is life in this scenario use cucumber to improve

 your digestion system.

2. Daily vitamins - 

Human body require daily vitamins and cucumber is source of vitamins. Use it to get an vitamins from it.

3. Skin and hair care - 

Cucumber is widely used for skin care. You have also seen that beauty parlor use Cucumber 

frequently for dead cell removal and for brightness to our face. Cucumber is also useful for 

our hairs.
4. Fight cancers - 

Cucumber take away toxins from body to stay it healthy and match. exploitation cucumber cell  fights 

from cancer.

5. Hangover cure -

Many people face hangover and headache at morning . Eating Cucumber before sleeping 

remove hangover problem.

Keep Reading HEALTH TIPS only on sHare yOur cOnscience.

Read More
Posted on 10:54:00 am

Thursday, 12 June 2014





1. You have create user interface using visual studio as in screen shot.
2. double click on login button and write down the below coding on button click event.
3.Here database name is JOB.
4. Table name is userregistration.

//first of all include all namespace 
//these has been added automatically in Visual Studio.
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class Login : System.Web.UI.Page

    protected void Page_Load(object sender, EventArgs e)

    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
        //connection string
        SqlConnection con = new SqlConnection("server=localhost; database=JOB; Integrated Security=True");
        SqlCommand cmd = new SqlCommand("select * from userregistration where username=@username and 

password=@password", con);

        cmd.Parameters.AddWithValue("@username", text_username.Text);
        cmd.Parameters.AddWithValue("@password", Text_password.Text);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
            Session["uid"] = dr["email"].ToString();
            Session["name"] = dr["username"].ToString();


            Label1.Text = "invalid username password ";
Read More
Posted on 8:53:00 pm

Tuesday, 10 June 2014

Benefits of Tomato Juice

Benefits of Tomato juice:

1. High cholesterol: Drinking tomato juice can also help in the prevention of high cholesterol.
2. Source of Vitamins:Tomato juice is a source of vitamins A and C. That is beneficial to our eyes and body. Tomato juice is rich in Vitamin B6 .
3. Helpful in weight loose:Another big benefit of tomato juice is that it aids in weight loose.
4. Helpful to remove body toxins:Tomato juice has a detoxification effect on the body due to the presence of chlorine and sulfur
5. Antioxidant:The red colour in tomatoes is due to a fat solution antioxidant known as lycopene.

Keep Reading HEALTH TIPS only on sHare yOur cOnscience.

Source:click here
Read More
Posted on 7:31:00 pm

Stop eating Potato chips

Avoid Potato chips :

Stop eating Potato chips

1-Potato chips cause cancer:
Potato chips containing the chemical carcinogens, when we are cooking foods which are rich with carbohydrate at high temperatures, that chemical is formed. Therefore , can be found in potato chips .

2- Potato chips contain high calories:
If you are health conscious you must avoid potato chips. The main reason behind this is it’s calories that cause all sorts of health problems such as clogged arteries, and the weakness of the heart.

3- No benefits:
Potato chips contains no protein no vitamins. No need to eat it on regular basis.

4- Blood pressure:
Potato chips contain sodium with is harmful to our heart. It directly affects heart and blood vessels. Eating large amounts of sodium causes an increase in blood pressure.
Increase in blood pressure is invitation to other decease like stroke, heart failure, and kidney disease.

5- High cholesterol:
Frequent consumption of potato results high cholesterol levels. Potato chips are mostly fried. Oils used in frying this is a process that creates trans fats .

6- Potato chips cause drought:
Potatoes cause dehydration. Everyone who eats potato chips should drink more water to avoid the situation of dehydration.

Keep Reading HEALTH TIPS only on sHare yOur cOnscience.

Source:click here
Read More
Posted on 7:30:00 pm

Sunday, 8 June 2014

Humanity is above all religion

 Society Difference

Humanity is above all religion
Must See and feel the Difference- Four Kids, Four Bags, Two different stories. An eye opener for all.

Sometimes, When I see these differences in our society,  I use to wonder about the reason of these two stories. We all are human , we all are one ,but the cause of this is one of the biggest problem  which lead many countries in the condition that really cannot do anything about that. The problem is "poverty' which is the cause of this difference which we can see in the  picture shown below. 
Now when i understand the reason then my mind takes me to the solution of that, I mean what i think is that the poverty is because of corruption and many other reasons. But in that all reasons i get to know about one reason which we can prevent to happen. The thing is our approach, our way of thinking, which we can improve then we can improve our country as well as the world will simultaneously get improved.

We have to think about development so that these peoples can study easily , having development in our society led to the good income that will lead to the great impact ovet education rate of our country which highly will impact our society.

And really i wanted to reduce these differences, want to see my country growing and developing. I hope one day will come soon, there is no more these stories, No more tears. :)

Keep Reading about Humanity only on sHare yOur cOnscience.

Posted By:Anshuman
If you believe in it,
 then must like 
our page:Humanity 

Read More
Posted on 5:35:00 pm

How to use linkedin for business promotion.

How to use linkedin for business promotion.

How to use linkedin for business promotion.

1. Set Your Goals initial and build A Profile supported It:

You must complete your profile with info associated with your goals, info that may cause you to nearer to your goals.
If you've got goals to produce recommendations on blogging, then confirm you usually publish that sort of data. create yourself as a trusty supply for the kind of data.

2. Connect With many of us:

If you've got plenty of acquaintances, then you'll be able to send a connections request to them. Also, don’t forget to send a association request to the those who can bring you nearer to your goals additionally.

The formula is straightforward, if you've got plenty of connections on your LinkedIn profile, your standing updates also will be seen by many of us. Yes, that’s what's going to bring innumerable traffic to your journal.

3. Be part of teams or begin Your Own:

Groups on LinkedIn ar terribly active teams. If you wish to extend traffic to your journal, then you must explore for teams associated with your journal content. In alternative words, teams that contain those who have an interest in reading your content.

My suggestion is you must explore for teams that have plenty of members. By doing therefore, you'll have plenty of connections and increase your traffic additionally. I even have joined many teams on LinkedIn and are tasted the advantages myself.

4. Be Active:

When you have created your profile and be part of some teams associated with your journal niche, then all you've got to try to to next is to actively participate in it. be at liberty to love the cluster discussions, inquire into others’ standing, creating endorsement then on.

5. Share Your Best Content:

Make sure you merely share your best content, the foremost helpful content that you simply ever had. It’s vital to try to to particularly if you've got joined the teams. If your content is actually sensible, then your traffic can increase by itself.
Thing you must not do is flood the teams along with your content links. and also the factor you need to do is show that you simply will add worth to the readers by sharing solely the wonderful content from your journal.

Read More
Posted on 5:21:00 pm

Thursday, 5 June 2014




When we were simply learning a way to write, we have a tendency to all commenced employing a pencil/pen with associate degree implement on prime. Eventually, we have a tendency to created use of Biro inks. Perhaps, we have a tendency to could have even used costlier pens/pencil just like the ones created by Parker and Cross Biro pens.To real historic events just like the sign language of a crucial piece of legislation.By doing that,in time, these pens will definitely command a high worth.

There area unit numerous sorts of pens, from the cheap Biro pens that use sticky oil-based ink, or the fountain pens that use water-based liquid ink that passes through a nib, to the markers that build use of felt tips, and also the rollerball pens that use gel ink. It will are available in a spread of colours, together with bronze paint colours and colours that have a glitter-like result.

1. Aurora Diamante Fountain Pen – $1.47 million

Aurora may be a pen manufacturer based mostly in European country proverbial for its luxury writing instruments. The company’s spangle pen is understood for its swish flow of writing delivery, tho' it's going to be onerous to consider your calligraphy with this pen once it's around two,000 diamonds crusted everywhere its body. Yes, 2,000 diamonds, creating this pen not simply a commentary instrument, however a veritable jewellery further. To fill up the statement of wealth that this pen looks to proclaim, the nib of the pen comes in gold. just one spangle pen is made annually by the manufacturer, therefore creating it a rare collectible.

2. Caran d’Ache 1010 Diamonds Limited Edition Fountain Pen – $1 million

Caran d’Ache may be a well-regarded manufacturer of pencils, writing instruments and art merchandise based mostly in European country. It ought to in all probability add designer of gemstones to its list of credentials. After all, it's created a edition pen that's crusted with 850 diamonds. The cap of the pen conjointly has twenty six lines that ar decorated with twenty two baguette-cut diamonds. the whole body of the pen is already luxurious enough, because it is formed from alloy. And yes, this edition pen will write quite well. albeit it doesn't, you actually wouldn't be throwing this away.

3. Heaven Gold Pen – $1 million

Touted as a girly pen because the body is wrought from 24k pink gold. Originally known as the primary Diamond and Gold Pen, it absolutely was created by Anita Tan and options one,888 diamonds advisement forty eight carats, as well as 161 that have sensible colours. Tsavorite gemstones calculable to be two billion years previous and advisement forty three carats conjointly adorn this pen. The gems kind diamond, heart and flower shapes within the middle of the pen. Tan purportedly thespian inspiration from the cosmos at the beginning of 2012 once the celebs and planets realigned.

4. Mont Blanc Limited Edition Mystery Masterpiece – $730,000

What happens once one in every of the simplest creators of luxury watches, writing instruments and animal skin aggroup with one in every of the foremost prestigious high jewellery manufacturer within the world? That was what happened once mountain peak and Van Cleef & Arpels collaborated on this edition pen, with competence named the Mystery Masterpiece. The luxury-writing instrument was meant to celebrate the centenary of the German large, and it didn't cross. The pen was decorated with 840 diamonds. purchasers will then select whether or not to feature emeralds, rubies or sapphires to produce the distinction to the diamonds. The result's really a masterpiece in each sense of the word.

5. Caran d’Ache Gothica Pen – $406,453

Only 1,140 were created by Caran d’Ache during this tribute to Gothic art. The pen is formed of alloy coated in metal, with a Gothic window of rosette on either side combining in sensible colours

Read More
Posted on 1:59:00 pm

Monday, 2 June 2014

Messaging App Line Offer

Messaging App Line Offers:

Messaging App Line Offer

Major social messaging application online Talk time .His offer, is free to consumers . This is the second time the company is offering free talk time service . The company offers will start June 1 and will apply to the entire month .

Under it, the more points you will be using online messaging app and get as much talk time you can change the point . The consumer may have a total of 111 free talk time of Rs .

The company will provide all service providers available to consumers taking advantage of the Android smartphone or IOS . Not only both postpaid and prepaid subscribers can avail this kind of service .

What to do to get offer?

To take advantage of this offer every day a sticker or at least send a message to the online consumer . This offer will only be available to consumers in India online . Offers made ​​through the points you can redeem at intervals of 25 days .

The social messaging app Lyle 440 million subscribers worldwide total 18 million subscribers in India . Given the growing popularity Messenger app company has introduced such offers . This will help to significantly enhance consumer basis .

Read More
Posted on 8:26:00 pm