1 using System.Data.OleDb;
2
3 System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection();
4
5 //ファイルパス(プログラム実行ファイルと同じパス)の取得
6 string filePath =
7 System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
8
9 System.Data.OleDb.OleDbCommand com;
10
11 cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
12 "Data Source=D:\開発\uremasse_J_64\Amazon1\Amazon1\bin\x86\Release\uremasse.mdb;
13 Persist Security Info=False;User ID=Admin;Jet OLEDB:Database Password=xxxx";
14
15 try
16 {
17 cn.Open();
18 //SQLコマンド
19 com = new System.Data.OleDb.OleDbCommand
20 ("insert into FBAZaiko values(@sku,@asin,@quantity)", cn);
21 //パラメータ設定
22 System.Data.OleDb.OleDbParameter parm0 = com.Parameters.Add("@sku", OleDbType.VarChar, 50);
23 parm0.Value = FBAZaiko[0];
24
25 System.Data.OleDb.OleDbParameter parm1 = com.Parameters.Add("@asin", OleDbType.VarChar, 10);
26 parm1.Value = FBAZaiko[2];
27
28 System.Data.OleDb.OleDbParameter parm2 = com.Parameters.Add("@quantity", OleDbType.Numeric);
29 parm2.Value = int.Parse(FBAZaiko[5]);
30
31 //SQL処理
32 com.ExecuteNonQuery();
33
34 cn.Close();
35 }
36 catch (Exception ex)
37 {
38 MessageBox.Show(ex.Message, "通知");
39 }
|