CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: bad post

  1. #1
    2kaud's Avatar
    2kaud is offline Super Moderator Power Poster
    Join Date
    Dec 2012
    Location
    England
    Posts
    7,822

    bad post

    Hi, I'm trying to find out how to update or refresh a DataGridView I've got on a Windows Form after I change the linked database. I've found a lot of info on the net, but none of the solutions I've found have done the job. Here's the sub I've been using, but haven't been able to refresh the data in my GridView:

    [CODE]
    Public Sub GetPlans()
    Dim cmd As New OleDbCommand

    chkCnt = 0

    Try
    LstBxPlanBackup.Items.Clear()
    str = "SELECT COUNT(*) FROM Backup"
    cmd.CommandText = str
    cmd.Connection = myConn
    myConn.Open()
    cntPlns = Convert.ToInt32(cmd.ExecuteScalar())
    myConn.Close()

    str = "SELECT Nickname, Base, Target, Pause FROM Backup"
    cmd.CommandText =
    All advice is offered in good faith only. All my code is tested (unless stated explicitly otherwise) with the latest version of Microsoft Visual Studio (using the supported features of the latest standard) and is offered as examples only - not as production quality. I cannot offer advice regarding any other c/c++ compiler/IDE or incompatibilities with VS. You are ultimately responsible for the effects of your programs and the integrity of the machines they run on. Anything I post, code snippets, advice, etc is licensed as Public Domain https://creativecommons.org/publicdomain/zero/1.0/ and can be used without reference or acknowledgement. Also note that I only provide advice and guidance via the forums - and not via private messages!

    C++23 Compiler: Microsoft VS2022 (17.6.5)

  2. #2
    2kaud's Avatar
    2kaud is offline Super Moderator Power Poster
    Join Date
    Dec 2012
    Location
    England
    Posts
    7,822

    Re: bad post

    Posts OK without the provider etc 2nd code line.
    All advice is offered in good faith only. All my code is tested (unless stated explicitly otherwise) with the latest version of Microsoft Visual Studio (using the supported features of the latest standard) and is offered as examples only - not as production quality. I cannot offer advice regarding any other c/c++ compiler/IDE or incompatibilities with VS. You are ultimately responsible for the effects of your programs and the integrity of the machines they run on. Anything I post, code snippets, advice, etc is licensed as Public Domain https://creativecommons.org/publicdomain/zero/1.0/ and can be used without reference or acknowledgement. Also note that I only provide advice and guidance via the forums - and not via private messages!

    C++23 Compiler: Microsoft VS2022 (17.6.5)

  3. #3
    Join Date
    Jan 2013
    Location
    Largo, FL.
    Posts
    356

    Re: bad post

    Cool...Thanks... I'll tell the member.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured