質問編集履歴
2
列名を英語に変更
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -30,7 +30,7 @@
|
|
|
30
30
|
'データベース接続
|
|
31
31
|
St = "Server=""PC-PA1709C0127R\SQLEXPRESS01"";"
|
|
32
32
|
St &= "integrated security=SSPI;"
|
|
33
|
-
St &= "initial catalog =
|
|
33
|
+
St &= "initial catalog = theme"
|
|
34
34
|
|
|
35
35
|
cn.ConnectionString = St
|
|
36
36
|
cn.Open()
|
|
@@ -67,19 +67,19 @@
|
|
|
67
67
|
SQL = ""
|
|
68
68
|
SQL &= "INSERT INTO dbo.テーマ情報"
|
|
69
69
|
SQL &= "("
|
|
70
|
-
SQL &= "
|
|
70
|
+
SQL &= " themeNo,"
|
|
71
|
+
SQL &= " themeName,"
|
|
72
|
+
SQL &= " Charge,"
|
|
73
|
+
SQL &= " address,"
|
|
71
|
-
SQL &= "
|
|
74
|
+
SQL &= " boss1,"
|
|
75
|
+
SQL &= " address1,"
|
|
76
|
+
SQL &= " boss2,"
|
|
77
|
+
SQL &= " address2,"
|
|
78
|
+
SQL &= " folder,"
|
|
79
|
+
SQL &= " Examination documents,"
|
|
80
|
+
SQL &= " start,"
|
|
72
|
-
SQL &= "
|
|
81
|
+
SQL &= " end,"
|
|
73
|
-
SQL &= " メールアドレス,"
|
|
74
|
-
SQL &= " 上司1,"
|
|
75
|
-
SQL &= " メールアドレス1,"
|
|
76
|
-
SQL &= " 上司2,"
|
|
77
|
-
SQL &= " メールアドレス2,"
|
|
78
|
-
SQL &= "
|
|
82
|
+
SQL &= " Review"
|
|
79
|
-
SQL &= " 引き合い審議書,"
|
|
80
|
-
SQL &= " 開始日,"
|
|
81
|
-
SQL &= " 完了日,"
|
|
82
|
-
SQL &= " 提出レビュー予定"
|
|
83
83
|
SQL &= ")"
|
|
84
84
|
SQL &= "VALUES"
|
|
85
85
|
SQL &= "("
|
1
末尾にイメージ追加、コードを’’’で囲った、QSL serverはExpress Editionです
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -18,6 +18,7 @@
|
|
|
18
18
|
|
|
19
19
|
VB.Net
|
|
20
20
|
|
|
21
|
+
```
|
|
21
22
|
Private Sub Go_Button_Click(sender As Object, e As RoutedEventArgs) Handles Go_Button.Click
|
|
22
23
|
Dim cn As New SqlConnection
|
|
23
24
|
Dim cd As New SqlCommand
|
|
@@ -122,7 +123,9 @@
|
|
|
122
123
|
cn.Dispose()
|
|
123
124
|
|
|
124
125
|
End Sub
|
|
126
|
+
```
|
|
125
127
|
|
|
128
|
+
|
|
126
129
|
### 試したこと
|
|
127
130
|
初期のテーブルをexlsからインポートしていて、Textのデータ型が「nvarchar(50)」になっているので上記構文ですが、データ型をMicrosoft SQL Server Management Studio 18でText型に変更して、Text Dataをそのまま使用しても同様のエラーが発生します。
|
|
128
131
|
|
|
@@ -130,4 +133,6 @@
|
|
|
130
133
|
### 補足情報（FW/ツールのバージョンなど）
|
|
131
134
|
|
|
132
135
|
Visual Studio 2019
|
|
133
|
-
.Net Framework 4.8
|
|
136
|
+
.Net Framework 4.8
|
|
137
|
+
|
|
138
|
+
|