title: while filling data grid view using sql reader application getting slow
body: <p>I have a windows form...i am trying to fill my data grid view using sql datareader,,<br>
  while clicking button i try to fill my data grid view..<br>
  i wrote one function for filling grid view.. </p>
  
  <pre><code>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
  </code></pre>
  
  <p>then i am calling this function in my button click event.here first am removing all records from grid view then i am filling..while coming more records to data grid view my system is getting hang..is there any way to do this very simple manner..any help is very appreciable..</p>