Secundarias Generales
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnalta_Click(object sender, EventArgs e)
{
SqlCommand mycommman;
datos inserta = new datos();
if (inserta.conectar())
{
mycommman =inserta.construye_command("insert into Alumno (Nombre, Apellidop, Apellidom, No_control,Especialidad,Semestre) values( @Nombre, @Apellidop, @Apellidom, @No_control, @Especialidad, @Semestre) ");
mycommman.Parameters.Add(new SqlParameter("@Nombre", SqlDbType.VarChar, 50));
mycommman.Parameters["@Nombre"].Value = txtnom.Text;
mycommman.Parameters.Add(new SqlParameter("@Apellidop",SqlDbType.VarChar, 50));
mycommman.Parameters["@Apellidop"].Value = txtapep.Text;
mycommman.Parameters.Add(new SqlParameter("@Apellidom", SqlDbType.VarChar, 50));
mycommman.Parameters["@Apellidom"].Value = txtapem.Text;
mycommman.Parameters.Add(new SqlParameter("@No_control", SqlDbType.VarChar, 50));mycommman.Parameters["@No_control"].Value = txtmat.Text;
mycommman.Parameters.Add(new SqlParameter("@Especialidad", SqlDbType.VarChar, 50));
mycommman.Parameters["@Especialidad"].Value = txtes.Text;
mycommman.Parameters.Add(new SqlParameter("@Semestre", SqlDbType.VarChar, 50));
mycommman.Parameters["@Semestre"].Value = txtsem.Text;
if(inserta.ejecutanonquery() != 0)
MessageBox.Show("Registro Insertardo");
else
MessageBox.Show("No se afectaron Registros");
mycommman.Connection.Close();
inserta.desconectar();
}
else
MessageBox.Show("No se afectaron registros");
}
protected void Button1_Click(object sender, EventArgs e)
{}
protected void btndatos_Click(object sender, EventArgs e)
{
datos d = new datos();
GridView1.DataSource = d.tabla();
GridView1.DataBind();
}
protected void Button1_Click1(object sender, EventArgs e)
{
Response.Redirect("/esmeysushnos/Default2.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{Response.Redirect("/esmeysushnos/Default3.aspx");
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
CODIGO DEL BOOTON DE ACTUALIZAR
public partial class Default2 : System.Web.UI.Page
{
datos Selecciona = new datos();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btncargar_Click(object sender, EventArgs e){
SqlDataAdapter Adapter;
DataRow Fila;
if (Selecciona.conectar())
{
Adapter = Selecciona.construye_adapater("select * from Alumno where No_control=@No_control");
Adapter.SelectCommand.Parameters.Add(new SqlParameter("@No_control", SqlDbType.VarChar, 30));
Adapter.SelectCommand.Parameters["@No_control"].Value =txtmat.Text;
Fila = Selecciona.estra_registo(Adapter, "No_control");
if (Fila != null)
{
txtnom.Text = Fila["Nombre"].ToString();
txtapep.Text = Fila["Apellidop"].ToString();
txtapem.Text = Fila["Apellidom"].ToString();
txtes.Text = Fila["Especialidad"].ToString();
txtsem.Text =Fila["Semestre"].ToString();
}
else
MessageBox.Show("Error al visualizar el Registro");
}
else
MessageBox.Show("Error al conectar a la Base de Datos");
}
protected void btnmodificar_Click(object sender, EventArgs e)
{
}
public class vista
{
public void muestra_codigo(ComboBox cbm,...
Regístrate para leer el documento completo.