demausdauth's Profile User Rating: -----

Reputation: 162 Stalwart
Group:
Expert
Active Posts:
565 (0.47 per day)
Joined:
03-February 10
Profile Views:
10,057
Last Active:
User is offline Mar 28 2013 10:41 AM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Windows
Favorite Browser:
FireFox
Favorite Processor:
Intel
Favorite Gaming Platform:
PC
Your Car:
Saturn
Dream Kudos:
50
Icon   demausdauth Getting frustrated with paydays -- nothing left :(

Posts I've Made

  1. In Topic: Array structure and text boxes

    Posted 30 Jan 2013

    Pseudo code it out.
    User Input
    1. Check for null or empty entry
       A. Is valid input?
          a. yes then continue
          b. no
             i. Display error message
             ii. do not continue processing
    2. Process Input
    
    Process Input
    1. Determine Abbr vs Full Name (Length?)
       A. Abbr = true
          a. Loop through array of countries (For .. Next?)
          b. Does it match?
             i. yes then matchfound = true
             ii. no then continue loop
       B. Full name = true
          a. Loop through array of countries
          b. Does it match?
             i. yes then matchfound = true
             ii. no then continue loop
    2. Is matchfound = true?
       A. Yes
          a. Display abbr or fullname or both
       B. No
          a. Display error message
    
    


    Once you understand the steps (pseudo code) then you can start applying code.
    Pseudo code will also help you to identify parts that can be factored out to separate methods or functions.
  2. In Topic: this is simple in string manipulation but how in SQL?

    Posted 9 Jun 2012

    To split the string

    
    Dim splitString() As String = naam.Split()
    'This gives you an array of values
    'splitString(0) = "william"
    'splitString(1) = "lemeer"
    
    


    Using the above code to perform the split you then build your SQL statement. (and since you don't include which provider we'll assume SQL)

         Dim splitString() As String = naam.Split()
         'This gives you an array of values
         'splitString(0) = "william"
         'splitString(1) = "lemeer"
    
         'Make the SQL query string
         Dim queryString = "SELECT personeelnr FROM personeel WHERE personeel.naam =@firstName AND personeel.achternaam = @lastName"
    
         'create our database connection and the command object that we will use
         Using connection As New SqlConnection(connectionString)
              Using command As New SqlCommand(queryString, connection)
    
                   'check if the connection is open, if not then open it
                   If Not connection.State = ConnectionState.Open Then
                        connection.Open()
                   End If
    
                   'Add parameters
                   command.Parameters.AddWithValue("@firstName", splitString()))
                   command.Parameters.AddWithValue("@lastName", splitString(1))
    
                   'Get the reader object
                   Dim reader As SqlDataReader = command.ExecuteReader()
    
                   'Fill a table of values
                   Dim dtResults As New DataTable("Results")
                   dtResults.Load(reader)
              End Using
         End Using
    
    
    
  3. In Topic: How to remove the systray icon of another application

    Posted 18 May 2012

    And why would you want to keep the user of the computer from being able to access a legitimate program through the intended use of its systray icon?
  4. In Topic: I need help fiquring out what I did wrong

    Posted 27 Apr 2012

    Don't turn Option Strict to off, leave it on -- it will save you time in the future.
  5. In Topic: Tv shows that get cancelled just as they become really good

    Posted 20 Apr 2012

    My list:

    Space Above and Beyond - it was great ( I am also a fan of the movie Soldier)
    SG-1
    SG-Atlantis
    Firefly
    Flash Forward
    Spellbinder

My Information

Member Title:
D.I.C Addict
Age:
40 years old
Birthday:
February 2, 1973
Gender:
Location:
Minnesota
Interests:
my family, reading, programming,
Full Name:
Aaron
Years Programming:
6
Programming Languages:
VB.NET, C#.NET, ASP.NET, SharePoint 2007 development

Contact Information

E-mail:
Private
Skype:
Skype  demausdauth

Comments

Page 1 of 1
  1. Photo

    .nethelp Icon

    07 Apr 2012 - 14:31
    why did u put -1 on my reputation coz u know better? werent u like me before ? thanks anyways this truely shows ur good spirit and what a good mentor u are .
    bye
  2. Photo

    .nethelp Icon

    07 Apr 2012 - 14:31
    why did u put -1 on my reputation coz u know better? werent u like me before ? thanks anyways this truely shows ur good spirit and what a good mentor u are .
    bye
  3. Photo

    Guest 

    29 Jun 2010 - 13:54
    http://www.dreamincode.net/forums/topic/179550-updatepanels-placeholders-and-usercontrols/
  4. Photo

    joker_1 Icon

    13 Jun 2010 - 21:37
    Hi quick question.. What is the "e" argument??
    thanks heaps
  5. Photo

    demausdauth Icon

    11 Jun 2010 - 06:05
    lol -- not trying to break any records
  6. Photo

    CharlieMay Icon

    10 Jun 2010 - 18:31
    Just wanted to say, you keep answering questions like you do and your rep is going to sky-rocket.
Page 1 of 1