Tryparse's Profile User Rating: *****

Reputation: 80 Whiz
Group:
Contributors
Active Posts:
192 (0.17 per day)
Joined:
20-April 10
Profile Views:
2,802
Last Active:
User is offline Mar 21 2013 09:28 AM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Windows
Favorite Browser:
FireFox
Favorite Processor:
Who Cares
Favorite Gaming Platform:
PC
Your Car:
Pontiac
Dream Kudos:
25

Latest Visitors

Icon   Tryparse has not set their status

Posts I've Made

  1. In Topic: Looking For Developer's Magazines

    Posted 29 Dec 2011

    Visual Studio Magazine is a good one if you're into .NET.
  2. In Topic: Accumulating and concatenating string variables

    Posted 16 Dec 2011

    To be precise, what you're doing wrong is wiping out your accumulated string (strPutTogether) any time an empty textbox is encountered. So the text that was stored from txtField1 is getting erased when it enters the txtField2 if condition. jimmyBo's got a good suggestion, or another way to go about it would be to replace your current if conditions with something along the lines of
    If txtField1.Text <> "" Then strPutTogether &= txtField1.Text & ","
    
  3. In Topic: How fast are your 10 fingers?

    Posted 5 Dec 2011

    Words per minute (WPM) 69
    Keystrokes 335
    Correct words 65
    Wrong words 1
  4. In Topic: Reputation Awards- November

    Posted 1 Dec 2011

    Congrats to everyone! It's been a fun month in VB.NET
  5. In Topic: saving to an access database

    Posted 1 Dec 2011

    offers an excellent suggestion about parameters. They make for a lot more code, but it's easier to read, easier to maintain, and they help guard against SQL injection. That said, let's look at your statement.
    Dim cm As New OleDb.OleDbCommand(" Update Details Set HCNNO = '" & HCNNO & "' ... WHERE HCNNO = " & HCNNO, DBCon)
    

    So in the Set section, you've got the HCNNO value surrounded by ' ', but in the where clause you don't. You said it's set to a double in the the database, so you're trying to set a double value to a string. Try getting rid of the ' ' and see what happens.

My Information

Member Title:
D.I.C Head
Age:
32 years old
Birthday:
June 30, 1980
Gender:
Location:
Helena, MT
Years Programming:
3
Programming Languages:
Java, C#, VB.NET, Ruby

Contact Information

E-mail:
Click here to e-mail me
Website URL:
Website URL  http://www.happylittlecodes.com

Friends

Comments

Tryparse has no profile comments yet. Why not say hello?