Latest Entries »


The new secret smileys for facebook chat


Use all these codes on chat box

[[124193631030413]] – Michael Jackson
[[124195081030268]] – LOL
[[124201834362926]] – F*** Off
[[124203091029467]] – Computer Icon
[[124206401029136]] – Windows icon
[[124208857695557]] – Apple Logo
[[124211087695334]] – F*** off finger
[[124212967695146]] – Osama
[[124214267695016]] – Mr. Bean
[[124215331028243]] – Sun
[[124216534361456]] – Moon
[[124218417694601]] – Twitter bird
[[124219164361193]] – 8 Ball
[[124234194359690]] – PLT C
[[ForeverAloneComics]] – Forever Alone
[[MeGustaMeme]] – Megusta
[[164413893600463]] – Megusta 2
[[149333368464171]] – Yao Ming
[[116616581692281]] – TROLL Face
[[145768898802324]] – FUUUUUs
[[168456309878025]] – LOL
[[189637151067601]] – LOL 2
[[FapFapFap.B]] – FAPFAP
[[106043532814443]] – Y U NO
[[214457085240151]] – Nothing to do here
[[129627277060203]] – Poker faces
[[160723207280093]] – You f***ing kidding me?
[[ChallengeAcceptado]] – Challenge accepted
[[100002752520227]] – Okay
[[105387672833401]] – F*** Yeah
[[224812970902314]] – Derp
[[192644604154319]] – Derpina
[[170815706323196]] – Cereal guy
[[142670085793927]] – Mother of God
[[168040846586189]] – Feel like a sir
[[249199828481201]] – Konata Izumi
[[250128751720149]] – Domo Kun
[[223328504409723]] – Gintoki Sakata
[[236147243124900]] – Pokeball
[[326134990738733]] – Pikachu
[[155393057897143]] – Doraemon
[[224502284290679]] – Nobita
[[144685078974802]] – Mojacko
[[334954663181745]] – Spongebob
[[196431117116365]] – Shin chan
[[138529122927104]] – Pedo Bear
[[269153023141273]] – Poring
[[332936966718584]] – Hello Kitty
[[252497564817075]] – Kerokeroppi
[[297354436976262]] – Santa Claus
[[157680577671754]] – Angry Bird

new smiley facebook 2012 secret emoticons facebook facebook cheat codes for chat new smileys for facebook hidden smileys facebook new smiles for facebook chat new smiley facebook 2012

Blue Text in Facebook Status and comments


You may also like to read:


________________________________________________________________________________________________________________

DOWNLOAD YOUR OWN BLUE CODE TEXT GENERATOR

Now Its Possible to write in blue colour text in facebook, just follow the below steps:

1. Go to the link http://www.facebook.com/worldofengineers

2. Like this page.

3. Now type this code

@@[0:[154106167971264:1:‎ your text here]]
@[154106167971264:0]

in your status update and comments…and enjoy.

Bash (Unix Shell)


There are many tools in linux for command executions and one of them is called the “shell programming”.

The most common Linux shell is named “Bash” is the default shell on linux. The name comes from “Bourne Again SHell” ,written by Brian Fox.

As it is the default shell of linux so people prefer using it than any other shells as it makes them to use it worldwide as it now becomes machine independent and operating system independent.

There are two ways to use the shell: interactively and by writing shell scripts( known as shell scripting ).

* In the interactive mode, the user types a single command or a short string of commands and the result is printed out on the screen.

*In shell scripting, the user types anything from a few commands  to an entire program( collection of programs) into a text editor, then executes the resulting text file as a shell script.

How to install Ubuntu linux


while browsiing today i got a very nice video on how to install ubuntu  linux.So sharing it might be useful for you:

houdini’s last trick


Here i am presenting before you an awsome trick well known as hodigni’s last trick….

try it guys:

RULES:

1.given below is the diagram,u have to start from any end and cut all the lines…thats it.

2. for example below is a trial of it but was not successfull…!!!!!

See the solution:


RELATED POSTS:

VARIABLE REGULATED POWER SUPPLY–PROJECT

________________________________________________________________________________________________

A combined project by Abhishek, amit and me.


   Following is the list of parts or the components required to design this project:

 

  1. IR receiver module TSOP1738
  2. Transistor T1 (BC558)
  3. Decade counter IC CD4017 (IC1)
  4. LED1 (red)
  5. LED2 (green)
  6. Transistor T2 (BC548)
  7. Relay RL1, 5V, 100 ohm
  8. Diode 1N4007 (D1)
  9. R1 = 220K
  10. Bulb Holder
  11. Bulb
  12. R2 = 330 ohm
  13. R3 = 1K
  14. R4 = 330 ohm
  15. C1=100 uf,16V
  16. C2=0.1 uf
  17. 5V dc supply
  18. Soldering Iron ,Solder wire
  19. PCB Designing Material
  20. 2 Pin plug
  21. Wires

