| abstract
| - Para facilitar la tarea de los usuarios de la base de datos vamos a crear un programa que permita realizar operaciones con sus diferentes tablas. El siguiente es el código del formulario para dar de alta formatos de grabación: using System; using System.Windows.Forms; using System.Data.Odbc; namespace MyFormProject { class MainForm : System.Windows.Forms.Form { private System.Windows.Forms.Label label; private System.Windows.Forms.Button cmdGuardar; private System.Windows.Forms.TextBox txtNombre; private System.Windows.Forms.TextBox txtDescripción; private System.Windows.Forms.Label label2; public MainForm() { InitializeComponent(); } // THIS METHOD IS MAINTAINED BY THE FORM DESIGNER // DO NOT EDIT IT MANUALLY! YOUR CHANGES ARE LIKELY TO BE LOST void InitializeComponent() { this.label2 = new System.Windows.Forms.Label(); this.txtDescripción = new System.Windows.Forms.TextBox(); this.txtNombre = new System.Windows.Forms.TextBox(); this.cmdGuardar = new System.Windows.Forms.Button(); this.label = new System.Windows.Forms.Label(); this.SuspendLayout(); // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(8, 48); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(67, 16); this.label2.TabIndex = 3; this.label2.Text = "Descripción:"; // // txtDescripción // this.txtDescripción.Location = new System.Drawing.Point(8, 64); this.txtDescripción.Name = "txtDescripción"; this.txtDescripción.TabIndex = 4; this.txtDescripción.Text = ""; // // txtNombre // this.txtNombre.Location = new System.Drawing.Point(8, 24); this.txtNombre.Name = "txtNombre"; this.txtNombre.Size = new System.Drawing.Size(56, 20); this.txtNombre.TabIndex = 2; this.txtNombre.Text = ""; // // cmdGuardar // this.cmdGuardar.Location = new System.Drawing.Point(8, 88); this.cmdGuardar.Name = "cmdGuardar"; this.cmdGuardar.Size = new System.Drawing.Size(56, 23); this.cmdGuardar.TabIndex = 0; this.cmdGuardar.Text = "Guardar"; this.cmdGuardar.Click += new System.EventHandler(this.CmdGuardarClick); // // label // this.label.AutoSize = true; this.label.Location = new System.Drawing.Point(8, 8); this.label.Name = "label"; this.label.Size = new System.Drawing.Size(48, 16); this.label.TabIndex = 1; this.label.Text = "Nombre:"; // // MainForm // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(114, 114); this.Controls.Add(this.txtDescripción); this.Controls.Add(this.label2); this.Controls.Add(this.txtNombre); this.Controls.Add(this.label); this.Controls.Add(this.cmdGuardar); this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow; this.Name = "MainForm"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent; this.Text = "Nuevo soporte"; this.Load += new System.EventHandler(this.MainFormLoad); this.ResumeLayout(false); } [STAThread] public static void Main(string[] args) { Application.Run(new MainForm()); } void CmdGuardarClick(object sender, System.EventArgs e) { string sNombre=txtNombre.Text; string sDescripción=txtDescripción.Text; if(sNombre==""){ MessageBox.Show("Indique un nombre."); return; } if(sDescripción==""){ MessageBox.Show("Indique una descripción."); return; } string sConsulta= "INSERT INTO "+ "soporte(nombre,descripcion) "+ "VALUES("+ "'"+sNombre+"',"+ "'"+sDescripción+"'"+ ");"; string sCon="DSN=videoteca"; OdbcConnection oCon=new OdbcConnection(); oCon.ConnectionString=sCon; oCon.Open(); OdbcCommand oCmd=new OdbcCommand(); oCmd.Connection=oCon; oCmd.CommandText=sConsulta; oCmd.ExecuteNonQuery(); } void MainFormLoad(object sender, System.EventArgs e) { } } }
|
![[RDF Data]](/fct/images/sw-rdf-blue.png)