Category: Wat’s New



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.


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);
            }

        }
    }

}

Gangnam style facebook chat code smiley


Copy and paste in facebook chat box :

[[534189913290846]] [[534189889957515]] [[534189896624181]]
[[534189893290848]] [[534189906624180]] [[534190003290837]]
[[534190006624170]] [[534190016624169]] [[534189999957504]]
[[534190009957503]] [[534190159957488]] [[534190183290819]]
[[534190176624153]] [[534190179957486]] [[534190163290821]]
[[534190319957472]] [[534190309957473]] [[534190306624140]]
[[534190323290805]] [[534190313290806]] [[534190559957448]]
[[534190566624114]] [[534190556624115]]

Do comment which smiley you want next!!!


“oh!! i think it is lengthy enough , will people gonna read so much , i think i need to omit some lines , oh but it won’t make a sense to the real readers”

A blogger , may belong to any field have a lot of thoughts which always runs in his mind while he writes a post , may be he call himself a freelance blogger who don’t care what he is writing , what he is sharing but the truth lies is that until his creation got published and until he got his desired feedback a situation of dilemma always crawls inside his mind.

From the situation of becoming his creation into a controversy to becoming the interference to some one’s personnel life his words stumbles on each and every step. The feeling of may be some one gonna dislike this stops his word , even now some are murmuring that  ” its just your views dude, i am not not really like that” ah!! i am sorry for them , i would have included a disclaimer , oh! its my post i can put it anywhere:
P.S. : Disclaimer :These are my personnel views no need to be Sentimental – if u are frustrated reading this , take help of cross button in top right corner of your window!!

The anxiety of post completeness , the wait for that first comment , the feeling of someone’s appraisal each and every thing is just a desire for him and while writing  sometimes that even reflects in his words. But for him it is his best may it depends on his audience how they get it , how it is portrayed and how it falls on them but for him that is his everything and views of his readers are his award in his race with his thoughts.

” oh !! will that be fine.. oh i think it is fine !! should i include some pictures , ah! what is the need people don’t come here to see the pics ,
.
but presentation is more important than the stuff..but but  hey….hey…hey stop it don’t click on publish i want to write more…….. !!!

Oh u have done it, then let it be “

Free 50 fax each month to anywhere in world


Now you can send 50 fax to anywhere in world for free as long as you have a google or microsoft account.

free fax

 

go here to enjoy the same.

 



An engineer ,who says are just born to design , create and just sacrifice their life in mugging , coming into focus in a just a bit span of time Mr. Ajit Singh Tanwar from Khetri Nagar,rajasthan a  graduate engineer from Jaipur , Rajasthan have proved it wrong. His breathtaking performances on the stage of India’s Got Talent are like he is born to dance and the phrase BORN FROM THE BOOM BOX will be the best to define him.

For dancer Ajit who is a Rajput from Rajasthan, dancing wasn’t an option initially.  After begging and pleading with his father, he got a new lease of life with India’s Got Talent auditions where he made it to the semi finals. Known for his brain popping style that involves body isolations with unimaginable twists and turns, he left the jury absolutely wowed.

Coming out of a web this week, Ajit was Spider personified and in Karan’s words, though it was a fantastic act, he looked like a ‘talli spider’. Farah, on he contrary, couldn’t get over his body’s flexibility and advised him to never buy a flight ticket. All he needs to do is fold himself into a bag and go for it!

What was also special was the fact that his father, after seeing his success on the show, has accepted him as a dancer and has told him that he was born to dance. Soon, we guess we will hear Ajit sing “papa kehte hain bada naan karega”. Way to go Ajit is all we can say.

How to Obtain the Dell Service Tag in offline mode


Follow the below steps:

  • Navigate to the “Start” menu and select “Run.” In the Run dialog, type “cmd” (without quotes) and click “OK.” The Command Prompt dialog opens.
  • Type “wmic bios get serialnumber” (without quotes). Press “Enter.” The computer responds with information from the Dell remote computer. The information below “Serial Number” is the Dell system service tag.
  • To obtain the make and model number, type “wmic csproduct get vendor,name,identifyingnumber” (without quotes). Press “Enter.”