1 using System.Data.OleDb;
2
3 System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection();
4 System.Data.OleDb.OleDbCommand com;
5
6 //接続文字列を設定し、データベースに接続する
7 cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
8 "Data Source=D:\開発\uremasse_J_64\Amazon1\Amazon1\bin\x86\Release\uremasse.mdb;
9 Persist Security Info=False;User ID=Admin;Jet OLEDB:Database Password=xxxx";
10
11 cn.ConnectionString = Properties.Settings.Default.ConnectionString;
12
13 try
14 {
15
16 cn.Open();
17
18 //DBコマンドの作成
19 com = new System.Data.OleDb.OleDbCommand("delete from BatchSearch", cn);
20
21 com.ExecuteNonQuery();
22
23 cn.Close();
24
25 }
26 catch (Exception ex)
27 {
28 MessageBox.Show(ex.Message, "通知");
29 }
|