Connect this circuit to any of your home appliances (lamp,fan, radio, etc) to make the appliance turn on/off from a TV, VCD or DVD remote control. The circuit can be activated from up to 10 metres.The 38kHz infrared (IR) rays generated by the remote control are received by IR receiver module TSOP1738 of the circuit.

PCB LAYOUT :

CIRCUIT DIAGRAM:


AFTER COMPLETION:

WORKING PROJECT:

____________________________________________________________________________

To provide this project a small area here i am giving a small PCB layout of the above design:

pcb layout


Its a new simplified form of PCB layout of above project.

Multiple gtalk simultaneously


Sometimes on a single pc we need to open more than one g-talk window when its a demand of your friends,but no you can’t do that.First you have to sign out yours for giving chance to next,but now your problem is solved,you can open more that one gtalk and use it simultaneously…follow some simple steps:

1)Right click on the Google Talk shortcut from start menu.
2)click on Properties.
3)Go to Shortcut tab on Properties window.
4)On the Target textbox, add in the /nomutex at the end of the line so that it looks like below (or you can simply copy and paste the below syntax and replace the original).
“c:\program files\google\google talk\googletalk.exe” /nomutex
5)Click on OK and thats it.

Create a bootable pen drive


Many times we need to have a bootable pen drive if we are a netbook user or sometimes we don’t have a dvd to use, but to create one bootable usb drive is very easy if you follow the below steps:


1. Insert your formatted USB (4GB+ preferable) stick to the system.

2. Open elevated Command Prompt. To do this, type in CMD in Start menu search field and hit Ctrl + Shift + Enter. Alternatively, navigate to Start > All programs >Accessories > right click on Command Prompt and select run as administrator or open RUN ,type cmd and hit enter.

3. When the Command Prompt opens, enter the following command:

DISKPART and hit enter.

LIST DISK and hit enter.

Once you enter the LIST DISK command, it will show the disk number of your USB drive.

4. In this step you need to enter all the below commands one by one and hit enter.

SELECT DISK 1 (Replace DISK 1 with your disk number)

CLEAN

CREATE PARTITION PRIMARY

SELECT PARTITION 1

ACTIVE

FORMAT FS=NTFS

(Format process may take few seconds)

ASSIGN

EXIT

Bootable USB

now minimise the command window.

5. Insert your Windows DVD in the optical drive and note down the drive letter of the optical drive and USB media. Here I am using “D” as my optical (DVD) drive letter and “H” as my USB drive letter.

6. Go back to command prompt and execute the following commands:

D:CD BOOT and hit enter. Where “D” is your DVD drive letter.

CD BOOT and hit enter to see the below message.

BOOTSECT.EXE/NT60 H:

(Where “H” is your USB drive letter)

USB Bootable

7. Copy Windows DVD contents to USB.

now you have completed making a bootable pen drive , you can preserve it for any no of uses and format it too if u want it back to be used as a data traveller device.

NOTE:In making a pen drive bootable we convert it into NTFS format from FAT 32,this makes USB losses its efficiency,so,i prefer not to make pen drives bootable.

Activate windows 7/8 trail version


Follow some simple steps and you can get rid of trial version of windows 7 and activate it for lifetime:

1.Type “RUN” at start menu,and click on the search result.

2.Type Regedit and press enter.

3.now go to the location described below:

HKEY_LOCAL_MACHINE–>SOFTWARE–>Microsoft–>Windows NT–>CurrentVersion–>SoftwareProtectionPlatform–>Activation

4.Now look at right side and right click on manual and click on modify..and change its value..if it is 1 then change to 0 and if 0 then change to 1.

5.Restart the computer and enjoy.

If you are facing any problem with the registry editing please write us here….!!

How to hack a gmail account


Well hacking a gmail account is a really tough job , but in the world of today nothing is as tough.
Gmail account can be hacked by the two ways,one if we have the full preivelage over the user’s computer or the other is if he/she clicks on the link you have sended to him/her which contains the similar looking fake web page of gmail,which is actually known as phishing.

Well starting with the 1st way in which we have the full previlage over the user’s computer,in this case there are many methods by which we can hack his gmail account,simply installing a keylogger into the computer will directly mail you the daily keystrokes made on user’s computer,these keyloggers are easily available free of cost on internet.They not only sends you the keystroke information but some advance one can even send you the screen shots of the computer too.Well by checking the keystrokes we can easily get the user’s username and password.

