Click here to Skip to main content
15,504,286 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionDataGridView Multi Layer Header Pin
EngrImad11-Jun-22 4:33
EngrImad11-Jun-22 4:33 
SuggestionRe: DataGridView Multi Layer Header Pin
Richard MacCutchan11-Jun-22 5:16
mveRichard MacCutchan11-Jun-22 5:16 
GeneralRe: DataGridView Multi Layer Header Pin
EngrImad11-Jun-22 8:58
EngrImad11-Jun-22 8:58 
GeneralRe: DataGridView Multi Layer Header Pin
Richard MacCutchan11-Jun-22 9:49
mveRichard MacCutchan11-Jun-22 9:49 
GeneralRe: DataGridView Multi Layer Header Pin
EngrImad18-Jun-22 9:31
EngrImad18-Jun-22 9:31 
Questionhelp edit config file Pin
Benjamindh8-Jun-22 12:14
Benjamindh8-Jun-22 12:14 
AnswerRe: help edit config file Pin
Dave Kreskowiak8-Jun-22 15:55
mveDave Kreskowiak8-Jun-22 15:55 
QuestionPooling data from database into Listview with timer Pin
SHAHROL AZMI BIN AMZAT25-May-22 23:53
SHAHROL AZMI BIN AMZAT25-May-22 23:53 
Hi sir,

i'm already try to pool data into listview and it worked. But i need to pool the data using timer can anyone guide me ?

VB
<pre> Try
            

        
           
            Dim cmd As New FbCommand("SELECT A.EVENTDATE AS EVENTDATE ,A.PRIORITY AS PRIORITY ,B.CARDHOLDERID AS CARDHOLDERID," & _
                                              "B.EMAIL AS EMAIL,B.NAME AS NAME,C.WINSOCKIPADDRESS AS WINSOCKIPADDRESS,A.DEVICEID AS DEVICEID, " & _
                                               "D.DESCRIPTION AS DESCRIPTION " & _
                                              " FROM EVENT A , CARDHOLDER B , COMMCHANNEL C, DEVICE D " & _
                                           "WHERE (A.CARDHOLDERID = B.CARDHOLDERID)" & _
                                            " AND (A.COMMCHANNELID = C.COMMCHANNELID) " & _
                                            " AND (A.DEVICEID = D.DEVICEID) " & _
                                          "AND A.CARDHOLDERID IS NOT NULL " & _
                                         "AND B.USERDEFINED9 = 'STAFF' AND B.STATUS='Normal'" & _
                                       " AND A.PRIORITY IS NULL " & _
                                           "AND A.EVENTDATE >= CAST('TODAY' AS DATE) AND A.EVENTMSG = 'Access Granted' " & _
                                              "ORDER BY A.EVENTDATE ASC", IBSSCN)
          
            IBSSDR = cmd.ExecuteReader()

            ListView1.Items.Clear()

            Dim bFlag As Boolean = True
            Do Until Not bFlag
                While IBSSDR.Read

                   

                    Dim touch As DateTime = Convert.ToDateTime(IBSSDR.Item("EVENTDATE"))
                    Dim date1 As String = touch.Date.ToString("dd/MM/yyyy")
                    Dim time1 As String = Format(touch, ("hh:mm:ss tt"))



                    Dim str(5) As String
                    Dim itm As ListViewItem
                    str(0) = IBSSDR.Item("CARDHOLDERID")
                    str(1) = IBSSDR.Item("NAME")
                    str(2) = date1
                    str(3) = time1
                    ' str(4) = IBSSDR.Item("EMAIL")

                    If IBSSDR.Item("EMAIL") Is DBNull.Value Then
                        str(4) = ""
                    Else
                        str(4) = IBSSDR.Item("EMAIL")
                    End If
                  
                    itm = New ListViewItem(str)
                    ListView1.Items.Add(itm)

                End While
                bFlag = IBSSDR.NextResult

            Loop

            IBSSCN.ClearAllPools()
         




            

        Catch ex As Exception
            MsgBox(ex.Message)
        End Try




I already add the timer :
<pre lang="VB">
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
        Timer1.Enabled = True
        Timer1.Interval = 6000
        ListView1.Update()
        ListView1.Refresh()

end sub


Can anybody help me, plz , tq
AnswerRe: Pooling data from database into Listview with timer Pin
Dave Kreskowiak26-May-22 6:34
mveDave Kreskowiak26-May-22 6:34 
GeneralRe: Pooling data from database into Listview with timer Pin
SHAHROL AZMI BIN AMZAT26-May-22 15:25
SHAHROL AZMI BIN AMZAT26-May-22 15:25 
GeneralRe: Pooling data from database into Listview with timer Pin
Dave Kreskowiak27-May-22 6:37
mveDave Kreskowiak27-May-22 6:37 
GeneralRe: Pooling data from database into Listview with timer Pin
SHAHROL AZMI BIN AMZAT29-May-22 16:53
SHAHROL AZMI BIN AMZAT29-May-22 16:53 
QuestionWinforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Jo_vb.net18-May-22 9:11
Jo_vb.net18-May-22 9:11 
AnswerRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Gerry Schmitz18-May-22 18:49
mveGerry Schmitz18-May-22 18:49 
GeneralRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Jo_vb.net18-May-22 21:53
Jo_vb.net18-May-22 21:53 
GeneralRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Gerry Schmitz19-May-22 7:39
mveGerry Schmitz19-May-22 7:39 
GeneralRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Jo_vb.net22-May-22 8:32
Jo_vb.net22-May-22 8:32 
GeneralRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Gerry Schmitz23-May-22 12:44
mveGerry Schmitz23-May-22 12:44 
QuestionRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Eddy Vluggen20-May-22 5:15
professionalEddy Vluggen20-May-22 5:15 
AnswerRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Jo_vb.net20-May-22 6:07
Jo_vb.net20-May-22 6:07 
GeneralRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Gerry Schmitz20-May-22 6:30
mveGerry Schmitz20-May-22 6:30 
QuestionRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Eddy Vluggen20-May-22 7:08
professionalEddy Vluggen20-May-22 7:08 
AnswerRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Gerry Schmitz21-May-22 6:36
mveGerry Schmitz21-May-22 6:36 
GeneralRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Jo_vb.net20-May-22 7:21
Jo_vb.net20-May-22 7:21 
GeneralRe: Winforms VB.Net: Best way to code rules for german cards game "Schafkopf"? Pin
Jo_vb.net29-May-22 1:42
Jo_vb.net29-May-22 1:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.