Insert into mySql table with C#



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 MySql.Data.MySqlClient;
private void cmdAdd_Click(object sender, EventArgs e)
{
MySqlConnection conn=new MySqlConnection();
MySqlCommand cmd = new MySqlCommand();
string myConnectionString;
string cmdString;
myConnectionString = "server=127.0.0.1; uid=root; pwd=xxxxxx; database=test";
cmdString = "insert into t_students(AdmNo,FirstName,LastName) values('" + txtAdmNo.Text + "','" +                          txtFirstName.Text + "','" + txtLastName.Text + "');";
try
{
conn.ConnectionString = myConnectionString;
conn.Open();
cmd.Connection = conn;
cmd.CommandText = cmdString;
cmd.ExecuteNonQuery();
MessageBox.Show("Record successfully added.");
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Dispose();
}
} =============================================

table definition


create table t_students (     AdmNo int unsigned not null, FirstName varchar(30) not null, LastName varchar(30) not null );


====================================



Comments

Popular posts from this blog

How to Learn Effectively: A Comprehensive Guide