質問編集履歴
3
編集
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -3,12 +3,25 @@
|
|
|
3
3
|
|
|
4
4
|
```c#
|
|
5
5
|
string DataSource ="oracleのPASS"
|
|
6
|
-
string sql= "select * from SampleTable where date>=
|
|
6
|
+
string sql= "select * from SampleTable where date>=startDate";
|
|
7
7
|
using(OracleConnection conn = new OracleConnection(DataSource))
|
|
8
8
|
{
|
|
9
9
|
conn.Open();
|
|
10
10
|
using(OracleCommand cmd=new OracleCommand(sql,conn)
|
|
11
11
|
{
|
|
12
|
+
//パラメータの作成
|
|
13
|
+
OracleParameter parameterS = new OracleParameter();
|
|
14
|
+
|
|
15
|
+
//パラメータ名はコロンを除いた名前を指定します。
|
|
16
|
+
parameterS.ParameterName = "StartDate";
|
|
17
|
+
|
|
18
|
+
//パラメータの値を設定します。
|
|
19
|
+
parameterS.Value = StartDate;
|
|
20
|
+
|
|
21
|
+
//パラメータをコマンドに追加します。
|
|
22
|
+
cmd.Parameters.Add(parameterS);
|
|
23
|
+
|
|
24
|
+
|
|
12
25
|
using(OracleDataReader read=cmd.ExecuteReader())
|
|
13
26
|
{
|
|
14
27
|
|
2
誤字
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -7,7 +7,7 @@
|
|
|
7
7
|
using(OracleConnection conn = new OracleConnection(DataSource))
|
|
8
8
|
{
|
|
9
9
|
conn.Open();
|
|
10
|
-
using(
|
|
10
|
+
using(OracleCommand cmd=new OracleCommand(sql,conn)
|
|
11
11
|
{
|
|
12
12
|
using(OracleDataReader read=cmd.ExecuteReader())
|
|
13
13
|
{
|
1
誤字
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -3,7 +3,7 @@
|
|
|
3
3
|
|
|
4
4
|
```c#
|
|
5
5
|
string DataSource ="oracleのPASS"
|
|
6
|
-
string sql= select * from SampleTable where date>='20201120'
|
|
6
|
+
string sql= "select * from SampleTable where date>='20201120'";
|
|
7
7
|
using(OracleConnection conn = new OracleConnection(DataSource))
|
|
8
8
|
{
|
|
9
9
|
conn.Open();
|