wegame怎么修复游戏:用asp.net web matrix里的insert method怎么样连接2个表格?
来源:百度文库 编辑:神马品牌网 时间:2024/07/08 12:07:07
表student_daten里有matrik_id,name,vorname,geschlechte,geburtsdatum,e_mail
表student_zeugnis里有
matrik_id,physik,informatik,architektur
2个表的matrik_id都为primary key
我用asp.net web matrix里的insert method,只能连接一个表格,代码如下
Function MyInsertMethod() As Integer
Dim connectionString As String = "server='localhost'; trusted_connection=true; Database='student'"
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "INSERT INTO [student_zeugnis] ([matrik_id], [physik], [Architektur], [Informatik]"& _
") VALUES (@matrik_id, @physik, @architektur, @informatik)"
Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)
Dim rowsAffected As Integer = 0
sqlConnection.Open
Try
rowsAffected = sqlCommand.ExecuteNonQuery
Finally
sqlConnection.Close
End Try
Return rowsAffected
End Function
请问怎么样才能同时连接表student_daten啊?
谢谢!
表student_zeugnis里有
matrik_id,physik,informatik,architektur
2个表的matrik_id都为primary key
我用asp.net web matrix里的insert method,只能连接一个表格,代码如下
Function MyInsertMethod() As Integer
Dim connectionString As String = "server='localhost'; trusted_connection=true; Database='student'"
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "INSERT INTO [student_zeugnis] ([matrik_id], [physik], [Architektur], [Informatik]"& _
") VALUES (@matrik_id, @physik, @architektur, @informatik)"
Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)
Dim rowsAffected As Integer = 0
sqlConnection.Open
Try
rowsAffected = sqlCommand.ExecuteNonQuery
Finally
sqlConnection.Close
End Try
Return rowsAffected
End Function
请问怎么样才能同时连接表student_daten啊?
谢谢!
用联接 join