同济大学数据库实验五
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
一、实验目的
1.熟悉.NET平台窗口和控件的基本编程方法
2.掌握与SQL Service数据库的连接方法二、实验内容
(实验题目+运行界面截图+实现代码)
1、连接后显示的数据库university中student表的信息
2、各表之间的转换
1)form1 代码(注:红色为输入的代码)
Public Class Form1
Private Sub StudentBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StudentBindingNavigatorSaveItem.Click
Me.Validate()
Me.StudentBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.UniversityDataSet) End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: 这行代码将数据加载到表“UniversityDataSet.student”中。您可以根据需要移动或移除它。
Me.StudentTableAdapter.Fill(Me.UniversityDataSet.student) End Sub
Private Sub Form2ToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Form2ToolStripMenuItem.Click
Me.Hide()
Form2.Show()
End Sub
Private Sub Form3ToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Form3ToolStripMenuItem.Click
Me.Hide()
Form3.Show()
End Sub
End Class
2)form2 代码
Public Class Form2
Private Sub Form1ToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Form1ToolStripMenuItem.Click
Me.Hide()
Form1.Show()
End Sub
Private Sub Form3ToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Form3ToolStripMenuItem.Click
Me.Hide()
Form3.Show()
End Sub
End Class
3)form3代码
Public Class Form3
Private Sub Form1ToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
Form1ToolStripMenuItem.Click
Me.Hide()
Form1.Show()
End Sub
Private Sub Form2ToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
Form2ToolStripMenuItem.Click
Me.Hide()
Form2.Show()
End Sub
End Class