 
			
				11/11/2011, 09:00
			
			
			     |  
      |    |    |    Fecha de Ingreso: noviembre-2009  
						Mensajes: 381
					  Antigüedad: 16 años Puntos: 6     |        |  
  |      Respuesta: INSERT con C# y MySQL        Estoy probando cosas porque es para una capacitación, aqui el code:   
Código:
  using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data;
using MySql.Data.MySqlClient;
namespace WindowsFormsApplication1
{
    public partial class Formulario : Form
    {
        public Formulario()
        {
            InitializeComponent();
        }
        private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
        }
        private void button1_Click(object sender, EventArgs e)
        {
            string connectionString = "Server=localhost;Database=gustavo_test;User ID=root;Password=root;Pooling=false;";
            MySqlConnection conn = new MySqlConnection(connectionString);
            this.listBox1.Items.Add("Titulo:" + this.textBox1.Text);
            this.listBox1.Items.Add("Contenido:" + this.textBox2.Text);
            this.textBox1.Text = string.Empty;
            this.textBox2.Text = string.Empty;
            string valor1 = this.textBox1.Text;
            string valor2 = this.textBox2.Text;
            string query = "INSERT INTO post (id, titulo, contenido, id_categoria) VALUES (null, 'valor1', 'valor2', 1)";
            conn.Open();
            MySqlCommand myCommand = new MySqlCommand(query, conn);
            
            myCommand.Dispose();
            conn.Close();
            textBox1.Focus();
        }
        private void textBox1_TextChanged(object sender, EventArgs e)
        {
        }
        private void textBox2_TextChanged(object sender, EventArgs e)
        {
        }
        private void textBox3_TextChanged(object sender, EventArgs e)
        {
        }
        private void borrar_Click(object sender, EventArgs e)
        {
            this.listBox1.Items.Clear();
            textBox1.Focus();
        }
        private void BotonSalir_Click(object sender, EventArgs e)
        {
            Close();
        }
        private void button1_Click_1(object sender, EventArgs e)
        {
            textBox1.Text = "";
            textBox2.Text = "";
            textBox1.Focus();
        }
        private void button2_Click(object sender, EventArgs e)
        {
            string connectionString = "Server=localhost;Database=gustavo_test;User ID=root;Password=root;Pooling=false;";
            MySqlConnection conn = new MySqlConnection(connectionString);
            string query = "SELECT titulo, contenido FROM post";
            conn.Open();
            MySqlCommand myCommand = new MySqlCommand(query, conn);
            MySqlDataReader myReader = myCommand.ExecuteReader();
            while (myReader.Read())
            {
                this.listBox1.Items.Add("Nombre:" + myReader["titulo"].ToString());
                this.listBox1.Items.Add("Apellido:" + myReader["contenido"].ToString());
            }
            myReader.Close();
            myCommand.Dispose();
            conn.Close();
            textBox1.Focus();
        }
    }
}
  El Main:   
Código:
  using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows.Forms;
using System.Data;
using MySql.Data.MySqlClient;
namespace WindowsFormsApplication1
{
    static class Program
    {
        /// <summary>
        /// Punto de entrada principal para la aplicación.
        /// </summary>
        [STAThread]
        static void Main()
        {
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);
            Application.Run(new Formulario());
            string connectionString = "Server=localhost;Database=gustavo_test;User ID=root;Password=root;Pooling=false;";
            MySqlConnection conn = new MySqlConnection(connectionString);
        }
    }
}
  Muchas gracias! 
Gustavo.            |