c# mysql oledb,使用C＃的Microsoft Access和OLEDB在数据库中添加数据

I'm amateur in using of OleDb library and I want to add a text form text box into a database with this library.

My code:

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private OleDbConnection conn = new OleDbConnection();

private void button1_Click(object sender, EventArgs e)

{

conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Project\Learning\Visual C#\Form\WindowsFormsApplication1\WindowsFormsApplication1\Test.mdb";

string NAME = textBox1.Text;

conn.Open();

OleDbCommand cmmd = new OleDbCommand("INSERT into student(NAME)" + "VALUES(@NAME)", conn);

if (conn.State == ConnectionState.Open)

{

cmmd.Parameters.Add("@NAME", OleDbType.Char, 20);

cmmd.Parameters["@NAME"].Value = NAME;

try

{

cmmd.ExecuteNonQuery();

MessageBox.Show("DATA ADDED");

conn.Close();

}

catch (OleDbException expe)

{

MessageBox.Show(expe.Source);

}

}

else

{

MessageBox.Show("CON FAILED");

}

}

}

But doesn't work.

I cant find good reference for "OleDbCommand" command for C#.

How can I use this command in my code?

解决方案

Solved

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

OleDbConnection conn = new OleDbConnection();

conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Project\Learning\Visual C#\Form\WindowsFormsApplication2\WindowsFormsApplication2\Test.mdb";

conn.Open();

string Name = textBox1.Text;

OleDbCommand cmmd = new OleDbCommand("INSERT INTO table1 (student) Values(@Name)", conn);

if (conn.State == ConnectionState.Open)

{

cmmd.Parameters.Add("@Name", OleDbType.VarWChar, 20).Value = Name;

try

{

cmmd.ExecuteNonQuery();

MessageBox.Show("DATA ADDED");

conn.Close();

}

catch (OleDbException expe)

{

MessageBox.Show(expe.Message);

conn.Close();

}

}

else

{

MessageBox.Show("CON FAILED");

}

}