1、创建一个数据文件。dbConnection.cs 代码如下:
using System;
namespace musicAPP.database
{
/// <summary>
/// dbConnection 的摘要说明。
/// </summary>
public class dbConnection
{
public dbConnection()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static string connection
{
get
{return"Data Source=db.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0;";} //该数据文件,路径是启动Debug目录下的
}
}
}
2、引用 using System.Data.OleDb;
using System.Data.OleDb;
namespace musicAPP
{
public partial class Form1 : Form
{
private OleDbConnection oleConnection1 = null;
public Form1()
{
InitializeComponent();
this.oleConnection1 = new OleDbConnection(musicAPP.database.dbConnection.connection);
}
}
}
3、事件里处理数据语句,代码如下:
private void toolStripButton3_Click(object sender, EventArgs e)
{
oleConnection1.Open();
string sql = "INSERT INTO txt ( [text] ) VALUES ('"+textBox1.Text.ToString().Trim()+"')";
OleDbCommand cmd = new OleDbCommand(sql, oleConnection1);
cmd.ExecuteNonQuery();
textBox2.Text = sql;
MessageBox.Show("保存成功");
oleConnection1.Close();
}