110,538
社区成员
发帖
与我相关
我的任务
分享
public partial class FormAccess : Form
{
OleDbConnection connect = new OleDbConnection(@";Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\ESDB.accdb");
DataTable dt=new DataTable ();
OleDbDataAdapter adapter;
public FormAccess()
{
InitializeComponent();
}
private void FormAccess_Load(object sender, EventArgs e)
{
connect.Open();
adapter = new OleDbDataAdapter();
string selectText = "select * from factory";
DbCommand selectCommand = new OleDbCommand(selectText, connect);
adapter.SelectCommand =(OleDbCommand ) selectCommand;
adapter.Fill(dt);
dataGridView1.DataSource = dt;
string insertText="insert into factory (factoryCode,factoryName,description) values(@factoryCode,@factoryName,@description)";
string updateText = "update factory set factoryName=@factoryname,description=@description where factoryCode=@factoryCode";
OleDbCommand insertCommand = new OleDbCommand(insertText, connect);
insertCommand.Parameters.Add("@factoryCode", OleDbType.VarWChar, 0, "factoryCode");
insertCommand.Parameters.Add("@factoryName", OleDbType.VarWChar, 0, "factoryName");
insertCommand.Parameters.Add("@description", OleDbType.VarWChar, 0, "description");
OleDbCommand updateCommand = new OleDbCommand(updateText, connect);
updateCommand.Parameters.Add("@factoryCode", OleDbType.VarWChar, 0, "factoryCode");
updateCommand.Parameters.Add("@factoryName", OleDbType.VarWChar, 0, "factoryName");
updateCommand.Parameters.Add("@description", OleDbType.VarWChar, 0, "description");
adapter.UpdateCommand = (OleDbCommand)updateCommand;
adapter.InsertCommand = (OleDbCommand)insertCommand;
}
private void button1_Click(object sender, EventArgs e)
{
adapter.Update(dt);
}