凶恶残忍的意思:用asp.net web matrix里的insert method怎么样连接2个表格?

来源:百度文库 编辑:高考问答 时间:2024/04/29 03:47:35
表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啊?

谢谢!

用联接 join