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. Why do I bother?

Why do I bother?

Scheduled Pinned Locked Moved The Weird and The Wonderful
questiondatabasecomdesignhelp
27 Posts 16 Posters 2 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.
  • OriginalGriffO OriginalGriff

    A question this morning, and as part of explaining what was causing the problem he had noticed, I suggested that this code:

    string checkuser = " select count(*) from UserDetail where UserName='" + TextBoxUN + "'";

    Wasn't going to work, because it would be the same as writing:

    string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";

    And he should use TextBoxUN.Text instead, but that it was dangerous because of SQL Injection. Unrelated to the problem he had noticed, but going to be a problem soon. So...fast forward a couple of hours, and the same user has a new problem: his code doesn't find his username:

    string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";
    SqlCommand com = new SqlCommand(checkuser, conn);

    *BANG*desk*BANG*desk*BANG*

    Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

    D Offline
    D Offline
    Dave Kreskowiak
    wrote on last edited by
    #10

    OriginalGriff wrote:

    *BANG*desk*BANG*desk*BANG*

    Is that your head your banging on the desk or his?

    A guide to posting questions on CodeProject

    Click this: Asking questions is a skill. Seriously, do it.
    Dave Kreskowiak

    OriginalGriffO 1 Reply Last reply
    0
    • M Marco Bertschi

      I'm with the army, and do not bother with anything. Technically speaking it's the air force I'm with, but I still don't bother. After two weeks I now think about starting a Zen Buddhism class, that's how much I bother.

      The console is a black place

      F Offline
      F Offline
      Forogar
      wrote on last edited by
      #11

      Quote:

      I now think about starting a Zen Buddhism class,

      You would, but you can't be bothered?

      - I would love to change the world, but they won’t give me the source code.

      M L 2 Replies Last reply
      0
      • OriginalGriffO OriginalGriff

        A question this morning, and as part of explaining what was causing the problem he had noticed, I suggested that this code:

        string checkuser = " select count(*) from UserDetail where UserName='" + TextBoxUN + "'";

        Wasn't going to work, because it would be the same as writing:

        string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";

        And he should use TextBoxUN.Text instead, but that it was dangerous because of SQL Injection. Unrelated to the problem he had noticed, but going to be a problem soon. So...fast forward a couple of hours, and the same user has a new problem: his code doesn't find his username:

        string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";
        SqlCommand com = new SqlCommand(checkuser, conn);

        *BANG*desk*BANG*desk*BANG*

        Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

        D Offline
        D Offline
        Dave Kreskowiak
        wrote on last edited by
        #12

        Why is it that is seems like whenever someone asks a question in a forum their brains fall out of their head when they start reading the answers? It used to be that users brains evaporated when they sat down in front of a keyboard and mouse. Now that's moved on to people "writing" code!?

        A guide to posting questions on CodeProject

        Click this: Asking questions is a skill. Seriously, do it.
        Dave Kreskowiak

        1 Reply Last reply
        0
        • D Dave Kreskowiak

          OriginalGriff wrote:

          *BANG*desk*BANG*desk*BANG*

          Is that your head your banging on the desk or his?

          A guide to posting questions on CodeProject

          Click this: Asking questions is a skill. Seriously, do it.
          Dave Kreskowiak

          OriginalGriffO Offline
          OriginalGriffO Offline
          OriginalGriff
          wrote on last edited by
          #13

          Oh, it's mine. I don't know where he lives... :sigh:

          Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

          "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
          "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

          1 Reply Last reply
          0
          • OriginalGriffO OriginalGriff

            A question this morning, and as part of explaining what was causing the problem he had noticed, I suggested that this code:

            string checkuser = " select count(*) from UserDetail where UserName='" + TextBoxUN + "'";

            Wasn't going to work, because it would be the same as writing:

            string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";

            And he should use TextBoxUN.Text instead, but that it was dangerous because of SQL Injection. Unrelated to the problem he had noticed, but going to be a problem soon. So...fast forward a couple of hours, and the same user has a new problem: his code doesn't find his username:

            string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";
            SqlCommand com = new SqlCommand(checkuser, conn);

            *BANG*desk*BANG*desk*BANG*

            Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

            N Offline
            N Offline
            Nagy Vilmos
            wrote on last edited by
            #14

            See? I told you to have a drink.

            1 Reply Last reply
            0
            • F Forogar

              Quote:

              I now think about starting a Zen Buddhism class,

              You would, but you can't be bothered?

              - I would love to change the world, but they won’t give me the source code.

              M Offline
              M Offline
              Marco Bertschi
              wrote on last edited by
              #15

              Answer[^]

              The console is a black place

              1 Reply Last reply
              0
              • OriginalGriffO OriginalGriff

                A question this morning, and as part of explaining what was causing the problem he had noticed, I suggested that this code:

                string checkuser = " select count(*) from UserDetail where UserName='" + TextBoxUN + "'";

                Wasn't going to work, because it would be the same as writing:

                string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";

                And he should use TextBoxUN.Text instead, but that it was dangerous because of SQL Injection. Unrelated to the problem he had noticed, but going to be a problem soon. So...fast forward a couple of hours, and the same user has a new problem: his code doesn't find his username:

                string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";
                SqlCommand com = new SqlCommand(checkuser, conn);

                *BANG*desk*BANG*desk*BANG*

                Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

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

                What's wrong with that? He proved clearly that he understood the words you said to him, and he could reliably reproduce your words, character by character, not even a iota did he get wrong. :-\

                1 Reply Last reply
                0
                • F Forogar

                  Quote:

                  I now think about starting a Zen Buddhism class,

                  You would, but you can't be bothered?

                  - I would love to change the world, but they won’t give me the source code.

                  L Offline
                  L Offline
                  LPartan1
                  wrote on last edited by
                  #17

                  I am simply liking the tag line: "I would love to change the world but they won't release the source code."

                  1 Reply Last reply
                  0
                  • M Marco Bertschi

                    http://www.lw.admin.ch/internet/luftwaffe/en/home.html[^] The airforce is probably the most useful part of the swiss military, and reasonably good equipped. They maintain their own fiberglass high speed network across switzerland, and even the radar stations on the top of the mountains are connected to it.

                    The console is a black place

                    N Offline
                    N Offline
                    Nicholas Marty
                    wrote on last edited by
                    #18

                    Marco Bertschi wrote:

                    They maintain their own fiberglass high speed network across switzerland, and even the radar stations on the top of the mountains are connected to it.

                    Yeah. With breathtaking 8 Mbit/s transfer rate :rolleyes: I know that. Because well, thats what I did/do during my army time. Setting up radio stations to connect to that network. Well, it's enough for telephones and fax devices :laugh:

                    M 1 Reply Last reply
                    0
                    • OriginalGriffO OriginalGriff

                      A question this morning, and as part of explaining what was causing the problem he had noticed, I suggested that this code:

                      string checkuser = " select count(*) from UserDetail where UserName='" + TextBoxUN + "'";

                      Wasn't going to work, because it would be the same as writing:

                      string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";

                      And he should use TextBoxUN.Text instead, but that it was dangerous because of SQL Injection. Unrelated to the problem he had noticed, but going to be a problem soon. So...fast forward a couple of hours, and the same user has a new problem: his code doesn't find his username:

                      string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";
                      SqlCommand com = new SqlCommand(checkuser, conn);

                      *BANG*desk*BANG*desk*BANG*

                      Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

                      F Offline
                      F Offline
                      Fabio Franco
                      wrote on last edited by
                      #19

                      OriginalGriff wrote:

                      Wasn't going to work, because it would be the same as writing:

                      string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";

                      Just give him codezzz

                      To alcohol! The cause of, and solution to, all of life's problems - Homer Simpson ---- Our heads are round so our thoughts can change direction - Francis Picabia

                      1 Reply Last reply
                      0
                      • OriginalGriffO OriginalGriff

                        I'd love to see an origami Death Star fly! :laugh:

                        Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

                        R Offline
                        R Offline
                        Rob Grainger
                        wrote on last edited by
                        #20

                        Origami Death Star Instructions: 1. Take square of paper (from newspaper should work well). 2. Screw it up into a ball. 3. Press thumb into one side to create recess. 4. er.. that's it.

                        "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

                        OriginalGriffO 1 Reply Last reply
                        0
                        • R Rob Grainger

                          Origami Death Star Instructions: 1. Take square of paper (from newspaper should work well). 2. Screw it up into a ball. 3. Press thumb into one side to create recess. 4. er.. that's it.

                          "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

                          OriginalGriffO Offline
                          OriginalGriffO Offline
                          OriginalGriff
                          wrote on last edited by
                          #21

                          I wanna trench! I wanna exhaust port! I want tiny Tie Fighters smashing into the walls! :laugh:

                          Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

                          "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                          "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                          1 Reply Last reply
                          0
                          • OriginalGriffO OriginalGriff

                            A question this morning, and as part of explaining what was causing the problem he had noticed, I suggested that this code:

                            string checkuser = " select count(*) from UserDetail where UserName='" + TextBoxUN + "'";

                            Wasn't going to work, because it would be the same as writing:

                            string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";

                            And he should use TextBoxUN.Text instead, but that it was dangerous because of SQL Injection. Unrelated to the problem he had noticed, but going to be a problem soon. So...fast forward a couple of hours, and the same user has a new problem: his code doesn't find his username:

                            string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";
                            SqlCommand com = new SqlCommand(checkuser, conn);

                            *BANG*desk*BANG*desk*BANG*

                            Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

                            Z Offline
                            Z Offline
                            ZurdoDev
                            wrote on last edited by
                            #22

                            OriginalGriff wrote:

                            UserName='System.Web.UI.WebControls.TextBox'

                            I wonder what kind of password would go with a username like that? :^)

                            There are only 10 types of people in the world, those who understand binary and those who don't.

                            OriginalGriffO 1 Reply Last reply
                            0
                            • Z ZurdoDev

                              OriginalGriff wrote:

                              UserName='System.Web.UI.WebControls.TextBox'

                              I wonder what kind of password would go with a username like that? :^)

                              There are only 10 types of people in the world, those who understand binary and those who don't.

                              OriginalGriffO Offline
                              OriginalGriffO Offline
                              OriginalGriff
                              wrote on last edited by
                              #23

                              RyanDev wrote:

                              what kind of password would go with a username like that?

                              My first try would be:

                              X';DROP TABLE UserDetail;--

                              :laugh:

                              Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

                              "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                              "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                              1 Reply Last reply
                              0
                              • OriginalGriffO OriginalGriff

                                A question this morning, and as part of explaining what was causing the problem he had noticed, I suggested that this code:

                                string checkuser = " select count(*) from UserDetail where UserName='" + TextBoxUN + "'";

                                Wasn't going to work, because it would be the same as writing:

                                string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";

                                And he should use TextBoxUN.Text instead, but that it was dangerous because of SQL Injection. Unrelated to the problem he had noticed, but going to be a problem soon. So...fast forward a couple of hours, and the same user has a new problem: his code doesn't find his username:

                                string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";
                                SqlCommand com = new SqlCommand(checkuser, conn);

                                *BANG*desk*BANG*desk*BANG*

                                Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

                                K Offline
                                K Offline
                                Karen Mitchelle
                                wrote on last edited by
                                #24

                                Please, start to think about what you are doing? Please?

                                :thumbsup: :laugh: I think, the member either didn't bother to comprehend your answer and just proceed to copy-paste the texts in your <pre> tags or he didn't comprehend it clearly. Either way, the 'begging' part actually makes me laugh. :laugh:

                                Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64

                                1 Reply Last reply
                                0
                                • N Nicholas Marty

                                  Marco Bertschi wrote:

                                  They maintain their own fiberglass high speed network across switzerland, and even the radar stations on the top of the mountains are connected to it.

                                  Yeah. With breathtaking 8 Mbit/s transfer rate :rolleyes: I know that. Because well, thats what I did/do during my army time. Setting up radio stations to connect to that network. Well, it's enough for telephones and fax devices :laugh:

                                  M Offline
                                  M Offline
                                  Marco Bertschi
                                  wrote on last edited by
                                  #25

                                  Nicholas Marty wrote:

                                  With breathtaking 8 Mbit/s transfer rate :rolleyes:

                                  :laugh: It for sure has it's flaws :D You were / are a Richtstrahlpionier?

                                  The console is a black place

                                  N 1 Reply Last reply
                                  0
                                  • M Marco Bertschi

                                    Nicholas Marty wrote:

                                    With breathtaking 8 Mbit/s transfer rate :rolleyes:

                                    :laugh: It for sure has it's flaws :D You were / are a Richtstrahlpionier?

                                    The console is a black place

                                    N Offline
                                    N Offline
                                    Nicholas Marty
                                    wrote on last edited by
                                    #26

                                    Yeah. For the air defense :)

                                    1 Reply Last reply
                                    0
                                    • OriginalGriffO OriginalGriff

                                      A question this morning, and as part of explaining what was causing the problem he had noticed, I suggested that this code:

                                      string checkuser = " select count(*) from UserDetail where UserName='" + TextBoxUN + "'";

                                      Wasn't going to work, because it would be the same as writing:

                                      string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";

                                      And he should use TextBoxUN.Text instead, but that it was dangerous because of SQL Injection. Unrelated to the problem he had noticed, but going to be a problem soon. So...fast forward a couple of hours, and the same user has a new problem: his code doesn't find his username:

                                      string checkuser = " select count(*) from UserDetail where UserName='System.Web.UI.WebControls.TextBox'";
                                      SqlCommand com = new SqlCommand(checkuser, conn);

                                      *BANG*desk*BANG*desk*BANG*

                                      Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

                                      N Offline
                                      N Offline
                                      NormDroid
                                      wrote on last edited by
                                      #27

                                      Surely it should be: string checkuser = " select count(*) from UserDetail where UserName=@UserName"; SqlCommand com = new SqlCommand(checkuser, conn); com.Parameters.AddWithValue("@UserName", TextBoxUN.Text);

                                      Web | News | LinkedIn

                                      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