when i write this code then it shows error...

[kplshrm7]

Error:- Failed to convert parameter value from a String to a Int32.

code--------------------

SqlConnection conn;
        SqlCommand cmd;
        SqlDataReader reader;
        string connectionString = ConfigurationManager.ConnectionStrings["Dorknozzle"].ConnectionString;
        conn = new SqlConnection(connectionString);
        cmd = new SqlCommand("select Username, Address, City, State, " + "HomePhone, Extention, MobilePhone from employees" + "where Name=@Name", conn);
        cmd.Parameters.Add("@Name",System.Data.SqlDbType.Int);
        cmd.Parameters["@Name"].Value= DropDownList1.SelectedItem.Value.ToString();
        try
        {
            conn.Open();
      reader=cmd.ExecuteReader();
                    {
                nametextbox.Text = reader["Name"].ToString();
                usernameTextBox.Text = reader["Username"].ToString();
                addressTextBox.Text = reader["Address"].ToString();
                cityTextBox.Text = reader["City"].ToString();
                stateTextBox.Text = reader["State"].ToString();
                //zipTextBox.Text = reader["Zip"].ToString();
                homephoneTextBox.Text = reader["HomePhone"].ToString();
                extentionTextBox.Text = reader["Extention"].ToString();
                mobileTextBox.Text = reader["MobilePhone"].ToString();
            }
            reader.Close();
            updateButton.Enabled = true;
        }
        /*catch
        {
            Label1.Text = "Error!!!!!!";
        }*/
        finally
        {
 
            conn.Close();
        }

[Frinavale]

On line 7 & 8 in the above posted code you have the following:

cmd.Parameters.Add("@Name",System.Data.SqlDbType.Int);
cmd.Parameters["@Name"].Value= DropDownList1.SelectedItem.Value.ToString()

You are stating that the @Name parameter should be an "SqlDbType.Int" but then you try to supply a String as a value.

Change the "SqlDbType.Int" to an "SqlDbType.VarChar" if your database is expecting a String. If your database is expecting an Int value for the name then provide an integer (not a String) as a parameter.

-Frinny

[benwizzle]

If I'm correct, you are not converting the value retrieved from the dropdownlist into an int. @Name is an Int32 and the value retrieved from DropDownList1 is a string try this

cmd.Parameters["@Name"].Value = Convert.ToInt32(DropDownList1.SelectedItem.Value);