The other way is to save a fake web page designed by you on the user’s hard drive on some complex location,then set the path as the home page for his internet explorer.Now when a person opens his internet explorer he will find that fake web page and if he put his username and password for his account, it will be mailed to you.

Now you might be thinking that how actually the online mode works and how the users information will be mailed to you?
Well the thing is that first you have to design a php script which will mail you the username and password when a user click on the SIGN IN button on your fake web page and then navigate you on the original web page of gmail login.

The fake web page can be designed by saving the source code ,modifying the “”action”” with you scripts address which you have to upload on your website or any free e space provider site.You can directly use the fake page or can upload it on internet and can send its link to a user.

Automatic Metering Using 3G Technology


Automatic Metering Using 3GAutomatic Metering Using 3G-a new booming topic to the upcoming technology i.e. 3G.The things which has enhanced its properties over simple metering are:

1.Use of 3g.

2.Wireless connectivity with high security.

3.Automatic,so as to reduce human headache and error cases.

_____________________________________________________________________________

Below is the further description of each and every part with their figures:

automatic metering by 3g

Theses are the gas ,water and electric meters but specially equipped with 3g systems so as they can convert and then Emmit the units covered into the collectible data packets.

___________________________________________________________________________

automatic metering by 3gThese are the 3g boosters which will collect all the emitted data packets from meters and also boost its quality as suggested by its name then the collected data will be transferred to the repeaters.

 

 

 

 

__________________________________________________________________________________

automatic metering by 3gRepeaters are simply the large boosters.All the data packets from various boosters are collected by the repeaters and is sent for data management after its decoding.

 

 

 

 

_________________________________________________________________________________

automatic metering by 3gFinally data is managed through advanced scheme by graphs and charts for decoding the data packets into the units again and then bills are formed to be posted to consumers.

 

 

 

 

________________________________________________________________________________

That”s all about automatic metering by 3g,please give your comments over it and feel free to ask any query in any case.

If you need a presentation over it , please write me,i will surely try to post it here.

Variable Regulated Power Supply:Project


Variable Regulated Power Supply The project “VARIABLE REGULATED POWER SUPPLY” plays a very important role in the laboratory functions and that is mainly to the electronics labs. As in electronics all the instruments, components work on a particular regulated dc supply ,so a project which can provide this supply by converting the alternating current to direct current that too into a great range of regulated power keep its own preference. As it can produce a range of 0-30 v direct current by regulating and converting alternating current is has a vast application too. Such converters are also known as “Switch Mode Power Supply” (SMPS). AC to DC converters generally comprise a rectifier bridge to rectify the AC current of the input line and a regulating device supplying on output of one or more regulated DC voltages.

Just the simple ac current is applied and through potentiometer you get the desired regulated dc power supply.

Variable Regulated power Supply

Following is the list of parts or the components required to design this circuit:

1.      BR1 = Bridge Rectifier, 100V – 3A

2.      C1 = 2200 µF, 63V

3.      IC1 = LM317, adjustable regulator

4.      C2 = 0.1 µF

5.      V = Meter, 30V, Ri = 85 ohm

6.      C3 = 1µF, 40V

7.      TR1 = Transformer, 25V, 2A

8.      Plug = 3-wire plug & cord

9.      R1 = 18K, 5%

10.  S1 = On-Off toggle switch

11.  R2 = 220 ohm, 5%

12.  D1 = 1N4001

13.  R3 = 27K, 5%

14.  Fuse = 110V, 500mA, slow-blow

15.  P1 = 5K, potentiometer

16.  P2 = 10K, 10-turn trim-pot

17.  Fuse Holder, wire, solder, case, knob for P1

18.  Red & Black Banana Jacks

WORKING:-

