Esempio n. 1
0
        protected void btnInsert_Click(object sender, EventArgs e)
        {
            //GETTING DATA
            string nom, apem, apep, tele, correo;

            nom    = Encriptar(TxtNom.Text);
            apem   = Encriptar(TxtApeM.Text);
            apep   = Encriptar(TxtApeP.Text);
            tele   = Encriptar(TxtTel.Text);
            correo = Encriptar(TxtCorreo.Text);

            try
            {
                string        sql;
                SqlDataReader reader;
                SqlConnection conexion = new SqlConnection(get_connectionString());
                conexion.Open();
                sql = "INSERT INTO [dbo].[Maestro] ([Nomina],[Nombre],[ApePaterno],[ApeMaterno],[Telefono],[Correo],[cveEstado],[cveMunicipio],[cveLocalidad]) VALUES ('" + TxtNomi.Text + "','" + nom + "','" + apep + "','" + apem + "','" + tele + "','" + correo + "'," + DDEstado.SelectedValue.ToString() + "," + DDMunicipio.SelectedValue.ToString() + "," + DDLocalidad.SelectedValue.ToString() + ")";
                SqlCommand miComando = new SqlCommand();
                miComando.CommandText = sql;
                miComando.Connection  = conexion;
                reader         = miComando.ExecuteReader();
                TxtNomi.Text   = "";
                TxtNom.Text    = "";
                TxtApeP.Text   = "";
                TxtApeM.Text   = "";
                TxtTel.Text    = "";
                TxtCorreo.Text = "";
                GVMaestrosEdoMunLoc.DataBind();
            }
            catch (Exception x)
            {
                Response.Write(x.ToString());
            }
        }
Esempio n. 2
0
 protected void btnDelete_Click(object sender, EventArgs e)
 {
     try
     {
         string        sql;
         SqlDataReader reader;
         SqlConnection conexion = new SqlConnection(get_connectionString());
         conexion.Open();
         sql = "DELETE FROM [dbo].[Maestro] WHERE ([Nomina]='" + TxtNomi.Text + "')";
         SqlCommand miComando = new SqlCommand();
         miComando.CommandText = sql;
         miComando.Connection  = conexion;
         reader         = miComando.ExecuteReader();
         TxtNomi.Text   = "";
         TxtNom.Text    = "";
         TxtApeP.Text   = "";
         TxtApeM.Text   = "";
         TxtTel.Text    = "";
         TxtCorreo.Text = "";
         GVMaestrosEdoMunLoc.DataBind();
     }
     catch (Exception x)
     {
         Response.Write(x.ToString());
     }
 }