예제 #1
0
        protected void GetRecordToUpdate(String ID)
        {
            SqlCommand    cmd = new SqlCommand();
            SqlConnection con = new SqlConnection(TipoContactoDS.ConnectionString);

            cmd = new SqlCommand("general.[sp_TipoContacto_get_TipoContacto]", con);
            cmd.Parameters.Add(new SqlParameter("@IdTipoContacto", ID));
            cmd.CommandType = CommandType.StoredProcedure;

            SqlDataAdapter adp = new SqlDataAdapter();

            con.Open();

            adp.SelectCommand = cmd;
            DataSet ds = new DataSet();

            adp.Fill(ds);

            EditFormView.DataSource = ds;
            EditFormView.DataBind();

            con.Close();
        }
예제 #2
0
        protected void GetRecordToUpdate(String ID)
        {
            SqlCommand    cmd = new SqlCommand();
            SqlConnection con = new SqlConnection(PostulanteDS.ConnectionString);

            cmd = new SqlCommand("empleo.[sp_Postulante_get_Postulante]", con);
            cmd.Parameters.Add(new SqlParameter("@IdPostulante", ID));
            cmd.CommandType = CommandType.StoredProcedure;

            SqlDataAdapter adp = new SqlDataAdapter();

            con.Open();

            adp.SelectCommand = cmd;
            DataSet ds = new DataSet();

            adp.Fill(ds);

            EditFormView.DataSource = ds;
            EditFormView.DataBind();

            con.Close();
        }