質問編集履歴
4
編集しました
test
CHANGED
|
@@ -1 +1 @@
|
|
|
1
|
-
AccessDBにアクセスをして、sqlで抽出した件数と検索データを取得したい
|
|
1
|
+
至急お願いします。AccessDBにアクセスをして、sqlで抽出した件数と検索データを取得したい
|
test
CHANGED
|
File without changes
|
3
編集しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -44,7 +44,7 @@
|
|
|
44
44
|
|
|
45
45
|
OleDbDataReader reader = comm.ExecuteReader();
|
|
46
46
|
|
|
47
|
-
-
|
|
47
|
+
-この部分で表示件数を取得したいです。-
|
|
48
48
|
|
|
49
49
|
|
|
50
50
|
|
2
編集いたしました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -32,6 +32,10 @@
|
|
|
32
32
|
|
|
33
33
|
OleDbCommand comm = new OleDbCommand();
|
|
34
34
|
|
|
35
|
+
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + inputFilePath + FileName;
|
|
36
|
+
|
|
37
|
+
|
|
38
|
+
|
|
35
39
|
comm.Connection = conn;
|
|
36
40
|
|
|
37
41
|
comm.CommandText = "select count(*) from tableA where tableA.CYCLE = (SELECT MAX(tableA_1.CYCLE) FROM tableA AS tableA_1 WHERE tableA.IDNO = tableA_1.IDNO)";
|
1
編集いたしました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -34,7 +34,7 @@
|
|
|
34
34
|
|
|
35
35
|
comm.Connection = conn;
|
|
36
36
|
|
|
37
|
-
comm.CommandText = "select count(*) from
|
|
37
|
+
comm.CommandText = "select count(*) from tableA where tableA.CYCLE = (SELECT MAX(tableA_1.CYCLE) FROM tableA AS tableA_1 WHERE tableA.IDNO = tableA_1.IDNO)";
|
|
38
38
|
|
|
39
39
|
comm.Connection = conn;
|
|
40
40
|
|