为什么更改选项卡后我的数据不显示?
我正在使用带有TABCONTROL的DataGrid。当我移动到第二个选项卡时,我的数据没有在DataGridView中显示。我的第二个如果语句未被执行,我不确定为什么。仅在SelectedIndex 0中执行第一个语句。请帮助我。
Private Sub TabControl1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles TabControl1.SelectedIndexChanged
If TabControl1.SelectedIndex = 0 Then
MyCn.Open()
MyDatAdp = New SqlDataAdapter("select * from Books", MyCn)
MyCmdBld = New SqlCommandBuilder(MyDatAdp)
MyDatAdp.Fill(MyDataTbl)
DataGridView1.DataSource = MyDataTbl
MyCn.Close()
If TabControl1.SelectedIndex = 1 Then
MyCn.Open()
MyDatAdp = New SqlDataAdapter("select * from Orders", MyCn)
MyCmdBld = New SqlCommandBuilder(MyDatAdp)
MyDatAdp.Fill(MyDt2)
DataGridView2.DataSource = MyDt2
MyCn.Close()
End If
End If
End Sub
I'm using a DataGrid with TabControl. When I move to the 2nd tab my data is not displaying in the datagridview. My 2nd IF statement is not getting executed, I'm not sure why either. Only the 1st statement is being execute in selectedIndex 0. Please help me out.
Private Sub TabControl1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles TabControl1.SelectedIndexChanged
If TabControl1.SelectedIndex = 0 Then
MyCn.Open()
MyDatAdp = New SqlDataAdapter("select * from Books", MyCn)
MyCmdBld = New SqlCommandBuilder(MyDatAdp)
MyDatAdp.Fill(MyDataTbl)
DataGridView1.DataSource = MyDataTbl
MyCn.Close()
If TabControl1.SelectedIndex = 1 Then
MyCn.Open()
MyDatAdp = New SqlDataAdapter("select * from Orders", MyCn)
MyCmdBld = New SqlCommandBuilder(MyDatAdp)
MyDatAdp.Fill(MyDt2)
DataGridView2.DataSource = MyDt2
MyCn.Close()
End If
End If
End Sub
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
尝试更改
如果TabControl1.SelectedIndex
为如果TabControl1.SelectedTab是您的YourTabPage,则
,然后查看此链接供您参考。
Try to change the
If TabControl1.SelectedIndex
ToIf TabControl1.SelectedTab is yourTabPage Then
And see this Link for your reference.