VB.NET DataGridView刷新 [英] VB.NET DataGridView Refresh

问题描述

我在表单上有2个DataGridView。在datagridview1 ID，FirstName，LastName中列，以便我创建一个列表。当我选择任何名称时，我正在传递连接到datagridview2的信息。但此过程发生1次。单击时再显示另一个ID 2. DataGrid未刷新。我该如何解决这个问题？



注意：对不起我的英语



代码：

I have 2 DataGridView on form. In datagridview1 ID ,FirstName ,LastName of the columns so that I made a list.When I chose any name that I'm relaying the information that was connected to datagridview2. but this process happens 1 times.so another ID when clicked 2. DataGrid is not refreshed. How do I fix this?

Note: Sorry my english

Code:

Sub listele()
        koopTablo.Clear()
        makbuzTablo.Clear()
        bag.Open()
        adtr = New OleDbDataAdapter("select plaka,adi,soyadi From koop", bag)
        adtr.Fill(koopTablo)
        DataGridView1.DataSource = koopTablo
        DataGridView1.Columns(0).HeaderText = "PLAKA"
        DataGridView1.Columns(1).HeaderText = "Adı"
        DataGridView1.Columns(2).HeaderText = "Soyadı"
        DataGridView1.Refresh()

        bag.Close()
        adtr.Dispose()
    End Sub



    Sub sec()

        Try

            If DataGridView1.CurrentRow.Cells(0).Value.ToString().Trim() <> "" Then
                
                bag.Open()
                kmt.Connection = bag
                adtr = New OleDbDataAdapter("SELECT Makbuzno,Donem,Tarih,Miktar from Makbuz WHERE PLAKA='" & DataGridView1.CurrentRow.Cells(0).Value.ToString() & "'", bag)
                adtr.Fill(makbuzTablo)
                DataGridView2.DataSource = makbuzTablo
                DataGridView2.Refresh()
                kmt.ExecuteNonQuery() 
                listele()

                bag.Close()
                kmt.Dispose()
            End If
        Catch

        End Try
    End Sub

Private Sub Form5_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load

        listele()
        sec()
    End Sub

推荐答案

你应该把sec（）例程放到datagridview1.selectionChanged（） event，以便在datagridview1中的选择发生更改时更新datagridview2数据。

you should put sec() routine to datagridview1.selectionChanged() event, so that datagridview2 data is updated when selection in datagridview1 changes.

这篇关于VB.NET DataGridView刷新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！