Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Other Discussions
  3. The Weird and The Wonderful
  4. Ah, VB ...

Ah, VB ...

Scheduled Pinned Locked Moved The Weird and The Wonderful
csharpjavajavascriptphpdatabase
8 Posts 8 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • F Offline
    F Offline
    Firo Atrum Ventus
    wrote on last edited by
    #1

    I'm having bad day today as I stumbled across some VB code that's worse than usual coding horror. So I decided to relieve my mind by sharing those gems here.

    If _Inspeksi = Inspeksi.JTM Then
    Else
    SQL = "SELECT ID_GI FROM AGARDU_INDUK WHERE NO_GARDU='" & DDGI2.ID & "'"
    DT = New DataTable
    DT = GlobalClassV2.Globals.Instance.ExecuteQuery(SQL)
    SQL = ""
    If DT.Rows.Count = 0 Then
    Exit Function
    End If
    GINDUKR = DT.Rows(0)!ID_GI
    SQL = "SELECT ID_GD FROM AGARDU_DISTRIBUSI WHERE NO_GARDU='" & GINDUK & "'"
    DT = New DataTable
    DT = GlobalClassV2.Globals.Instance.ExecuteQuery(SQL)
    SQL = ""
    If DT.Rows.Count = 0 Then
    Exit Function
    End If
    GINDUK = DT.Rows(0)!ID_GD
    End If
    If GlobalClassV2.Globals.Instance.ExecuteQuery2(XSQL) = False Then
    Throw New Exception("GAGAL")
    Exit Function
    End If
    For iData As Integer = 1 To FG2.Rows.Count - 1
    If IsDBNull(FG2.Item(iData, 0)) = True Then
    Else
    DLInsert.InsertInspeksiJTMTR2_DETIL_NEWEST(False, pIDInspeksi, "R", dtTglPeriksa.Text, _
    CG.CheckNull(FG2.Item(iData, 0)), FG2.Item(iData, 8), "", CG.CheckNullNum(FG2.Item(iData, 13)), "", Split(CG.CheckNull(FG2.Item(iData, 2)), " - ")(0), _
    Split(CG.CheckNull(FG2.Item(iData, 3)), " - ")(0), "", "", _
    Split(CG.CheckNull(FG2.Item(iData, 4)), " - ")(0), CG.CheckNull(FG2.Item(iData, 5)), Split(CG.CheckNull(FG2.Item(iData, 7)), " - ")(0), _
    CG.CheckNull(FG2.Item(iData, 11)), "", Globals.Instance.EncodeDate(DateTime.Parse(FG2.Item(iData, 12))), _
    Split(CG.CheckNull(FG2.Item(iData, 13)), " - ")(0), CG.CheckNull(FG2.Item(iData, 5)), CG.CheckNull(FG2.Item(iData, 6)), _
    CG.CheckNull(FG2.Item(iData, 1)), Split(CG.CheckNull(FG2.Item(iData, 14)), " - ")(0), Split(CG.CheckNull(FG2.Item(iData, 15)), " - ")(0), _
    CG.CheckNull(FG2.Item(iData, 17)), Split(CG.CheckNull(FG2.Item(iData, 18)), " - ")(0), FG2.Item(iData, 9), FG2.Item(iData, 10))
    End If
    Next

    Excuse me for my improper grammar and typos. It's because English is my primary language, not my first language. My first languages are C# and Java. VB, ASP, JS, PHP and SQL are my second language. Indonesian came as my third language. My fourth language? I'm still creating it, I'll let you know when it's done! :-D

    B Sander RosselS J Z 4 Replies Last reply
    0
    • F Firo Atrum Ventus

      I'm having bad day today as I stumbled across some VB code that's worse than usual coding horror. So I decided to relieve my mind by sharing those gems here.

      If _Inspeksi = Inspeksi.JTM Then
      Else
      SQL = "SELECT ID_GI FROM AGARDU_INDUK WHERE NO_GARDU='" & DDGI2.ID & "'"
      DT = New DataTable
      DT = GlobalClassV2.Globals.Instance.ExecuteQuery(SQL)
      SQL = ""
      If DT.Rows.Count = 0 Then
      Exit Function
      End If
      GINDUKR = DT.Rows(0)!ID_GI
      SQL = "SELECT ID_GD FROM AGARDU_DISTRIBUSI WHERE NO_GARDU='" & GINDUK & "'"
      DT = New DataTable
      DT = GlobalClassV2.Globals.Instance.ExecuteQuery(SQL)
      SQL = ""
      If DT.Rows.Count = 0 Then
      Exit Function
      End If
      GINDUK = DT.Rows(0)!ID_GD
      End If
      If GlobalClassV2.Globals.Instance.ExecuteQuery2(XSQL) = False Then
      Throw New Exception("GAGAL")
      Exit Function
      End If
      For iData As Integer = 1 To FG2.Rows.Count - 1
      If IsDBNull(FG2.Item(iData, 0)) = True Then
      Else
      DLInsert.InsertInspeksiJTMTR2_DETIL_NEWEST(False, pIDInspeksi, "R", dtTglPeriksa.Text, _
      CG.CheckNull(FG2.Item(iData, 0)), FG2.Item(iData, 8), "", CG.CheckNullNum(FG2.Item(iData, 13)), "", Split(CG.CheckNull(FG2.Item(iData, 2)), " - ")(0), _
      Split(CG.CheckNull(FG2.Item(iData, 3)), " - ")(0), "", "", _
      Split(CG.CheckNull(FG2.Item(iData, 4)), " - ")(0), CG.CheckNull(FG2.Item(iData, 5)), Split(CG.CheckNull(FG2.Item(iData, 7)), " - ")(0), _
      CG.CheckNull(FG2.Item(iData, 11)), "", Globals.Instance.EncodeDate(DateTime.Parse(FG2.Item(iData, 12))), _
      Split(CG.CheckNull(FG2.Item(iData, 13)), " - ")(0), CG.CheckNull(FG2.Item(iData, 5)), CG.CheckNull(FG2.Item(iData, 6)), _
      CG.CheckNull(FG2.Item(iData, 1)), Split(CG.CheckNull(FG2.Item(iData, 14)), " - ")(0), Split(CG.CheckNull(FG2.Item(iData, 15)), " - ")(0), _
      CG.CheckNull(FG2.Item(iData, 17)), Split(CG.CheckNull(FG2.Item(iData, 18)), " - ")(0), FG2.Item(iData, 9), FG2.Item(iData, 10))
      End If
      Next

      Excuse me for my improper grammar and typos. It's because English is my primary language, not my first language. My first languages are C# and Java. VB, ASP, JS, PHP and SQL are my second language. Indonesian came as my third language. My fourth language? I'm still creating it, I'll let you know when it's done! :-D

      B Offline
      B Offline
      Bernhard Hiller
      wrote on last edited by
      #2

      Very inconsistent! He'd better write:

      If GlobalClassV2.Globals.Instance.ExecuteQuery2(XSQL) = True Then
      Else
      Throw New Exception("GAGAL")
      Exit Function
      End If

      And I like that gaga exception ("gagal" means "failed", doesn't it?) before the call to Exit Function...

      L 1 Reply Last reply
      0
      • B Bernhard Hiller

        Very inconsistent! He'd better write:

        If GlobalClassV2.Globals.Instance.ExecuteQuery2(XSQL) = True Then
        Else
        Throw New Exception("GAGAL")
        Exit Function
        End If

        And I like that gaga exception ("gagal" means "failed", doesn't it?) before the call to Exit Function...

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #3

        'GAGAL' sonds more like something you could encounter in Star Wars, something with long teeth and claws :)

        And from the clouds a mighty voice spoke:
        "Smile and be happy, for it could come worse!"

        And I smiled and was happy
        And it came worse.

        A 1 Reply Last reply
        0
        • L Lost User

          'GAGAL' sonds more like something you could encounter in Star Wars, something with long teeth and claws :)

          And from the clouds a mighty voice spoke:
          "Smile and be happy, for it could come worse!"

          And I smiled and was happy
          And it came worse.

          A Offline
          A Offline
          AspDotNetDev
          wrote on last edited by
          #4

          Let Me Gagal That Fer Ya.

          Somebody in an online forum wrote:

          INTJs never really joke. They make a point. The joke is just a gift wrapper.

          S 1 Reply Last reply
          0
          • A AspDotNetDev

            Let Me Gagal That Fer Ya.

            Somebody in an online forum wrote:

            INTJs never really joke. They make a point. The joke is just a gift wrapper.

            S Offline
            S Offline
            StM0n
            wrote on last edited by
            #5

            You have to do inspeksi ahead... I like inspeksi... ;)

            (yes|no|maybe)*

            1 Reply Last reply
            0
            • F Firo Atrum Ventus

              I'm having bad day today as I stumbled across some VB code that's worse than usual coding horror. So I decided to relieve my mind by sharing those gems here.

              If _Inspeksi = Inspeksi.JTM Then
              Else
              SQL = "SELECT ID_GI FROM AGARDU_INDUK WHERE NO_GARDU='" & DDGI2.ID & "'"
              DT = New DataTable
              DT = GlobalClassV2.Globals.Instance.ExecuteQuery(SQL)
              SQL = ""
              If DT.Rows.Count = 0 Then
              Exit Function
              End If
              GINDUKR = DT.Rows(0)!ID_GI
              SQL = "SELECT ID_GD FROM AGARDU_DISTRIBUSI WHERE NO_GARDU='" & GINDUK & "'"
              DT = New DataTable
              DT = GlobalClassV2.Globals.Instance.ExecuteQuery(SQL)
              SQL = ""
              If DT.Rows.Count = 0 Then
              Exit Function
              End If
              GINDUK = DT.Rows(0)!ID_GD
              End If
              If GlobalClassV2.Globals.Instance.ExecuteQuery2(XSQL) = False Then
              Throw New Exception("GAGAL")
              Exit Function
              End If
              For iData As Integer = 1 To FG2.Rows.Count - 1
              If IsDBNull(FG2.Item(iData, 0)) = True Then
              Else
              DLInsert.InsertInspeksiJTMTR2_DETIL_NEWEST(False, pIDInspeksi, "R", dtTglPeriksa.Text, _
              CG.CheckNull(FG2.Item(iData, 0)), FG2.Item(iData, 8), "", CG.CheckNullNum(FG2.Item(iData, 13)), "", Split(CG.CheckNull(FG2.Item(iData, 2)), " - ")(0), _
              Split(CG.CheckNull(FG2.Item(iData, 3)), " - ")(0), "", "", _
              Split(CG.CheckNull(FG2.Item(iData, 4)), " - ")(0), CG.CheckNull(FG2.Item(iData, 5)), Split(CG.CheckNull(FG2.Item(iData, 7)), " - ")(0), _
              CG.CheckNull(FG2.Item(iData, 11)), "", Globals.Instance.EncodeDate(DateTime.Parse(FG2.Item(iData, 12))), _
              Split(CG.CheckNull(FG2.Item(iData, 13)), " - ")(0), CG.CheckNull(FG2.Item(iData, 5)), CG.CheckNull(FG2.Item(iData, 6)), _
              CG.CheckNull(FG2.Item(iData, 1)), Split(CG.CheckNull(FG2.Item(iData, 14)), " - ")(0), Split(CG.CheckNull(FG2.Item(iData, 15)), " - ")(0), _
              CG.CheckNull(FG2.Item(iData, 17)), Split(CG.CheckNull(FG2.Item(iData, 18)), " - ")(0), FG2.Item(iData, 9), FG2.Item(iData, 10))
              End If
              Next

              Excuse me for my improper grammar and typos. It's because English is my primary language, not my first language. My first languages are C# and Java. VB, ASP, JS, PHP and SQL are my second language. Indonesian came as my third language. My fourth language? I'm still creating it, I'll let you know when it's done! :-D

              Sander RosselS Offline
              Sander RosselS Offline
              Sander Rossel
              wrote on last edited by
              #6

              That is just horror after horror after horror... :wtf: :omg: :~ X|

              It's an OO world.

              public class Naerling : Lazy<Person>{}

              1 Reply Last reply
              0
              • F Firo Atrum Ventus

                I'm having bad day today as I stumbled across some VB code that's worse than usual coding horror. So I decided to relieve my mind by sharing those gems here.

                If _Inspeksi = Inspeksi.JTM Then
                Else
                SQL = "SELECT ID_GI FROM AGARDU_INDUK WHERE NO_GARDU='" & DDGI2.ID & "'"
                DT = New DataTable
                DT = GlobalClassV2.Globals.Instance.ExecuteQuery(SQL)
                SQL = ""
                If DT.Rows.Count = 0 Then
                Exit Function
                End If
                GINDUKR = DT.Rows(0)!ID_GI
                SQL = "SELECT ID_GD FROM AGARDU_DISTRIBUSI WHERE NO_GARDU='" & GINDUK & "'"
                DT = New DataTable
                DT = GlobalClassV2.Globals.Instance.ExecuteQuery(SQL)
                SQL = ""
                If DT.Rows.Count = 0 Then
                Exit Function
                End If
                GINDUK = DT.Rows(0)!ID_GD
                End If
                If GlobalClassV2.Globals.Instance.ExecuteQuery2(XSQL) = False Then
                Throw New Exception("GAGAL")
                Exit Function
                End If
                For iData As Integer = 1 To FG2.Rows.Count - 1
                If IsDBNull(FG2.Item(iData, 0)) = True Then
                Else
                DLInsert.InsertInspeksiJTMTR2_DETIL_NEWEST(False, pIDInspeksi, "R", dtTglPeriksa.Text, _
                CG.CheckNull(FG2.Item(iData, 0)), FG2.Item(iData, 8), "", CG.CheckNullNum(FG2.Item(iData, 13)), "", Split(CG.CheckNull(FG2.Item(iData, 2)), " - ")(0), _
                Split(CG.CheckNull(FG2.Item(iData, 3)), " - ")(0), "", "", _
                Split(CG.CheckNull(FG2.Item(iData, 4)), " - ")(0), CG.CheckNull(FG2.Item(iData, 5)), Split(CG.CheckNull(FG2.Item(iData, 7)), " - ")(0), _
                CG.CheckNull(FG2.Item(iData, 11)), "", Globals.Instance.EncodeDate(DateTime.Parse(FG2.Item(iData, 12))), _
                Split(CG.CheckNull(FG2.Item(iData, 13)), " - ")(0), CG.CheckNull(FG2.Item(iData, 5)), CG.CheckNull(FG2.Item(iData, 6)), _
                CG.CheckNull(FG2.Item(iData, 1)), Split(CG.CheckNull(FG2.Item(iData, 14)), " - ")(0), Split(CG.CheckNull(FG2.Item(iData, 15)), " - ")(0), _
                CG.CheckNull(FG2.Item(iData, 17)), Split(CG.CheckNull(FG2.Item(iData, 18)), " - ")(0), FG2.Item(iData, 9), FG2.Item(iData, 10))
                End If
                Next

                Excuse me for my improper grammar and typos. It's because English is my primary language, not my first language. My first languages are C# and Java. VB, ASP, JS, PHP and SQL are my second language. Indonesian came as my third language. My fourth language? I'm still creating it, I'll let you know when it's done! :-D

                J Offline
                J Offline
                jgrogan
                wrote on last edited by
                #7

                In fairness ... the problem is not that it's VB, it's that he's a crap programmer!

                1 Reply Last reply
                0
                • F Firo Atrum Ventus

                  I'm having bad day today as I stumbled across some VB code that's worse than usual coding horror. So I decided to relieve my mind by sharing those gems here.

                  If _Inspeksi = Inspeksi.JTM Then
                  Else
                  SQL = "SELECT ID_GI FROM AGARDU_INDUK WHERE NO_GARDU='" & DDGI2.ID & "'"
                  DT = New DataTable
                  DT = GlobalClassV2.Globals.Instance.ExecuteQuery(SQL)
                  SQL = ""
                  If DT.Rows.Count = 0 Then
                  Exit Function
                  End If
                  GINDUKR = DT.Rows(0)!ID_GI
                  SQL = "SELECT ID_GD FROM AGARDU_DISTRIBUSI WHERE NO_GARDU='" & GINDUK & "'"
                  DT = New DataTable
                  DT = GlobalClassV2.Globals.Instance.ExecuteQuery(SQL)
                  SQL = ""
                  If DT.Rows.Count = 0 Then
                  Exit Function
                  End If
                  GINDUK = DT.Rows(0)!ID_GD
                  End If
                  If GlobalClassV2.Globals.Instance.ExecuteQuery2(XSQL) = False Then
                  Throw New Exception("GAGAL")
                  Exit Function
                  End If
                  For iData As Integer = 1 To FG2.Rows.Count - 1
                  If IsDBNull(FG2.Item(iData, 0)) = True Then
                  Else
                  DLInsert.InsertInspeksiJTMTR2_DETIL_NEWEST(False, pIDInspeksi, "R", dtTglPeriksa.Text, _
                  CG.CheckNull(FG2.Item(iData, 0)), FG2.Item(iData, 8), "", CG.CheckNullNum(FG2.Item(iData, 13)), "", Split(CG.CheckNull(FG2.Item(iData, 2)), " - ")(0), _
                  Split(CG.CheckNull(FG2.Item(iData, 3)), " - ")(0), "", "", _
                  Split(CG.CheckNull(FG2.Item(iData, 4)), " - ")(0), CG.CheckNull(FG2.Item(iData, 5)), Split(CG.CheckNull(FG2.Item(iData, 7)), " - ")(0), _
                  CG.CheckNull(FG2.Item(iData, 11)), "", Globals.Instance.EncodeDate(DateTime.Parse(FG2.Item(iData, 12))), _
                  Split(CG.CheckNull(FG2.Item(iData, 13)), " - ")(0), CG.CheckNull(FG2.Item(iData, 5)), CG.CheckNull(FG2.Item(iData, 6)), _
                  CG.CheckNull(FG2.Item(iData, 1)), Split(CG.CheckNull(FG2.Item(iData, 14)), " - ")(0), Split(CG.CheckNull(FG2.Item(iData, 15)), " - ")(0), _
                  CG.CheckNull(FG2.Item(iData, 17)), Split(CG.CheckNull(FG2.Item(iData, 18)), " - ")(0), FG2.Item(iData, 9), FG2.Item(iData, 10))
                  End If
                  Next

                  Excuse me for my improper grammar and typos. It's because English is my primary language, not my first language. My first languages are C# and Java. VB, ASP, JS, PHP and SQL are my second language. Indonesian came as my third language. My fourth language? I'm still creating it, I'll let you know when it's done! :-D

                  Z Offline
                  Z Offline
                  zenstain
                  wrote on last edited by
                  #8

                  This is dailywtf worthy.

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups