使用数据读取器应用程序填充数据网格视图时获取挂起 [英] while filling data grid view using data reader application get hang

问题描述

我正在使用Windows窗体应用程序

i有一个表单和数据网格视图..我正在按下按钮点击这个数据gridview

按钮点击我打电话我的函数..我的函数是这样的：

I am working on windows form application
i have a form and data grid view..i am filling this data gridview in button click
in button click i am calling my function..my function like this:

Sub filldgv()
DGVReleased.Rows.Clear()
Dim carid As String
            Dim VehicleNo As String
            Dim DriverID As String
            Dim krrt As Integer
            Dim Dt As Integer
 Dim cmd As New SqlCommand("IBS_fetchresleaseVehicle", con.connect)
            cmd.CommandType = CommandType.StoredProcedure
            cmd.Parameters.Add("@locid", SqlDbType.Int).Value = Glocid
dr = cmd.ExecuteReader
            While dr.Read
                If dr("TBarcode") Is DBNull.Value Then
                    carid = ""
                Else
                    carid = dr("TBarcode")
                End If
                If dr("PlateNo") Is DBNull.Value Then
                    VehicleNo = ""
                Else
                    VehicleNo = dr("PlateNo")
                End If
                If dr("DelEcode") Is DBNull.Value Then
                    DriverID = ""
                Else
                    DriverID = dr("DelEcode")
                End If
                If dr("KRRT") Is DBNull.Value Then
                Else
                    krrt = dr("KRRT")
                End If
                If dr("DT") Is DBNull.Value Then
                Else
                    Dt = dr("DT")
                End If
                Dim row0 As String() = {carid, VehicleNo, DriverID, krrt, Dt}
                DGVReleased.Rows.Insert(0, row0)
            End While
            dr.Close()
            con.disconnect()
End Sub 

按钮点击事件我正在调用我的功能

in button click event i am calling my function

Public Sub BtnRefresh_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnRefresh.Click
        filldgv()
        changecolor()
End Sub 

但是当数据增加网格视图时我的应用程序正在挂起（我的意思是如果数据网格视图加载大约100秒的记录然后应用程序挂起）

所以在btnrefresh中单击我称为后台工作者..但仍然我的应用程序正在挂起

but when ever data is increasing the grid view my application is getting hanging(i mean if the data grid view loading around 100 s of record then application is hanging)
so in btnrefresh click i called background worker..but still my application is getting hanging

推荐答案

这篇关于使用数据读取器应用程序填充数据网格视图时获取挂起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！