質問編集履歴
2
訂正
test
CHANGED
File without changes
|
test
CHANGED
@@ -10,7 +10,7 @@
|
|
10
10
|
|
11
11
|
|
12
12
|
|
13
|
-
```
|
13
|
+
```C#
|
14
14
|
|
15
15
|
cmd.CommandText = "INSERT INTO [dbo].[Table2] ([ID], [年齢])" +
|
16
16
|
|
@@ -38,7 +38,7 @@
|
|
38
38
|
|
39
39
|
|
40
40
|
|
41
|
-
```
|
41
|
+
```C#
|
42
42
|
|
43
43
|
cmd.CommandText = "INSERT INTO [dbo].[Table2] ([ID], [年齢])" +
|
44
44
|
|
1
訂正
test
CHANGED
File without changes
|
test
CHANGED
@@ -12,13 +12,19 @@
|
|
12
12
|
|
13
13
|
```sql
|
14
14
|
|
15
|
-
"INSERT INTO [dbo].[Table2] ([ID], [年齢])" +
|
15
|
+
cmd.CommandText = "INSERT INTO [dbo].[Table2] ([ID], [年齢])" +
|
16
16
|
|
17
17
|
"SELECT [ID], [年齢] FROM [dbo].[Table]" +
|
18
18
|
|
19
19
|
"WHERE ID = N'" + id + "'";
|
20
20
|
|
21
|
+
if(minAge != null && maxAge != null)
|
22
|
+
|
23
|
+
{
|
24
|
+
|
21
|
-
"AND 年齢 = N'BETWEEN" + minAge + "AND" + maxAge + "'";
|
25
|
+
cmd.CommandText += "AND 年齢 = N'BETWEEN" + minAge + "AND" + maxAge + "'";
|
26
|
+
|
27
|
+
}
|
22
28
|
|
23
29
|
```
|
24
30
|
|
@@ -34,13 +40,19 @@
|
|
34
40
|
|
35
41
|
```sql
|
36
42
|
|
37
|
-
"INSERT INTO [dbo].[Table2] ([ID], [年齢])" +
|
43
|
+
cmd.CommandText = "INSERT INTO [dbo].[Table2] ([ID], [年齢])" +
|
38
44
|
|
39
45
|
"SELECT [ID], [年齢] FROM [dbo].[Table]" +
|
40
46
|
|
41
47
|
"WHERE ID = N'" + id + "'";
|
42
48
|
|
49
|
+
if(minAge != null && maxAge != null)
|
50
|
+
|
51
|
+
{
|
52
|
+
|
43
|
-
"AND 年齢 = N'BETWEEN" + minAge + "'AND'" + maxAge + "'";
|
53
|
+
cmd.CommandText += "AND 年齢 = N'BETWEEN" + minAge + "'AND'" + maxAge + "'";
|
54
|
+
|
55
|
+
}
|
44
56
|
|
45
57
|
```
|
46
58
|
|