The 110V-AC coming from the powercord is fed to the transformer TR1 via the on-off switch and the 500mA fuse. The 30v ac output (approximately) from the transformer is presented to the BR1, the bridge-rectifier, and here rectified from AC (Alternating Current) to DC (Direct Current). If you don’t want to spend the money for a Bridge Rectifier, you can easily use four general purpose 1N4004 diodes. The pulsating DC output is filtered via the 2200µF capacitor (to make it more manageable for the regulator) and fed to ‘IN’-put of the adjustable LM317 regulator (IC1). The output of this regulator is your adjustable voltage of 1.2 to 30 volts varied via the ‘Adj’ pin and the 5K pot meter P1. The large value of C1 makes for a good, low ripple output voltage.
Why exactly 1.2V and not 0-volt? Very basic, the job of the regulator is two-fold; first, it compares the output voltage to an internal reference and controls the output voltage so that it remains constant, and second, it provides a method for adjusting the output voltage to the level you want by using a potentiometer. Internally the regulator uses a zener diode to provide a fixed reference voltage of 1.2 volt across the external resistor R2. (This resistor is usually around 240 ohms, but 220 ohms will work fine

without any problems). Because of this the voltage at the output can never decrease below 1.2 volts, but as the potentiometer (P1) increases in resistance the voltage across it, due to current from the regulator plus current from R2, its voltage increases. This increases the output voltage.
D1 is a general purpose 1N4001 diode, used as a feedback blocker. It steers any current that might be coming from the device under power around the regulator to prevent the regulator from being damaged. Such reverse currents usually occur when devices are powered down.
The ‘ON’ Led will be lit via the 18K resistor R1. The current through the led will be between 12 – 20mA @ 2V depending on the type and color Led you are using. C2 is a 0.1µF (100nF) decoupler capacitor to filter out the transient noise which can be induced into the supply by stray magnetic fields. Under normal conditions this capacitor is only required if the regulator is far away from the filter cap, but I added it anyway. C3 improves transient response. This means that while the regulator may perform perfectly at DC and at low frequencies, (regulating the voltage regardless of the load current), at higher frequencies it may be less effective. Adding this 1 µF capacitor should improve the response at those frequencies.
R3 and the trimmer pot (P2) allows you to ‘zero’ your meter to a set voltage. The meter is a 30Volt type with an internal resistance of 85 ohms. I you have or obtained a meter with a different Ri (internal resistance) you will have to adjust R3 to keep the current of meter to 1mA. Just another note in regards this meter, use the reading as a guideline. The reading may or may not be off by about 0.75volts at full scale, meaning if your meter indicates 30 volts it may be in reality almost 31 volts or 29 volts. If you need a more precise voltage, then use your multimeter.



Engineer’s world is proud to launch an online deals-offers-coupons website as a startup. Now get the best selective offer directly to your  mail or facebook page.

Help us to grow it by showing your support by giving us a thumbs up on our facebook page at https://www.facebook.com/fadoodeals

Thanks

The IT story in few simple words



Many time you may face issues where you are unable to format your memory card or pen drive, in order to solve the issue you can format it using command prompt:

To open the DOS prompt (Start >> Run >> cmd)

Type:
FORMAT X: /S

This will reformat the memory card/ Pen drive. Replace X: with the actual drive letter of your Pen Drive or memory card.

The word of slang : Must read


The slang and world of slang

 

SLANG – Let me just clarrify here that am not talking about any “Slangen” snake here , it’s whole about the latest language in market <i mean to say internet> , and the most catchy amoung the online geeks.

Well just for the sake of some information in the post and to make the post lengthy😛, let me just give you a dictionary meaning of slang <it’s for those who were in a plan to make a white paper on it> so, here we go:

“Slang is a type of language consisting of words and phrases that are regarded as very informal, are more common in speech than writing, and are typically restricted to a particular context or group of people”

DISCLAIMER: Now i will be using SLANG in my below article and gonna pen down some thing very informal , well truly I DBA (don’t bother asking) if you really getting me or not. <oops!! i have used my first slang…Scary effect!!!>

INCYDK (In case you don’t know) slang is most inovative and Creative language ever created. SNH (Sarcasm noted here) . It’s most of the usage is confined to IM groups , SMS, wats app, facebook and so on to ABL (A big list).

How exciting it is that you can even find a slang dictionay on internet… <and a girl’s reaction : OMG!! :O my fb status will rock now :P> , it’s like the one who knows more word of slang, knows much about internet.And sometimes i even imagine when the work “ok” changed to “k” , kill to “K33l” , kind of to “kinda”, and so on…

How showking the day was for me when my girlfriend just said me “K3U” (I❤ U ) (I Love you) and was waiting for my response and i was like KAY (okay).

Even new smiley’s are also emerging at a speed of emerging companies in bangalore , SNH , some of them are noted below:

· 😡 Angry
· >:) Evil Grin
· >:D Scheming Maniacal
· >:D< Hug
· >:O Angry
· >O< Yelling
· >_> Looking left, shifty look
· >_< Frustrated
· &HEARTS; HTML code for a heart
· <# Misspelling of❤
· <> Not equal No comment
· <>< Fish
· <.< Shifty look

