ASP.NET - insertar en una tabla sql valor de un dropdownlist

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[stp_RegistraProveedor]

    @nom AS VARCHAR(50),

    @rut AS VARCHAR(50),

    @rubro AS VARCHAR(30),

    @email AS VARCHAR(20),

    @telefono as varchar(20),

    @contrasena AS VARCHAR(20),

    @pais as int

as

begin

set nocount on

begin transaction

 insert into proveedor (nomempresa,rubro,rut_proveedor,telefono,email)

 values (@nom,@rut,@rubro,@email,@telefono)

  insert into proveedores(id_pais)

  values(@pais)

commit transaction

set nocount off

end

try

            {

                SqlCommand cmd = new SqlCommand("stp_RegistraProveedor", connectionString);

                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add("@nom", SqlDbType.VarChar, 50);

                cmd.Parameters.Add("@rut", SqlDbType.VarChar, 50);

                cmd.Parameters.Add("@rubro", SqlDbType.VarChar, 30);

                cmd.Parameters.Add("@email", SqlDbType.VarChar, 20);

                cmd.Parameters.Add("@telefono", SqlDbType.VarChar, 20);

                cmd.Parameters.Add("@contrasena", SqlDbType.VarChar, 30);

                cmd.Parameters.Add("@pais", SqlDbType.Int);

                cmd.Parameters["@nom"].Value = txtcontrasenaNuevoProveedor.Text;

                cmd.Parameters["@rut"].Value = txtRutNuevoProveedor.Text;

                cmd.Parameters["@rubro"].Value = txtcontrasenaNuevoProveedor.Text;

                cmd.Parameters["@email"].Value = txtRutNuevoProveedor.Text;

                cmd.Parameters["@telefono"].Value = txtcontrasenaNuevoProveedor.Text;

                cmd.Parameters["@contrasena"].Value = txtRutNuevoProveedor.Text;

                connectionString.Open();

                cmd.ExecuteNonQuery();

                connectionString.Close();

                cargardatos();

            }

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@nom", SqlDbType.VarChar, 50);

cmd.Parameters.Add("@rut", SqlDbType.VarChar, 50);

cmd.Parameters.Add("@rubro", SqlDbType.VarChar, 30);

cmd.Parameters.Add("@email", SqlDbType.VarChar, 20);

cmd.Parameters.Add("@telefono", SqlDbType.VarChar, 20);

cmd.Parameters.Add("@contrasena", SqlDbType.VarChar, 30);

cmd.Parameters.Add("@pais", SqlDbType.Int);

cmd.Parameters["@pais"].Value = ddlPaises.SelectedItem;

cmd.Parameters["@nom"].Value = txtNomEmpresa.Text;

cmd.Parameters["@rut"].Value = txtRutNuevoProveedor.Text;

cmd.Parameters["@rubro"].Value = txtRubroNuevoProveedor.Text;

cmd.Parameters["@email"].Value = txtEmailNuevoProveedor.Text;

cmd.Parameters["@telefono"].Value = txtTelefonoNuevoProveedor.Text;

cmd.Parameters["@contrasena"].Value = txtcontrasenaNuevoProveedor.Text;

cmd.Parameters["@pais"].Value = dropCountries.SelectedItem.Value;