// ========================== LISTAR-COMBO-EMPLEADO ==========================
public DataSet Listar_carrera_rep()
{
DataSet ds = new DataSet();
ClsConexion cadenaconexion = new ClsConexion();
using (SqlConnection cn = new SqlConnection())
{
using (SqlDataAdapter da = new SqlDataAdapter())
{
using (SqlCommand cmd = new SqlCommand())
{
cn.ConnectionString = cadenaconexion.cadenaconexion();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "listar_carrera";
da.SelectCommand = cmd;
cn.Open();
da.Fill(ds);
cn.Close();
}
}
}
return(ds);
}
// ========================== ACTUALIZAR-EMPLEADO ==========================
public int Actualizar_docente(string nombre, int id)
{
int iret;
ClsConexion cadenaconexion = new ClsConexion();
using (SqlConnection cn = new SqlConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
cn.ConnectionString = cadenaconexion.cadenaconexion();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "actualizar_docente";
cmd.Parameters.Add("@nombre", SqlDbType.VarChar).Value = nombre;
cmd.Parameters.Add("@iddocente", SqlDbType.Int).Value = id;
cn.Open();
iret = cmd.ExecuteNonQuery();
cn.Close();
}
}
return(iret);
}