I was wonderinng if there will be a time when there will be a subject on slang and it will be accepted as a informal language around the world.

k let’s wait for the day and enjoy till then…. keep reading !!!!🙂🙂

Making an alias command permanent in unix/linux


You would love to read:

How to work with alias command in unix?

Finding a file with its name in unix/linux?

____________________________________________________________________________________________

In order to make a alias shortcut permanent you need to make that entry into the .profile file of your home directory.

to find out the file go to your home directory and type
$ ls -latr

This command will show all hidden files (.profile is also a hidden file)finding .profile file

Then edit the file using vi editor i.e.
$ vi .profile

vi entry
Make the desired entries and save the file , same can be seen in below screenshots.

Then just restart your system , to let the .profile execute and make your shortcuts permanent🙂🙂


It can be quite interesting to work in linux through alias command , you can create some crazy names for big commands or just shorten some big paths to some memorable words.

Just use the alias command to do that:

SYNTAX:  $ alias myfolder=”cd /home/deepak/abcd/dd/erfd”

and now when you gonna type myfolder you will reach to the cd /home/deepak/abcd/dd/erfd path.

CONS: It reamins active till that session and so are temporary.

PROS: can be made permamnent for a unix /linux machine if the same whole command is added to the .profile file of a user and then a restart to execute that file and make our alias works forever🙂

HOW TO MAKE AN ENTRY IN .PROFILE FILE ? WATCH OUT OUR NEXT POST !!

alias creation in unix


Looking for a way to find out a file in a unix/linux box , you just need the exact file name with proper case and that’s it .

Use below command and enoy!!

Find . -name “name_of_file.doc”

here . represents the loaction from where it will search , if not at all sure you can use from / too i.e.

Find / -name “name_of_file.doc”

Simple Login Program in C#.NET


ASPX PAGE:

<%@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”Default.aspx.cs” Inherits=”_Default” %>

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt;

<html xmlns=”http://www.w3.org/1999/xhtml”&gt;
<head runat=”server”>
    <title></title>
</head>
<body>
    <form id=”form1″ runat=”server”>
    <div>
        <asp:Label ID=”Label1″ runat=”server” Text=”User Name”></asp:Label>
<asp:TextBox ID=”UserNameTextBox” runat=”server”></asp:TextBox>
        <br />
        <asp:Label ID=”Label2″ runat=”server” Text=”Password”></asp:Label>
        <asp:TextBox ID=”PasswordTextBox” runat=”server”></asp:TextBox>
        <br />
        <br />
        <asp:Button ID=”SubmittButton” runat=”server” onclick=”SubmittButton_Click” Text=”Submitt” />
        <asp:Label ID=”ResultLabel” runat=”server”></asp:Label>
    </div>
    </form>
</body>
</html>

ASPX.CS PAGE:

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

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

    }
    protected void SubmittButton_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(“Server=DEEPAK-PC;Database=Practice;trusted_connection=true”);
        SqlCommand cmd = new SqlCommand(“CheckForLogin”, con);
        con.Open();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue(“@UserName”, UserNameTextBox.Text);
        cmd.Parameters.AddWithValue(“@Password”, PasswordTextBox.Text);
        int res = Convert.ToInt32(cmd.ExecuteScalar());
        if (res == 1)
            ResultLabel.Text = “Success”;
        else
            ResultLabel.Text = “Fail”;

    }
}

DATABASE CODING:

–To create table

Create table Login
(
UserName varchar(20),
Password varchar(20)
)

–To view Table

select * from Login

–To Insert value in table

insert into Login values(‘deepak’,’DEEPAK’)

–To create procedure
create proc CheckForLogin
(@UserName varchar(20), @Password varchar(20))
as
begin
select count(*) from Login where Username=@UserName and Password=@Password
end


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

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

