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 try
12 {
13 cn.Open();
14
15 com = new System.Data.OleDb.OleDbCommand
16 ("update BatchSearch set teianPrice = @teianPrice where tuban = @tuban", cn);
17
18 //パラメータ設定
19 System.Data.OleDb.OleDbParameter parm0 = com.Parameters.Add("@teianPrice", OleDbType.VarChar, 10);
20 parm0.Value = teianPrice;
21
22 System.Data.OleDb.OleDbParameter parm1 = com.Parameters.Add("@tuban", OleDbType.VarChar, 5);
23 parm1.Value = tuban;
24
25 //SQL処理
26 com.ExecuteNonQuery();
27
28 cn.Close();
29
30 }
31 catch (Exception ex)
32 {
33 MessageBox.Show(ex.Message, "通知");
34 }
|