//to populate the country name in dropdown
        if (!IsPostBack)
        {

            SqlConnection deptConnection = new SqlConnection(“Server=.;Database=Login;trusted_connection=true”);
            SqlCommand deptCommand = new SqlCommand(“Select * from Country”, deptConnection);           //Country is a table
            deptConnection.Open();
            SqlDataReader reader = deptCommand.ExecuteReader();
            DLocationDropDownList.DataSource = reader;
            DLocationDropDownList.DataTextField = “CountryName”;
            DLocationDropDownList.DataValueField = “CountryId”;
            DLocationDropDownList.DataBind();

        }
        

    }
    protected void AddDeptButton_Click(object sender, EventArgs e)
    {
        SqlConnection deptConnection = new SqlConnection(“Server=.;Database=Login;trusted_connection=true”);
        SqlCommand addcmd = new SqlCommand(“AddDept”, deptConnection);
        addcmd.CommandType = CommandType.StoredProcedure;
        deptConnection.Open();
        SqlParameter returnParameter = addcmd.Parameters.Add(“@result”, SqlDbType.Int);
        returnParameter.Direction = ParameterDirection.ReturnValue;
        addcmd.Parameters.AddWithValue(“@DepartmenttName”, DNameTextBox.Text);
        addcmd.Parameters.AddWithValue(“@CountryId”, DLocationDropDownList.SelectedValue);
        addcmd.Parameters.AddWithValue(“@Discription”, DiscriptiomnTextBox.Text);
      
        addcmd.ExecuteNonQuery();
        ResultLabel.Text = addcmd.Parameters[“@result”].Value.ToString();
   
    }
    protected void CancelButton_Click(object sender, EventArgs e)
    {
        Response.Redirect(“Department.aspx”);
    }

    protected void DLocationDropDownList_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace ADODOTNET
{
    class Program
    {
        static void Main(string[] args)
        {
            //SqlConnection northconnection=null;
            //SqlCommand Hellocmd = null;
            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    Hellocmd = new SqlCommand(“Hello”, northconnection);
            //    Hellocmd.CommandType = CommandType.StoredProcedure;

            //    SqlParameter returnParameter = Hellocmd.Parameters.Add(“@ret”, SqlDbType.Int);
            //    returnParameter.Direction = ParameterDirection.ReturnValue;

            //    northconnection.Open();
            //    int x = Hellocmd.ExecuteNonQuery();         //any reader or scalar , all 3 allowed
            //    Console.WriteLine(Hellocmd.Parameters[“@ret”].Value);
            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //finally
            //{
            //    northconnection.Close();
            //}

            //……………………………………………………………………………………………
            //……………………………………………………………………………………………

            //SqlConnection northconnection = null;
            //SqlCommand HelloNamecmd;
            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    HelloNamecmd = new SqlCommand(“HelloName”, northconnection);
            //    HelloNamecmd.CommandType = CommandType.StoredProcedure;

            //    SqlParameter returnParameter = HelloNamecmd.Parameters.Add(“@ret”, SqlDbType.Int);
            //    returnParameter.Direction = ParameterDirection.ReturnValue;
            //    Console.WriteLine(“enter a name”);
            //    String nam = Console.ReadLine();
            //    HelloNamecmd.Parameters.AddWithValue(“@name”,nam);

            //    northconnection.Open();
            //    int x = HelloNamecmd.ExecuteNonQuery();         
            //    Console.WriteLine(HelloNamecmd.Parameters[“@ret”].Value);
            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //finally
            //{
            //    northconnection.Close();
            //}

            //……………………………………………………………………………………………
            //……………………………………………………………………………………………

            //SqlConnection northconnection = null;
            //SqlCommand HelloNamecmd;
            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    HelloNamecmd = new SqlCommand(“HelloAge”, northconnection);
            //    HelloNamecmd.CommandType = CommandType.StoredProcedure;

            //    SqlParameter returnParameter = HelloNamecmd.Parameters.Add(“@ret”, SqlDbType.Int);
            //    returnParameter.Direction = ParameterDirection.ReturnValue;
            //    Console.WriteLine(“enter a name”);
            //    String nam = Console.ReadLine();
            //    HelloNamecmd.Parameters.AddWithValue(“@name”, nam);
            //    Console.WriteLine(“enter the age”);
            //    int age = Convert.ToInt32(Console.ReadLine());
            //    HelloNamecmd.Parameters.AddWithValue(“@age”, age);

            //    northconnection.Open();
            //    int x = HelloNamecmd.ExecuteNonQuery();
            //    Console.WriteLine(HelloNamecmd.Parameters[“@ret”].Value);
            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //finally
            //{
            //    northconnection.Close();
            //}

            //……………………………………………………………………………………………
            //……………………………………………………………………………………………

            //SqlConnection northconnection = null;
            //SqlCommand Empcmd;
            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    Empcmd = new SqlCommand(“EmployeeDetails”, northconnection);
            //    Empcmd.CommandType = CommandType.StoredProcedure;

            //    Console.WriteLine(“enter employee number”);
            //    String empno = Console.ReadLine();
            //    Empcmd.Parameters.AddWithValue(“@empId”, empno);

            //    northconnection.Open();
            //    SqlDataReader reader = Empcmd.ExecuteReader();

            //    while (reader.Read())
            //    {
            //        Console.WriteLine(reader[0].ToString() + reader[1].ToString() + reader[2].ToString() + reader[3].ToString());
            //    }

            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //finally
            //{
            //    northconnection.Close();
            //}

            //……………………………………………………………………………………………
            //……………………………………………………………………………………………

            //SqlConnection northconnection = null;
            //SqlCommand Empcmd;
            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    Empcmd = new SqlCommand(“Empdetail”, northconnection);
            //    Empcmd.CommandType = CommandType.StoredProcedure;

            //    Console.WriteLine(“enter employee number”);
            //    String empno = Console.ReadLine();
            //    Empcmd.Parameters.AddWithValue(“@empId”, empno);

            //    northconnection.Open();
            //    SqlDataReader reader = Empcmd.ExecuteReader();

            //    while (reader.Read())
            //    {
            //        Console.WriteLine(reader[0].ToString() + reader[1].ToString() + reader[2].ToString() + reader[3].ToString());
            //    }

            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //finally
            //{
            //    northconnection.Close();
            //}

            //……………………………………………………………………………………………
            //……………………………………………………………………………………………

            //SqlConnection northconnection = null;
            //SqlCommand Empcmd;
            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    Empcmd = new SqlCommand(“AddDept”, northconnection);
            //    Empcmd.CommandType = CommandType.StoredProcedure;

            //    SqlParameter returnParameter = Empcmd.Parameters.Add(“@ret”, SqlDbType.Int);
            //    returnParameter.Direction = ParameterDirection.ReturnValue;

            //    northconnection.Open();
            //    int x=Empcmd.ExecuteNonQuery();
            //    Console.WriteLine(Empcmd.Parameters[“@ret”].Value);

            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //finally
            //{
            //    northconnection.Close();
            //}

            //……………………………………………………………………………………………
            //……………………………………………………………………………………………

            //SqlConnection northconnection = null;
            //SqlCommand Empcmd;
            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    Empcmd = new SqlCommand(“ModifyEmployee”, northconnection);
            //    Empcmd.CommandType = CommandType.StoredProcedure;

            //    SqlParameter returnParameter = Empcmd.Parameters.Add(“@ret”, SqlDbType.Int);
            //    returnParameter.Direction = ParameterDirection.ReturnValue;
            //    Console.WriteLine(“enter the employee id whose name need to change”);
            //    int employeeid = Convert.ToInt32(Console.ReadLine());
            //    Empcmd.Parameters.AddWithValue(“@empId”, employeeid);

            //    Console.WriteLine(“enter the name you want to enter”);
            //    String nam = Console.ReadLine();
            //    Empcmd.Parameters.AddWithValue(“@fname”, nam);

            //    northconnection.Open();
            //    int x = Empcmd.ExecuteNonQuery();
            //    Console.WriteLine(Empcmd.Parameters[“@ret”].Value);

            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //finally
            //{
            //    northconnection.Close();
            //}

            //……………………………………………………………………………………………
            //……………………………………………………………………………………………

            //SqlConnection northconnection = null;
            //SqlCommand Empcmd;
            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    Empcmd = new SqlCommand(“RemoveEmployee”, northconnection);
            //    Empcmd.CommandType = CommandType.StoredProcedure;

            //    SqlParameter returnParameter = Empcmd.Parameters.Add(“@ret”, SqlDbType.Int);
            //    returnParameter.Direction = ParameterDirection.ReturnValue;
            //    Console.WriteLine(“enter the employee id whose record need to be deleted”);
            //    int employeeid = Convert.ToInt32(Console.ReadLine());
            //    Empcmd.Parameters.AddWithValue(“@empId”, employeeid);

            //    northconnection.Open();
            //    int x = Empcmd.ExecuteNonQuery();
            //    Console.WriteLine(Empcmd.Parameters[“@ret”].Value);

            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //finally
            //{
            //    northconnection.Close();
            //}
            //……………………………………………………………………………………………
            //……………………………………………………………………………………………

            //SqlConnection northconnection = null;
            //SqlCommand Empcmd;
            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    Empcmd = new SqlCommand(“Select * from Employee”, northconnection);

            //    northconnection.Open();
            //    SqlDataReader reader = Empcmd.ExecuteReader();

            //    while (reader.Read())
            //    {
            //        Console.WriteLine(reader[0].ToString() + reader[1].ToString() + reader[2].ToString() + reader[3].ToString());
            //    }

            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //finally
            //{
            //    northconnection.Close();

            //}
            //……………………………………………………………………………………………
            //……………………………………………………………………………………………

            //SqlConnection northconnection = null;
            //SqlCommand Empcmd;
            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    Empcmd = new SqlCommand(“insert into Employee values (”  , northconnection);

            //    SqlParameter returnParameter = Empcmd.Parameters.Add(“@ret”, SqlDbType.Int);
            //    returnParameter.Direction = ParameterDirection.ReturnValue;

            //    northconnection.Open();
            //    int x = Empcmd.ExecuteNonQuery();
            //    Console.WriteLine(Empcmd.Parameters[“@ret”].Value);

            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //finally
            //{
            //    northconnection.Close();
            //}

            //Disconnected starts here……………………………………………………………

            //SqlConnection northconnection = null;
            //SqlDataAdapter empadapdter = null;

            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    empadapdter = new SqlDataAdapter(“select * from Employee”, northconnection);
            //    DataSet ds = new DataSet();
            //    empadapdter.Fill(ds, “Employeenew”); // any name that be in cache

            //    foreach (DataColumn Column in ds.Tables[0].Columns)
            //    {
            //        Console.Write(Column.ColumnName);
            //    }

            //    foreach (DataRow Row in ds.Tables[0].Rows)
            //    {
            //        Console.WriteLine(Row[0].ToString() + Row[1].ToString() + Row[2].ToString() + Row[3].ToString());
            //    }

            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //……………………………………………………………………………
            //……………………………………………………………………………

            //SqlConnection northconnection = null;
            //SqlDataAdapter empadapdter = null;

            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    empadapdter = new SqlDataAdapter(“select * from Employee”, northconnection);
            //    DataSet ds = new DataSet();
            //    empadapdter.Fill(ds, “Employeenew”); // any name that be in cache
            //    SqlCommandBuilder builder = new SqlCommandBuilder(empadapdter);

            //    Console.WriteLine(“enter the first name that u want to update”);
            //    String name = Console.ReadLine();

            //    Console.WriteLine(ds.Tables[0].Rows[2][“emp_fname”]= name);

            //    foreach (DataColumn Column in ds.Tables[0].Columns)
            //    {
            //        Console.Write(Column.ColumnName);
            //    }

            //    foreach (DataRow Row in ds.Tables[0].Rows)
            //    {
            //        Console.WriteLine(Row[0].ToString() + Row[1].ToString() + Row[2].ToString() + Row[3].ToString());
            //    }

            //    empadapdter.Update(ds, “Employeenew”);

            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //……………………………………………………………………………
            //…………………………..prog 3………………………………

            //SqlConnection northconnection = null;
            //SqlDataAdapter empadapdter = null;

            //try
            //{
            //    northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
            //    empadapdter = new SqlDataAdapter(“select * from Employee”, northconnection);
            //    DataSet ds = new DataSet();
            //    empadapdter.Fill(ds, “Employeenew”); // any name that be in cache
                

            //    foreach (DataColumn Column in ds.Tables[0].Columns)
            //    {
            //        Console.Write(Column.ColumnName);
            //    }

            //    foreach (DataRow Row in ds.Tables[0].Rows)
            //    {
            //        if (Row[3].ToString() == “d3”)
            //        {
            //            Row[1] = Row[1].ToString() + Row[3].ToString();
            //        }

            //        Console.WriteLine(Row[0].ToString() + Row[1].ToString() + Row[2].ToString() + Row[3].ToString());
            //    }

                

            //}

            //catch (Exception e)
            //{
            //    Console.WriteLine(e.Message);
            //}

            //……………………………………………………………………………
            //…………………………..CALLING A PROCEDURE………………………………

            SqlConnection northconnection = null;
            SqlDataAdapter empadapdter = null;
            SqlCommand Empcmd = null;

            try
            {
                northconnection = new SqlConnection(“Server=LOCALHOST;Database = DAY1;trusted_connection = true”);
                empadapdter = new SqlDataAdapter(“select * from Department”, northconnection);
                Empcmd = new SqlCommand(“AddDept”, northconnection);
                Empcmd.CommandType = CommandType.StoredProcedure;

                DataSet ds = new DataSet();
                empadapdter.Fill(ds, “Employeenew”);
                SqlCommandBuilder builder = new SqlCommandBuilder(empadapdter);

                foreach (DataColumn Column in ds.Tables[0].Columns)
                {
                    Console.Write(Column.ColumnName);
                }

                foreach (DataRow Row in ds.Tables[0].Rows)
                {
                    Console.WriteLine(Row[0].ToString() + Row[1].ToString() + Row[2].ToString());
                }

                empadapdter.Update(ds, “Employeenew”);
            }

            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }

        }
    }

}