Curtis Rutland's Profile User Rating: *****

Reputation: 4748 Guru
Group:
Moderators
Active Posts:
8,599 (4.57 per day)
Joined:
08-June 10
Profile Views:
86,655
Last Active:
User is offline Yesterday, 08:29 AM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Who Cares
Favorite Browser:
Who Cares
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
1050
Expert In:
C#, LINQ, Dynamics CRM

Latest Visitors

Icon   Curtis Rutland has been promoted!

Posts I've Made

  1. In Topic: Using parameters is MS SQL.

    Posted 31 Jul 2015

    Oh god no.

    Understand that parameter values are values. They're not treated as SQL "code". They're not identifiers. They're not tokens to be string-replaced. You can only use them for values, values, and...values. Not identifiers.

    What problem are you trying to solve? Are you expecting your database and your table names to be changed? The database name thing is easy to handle in configuration; you have an Initial Catalog parameter of a connection string. Tables...if you're trying to build a query engine for unknown tables, you're going to have to use string replacement. But if you know the structure of your tables, you can enforce not changing the names yourself.
  2. In Topic: Using parameters is MS SQL.

    Posted 31 Jul 2015

    You can't parameterize tables or fields. Parameters aren't string replacements. They represent values. Identifiers aren't values, therefore they can't be represented by parameters.

    Sorry, but the only valid parameter in your query is @FieldID.
  3. In Topic: StackOverflow Exception when reading from SQL Database

    Posted 31 Jul 2015

    There's not much overhead in creating a new connection when you need it vs. re-opening and re-closing the same one; most applications wouldn't know the difference. With that in mind, the using block denotes the lifespan of the connection, and it closes it for you. That's why I prefer to use it.
  4. In Topic: StackOverflow Exception when reading from SQL Database

    Posted 30 Jul 2015

    Glad you found it! I certainly couldn't think of any good reason that there would be a Stack Overflow inside System.Data :P
  5. In Topic: Problems converting string to MD5

    Posted 30 Jul 2015

    Neat

    Spoiler


    Seriously though, I didn't even realize Guid had a format parameter in its ToString().

My Information

Member Title:
(╯□)╯︵ (~ .o.)~
Age:
30 years old
Birthday:
August 29, 1984
Gender:
Location:
San Antonio
Forum Leader:
C#
Full Name:
Curtis Rutland
Years Programming:
7
Programming Languages:
C# -- Forms, WPF, Silverlight, WCF

Contact Information

E-mail:
Click here to e-mail me
Website URL:
Website URL  http://curtisrutland.com
Skype:
Skype  insertAlias_bytes
Twitter:
curtisrutland

Comments

  • (2 Pages)
  • +
  • 1
  • 2
  1. Photo

    NewRandomUsername Icon

    06 Jun 2014 - 20:59
    Did you get my messages(emails) sir?
  2. Photo

    BenignDesign Icon

    03 May 2013 - 13:29
    I see you were staring at my profile. I also stare randomly at profiles. We have much in common. We should probably hook up sometime. Just sayin.
  3. Photo

    eric wallace Icon

    31 Jan 2013 - 02:53
    can you help for visual basic
  4. Photo

    no2pencil Icon

    06 Dec 2012 - 08:34
    It still isn't good enough.
  5. Photo

    ikram002p Icon

    27 Jun 2012 - 10:51
    "It Doesn't Work!" That's not good enough!
    It Still Doesn't Work!.
    I didnt undestand it ??
  6. Photo

    tlhIn`toq Icon

    18 Mar 2012 - 11:22
    Congrats on breaking 3000
  7. Photo

    Curtis Rutland Icon

    08 Sep 2011 - 14:13
    "Leveling up." I like that!
  8. Photo

    MATTtheSEAHAWK Icon

    08 Sep 2011 - 13:55
    Yar ya see, i remember when yee wer purple!
    Anyways congrats! It's weird seeing people who've been one way so long "leveling up" :P.
  9. Photo

    Curtis Rutland Icon

    08 Sep 2011 - 12:59
    Thanks!
  10. Photo

    Sergio Tapia Icon

    08 Sep 2011 - 12:29
    Congrats on becoming a mod. :D
  11. Photo

    Ace26 Icon

    15 Jun 2011 - 13:39
    Hi mate, interesting to see we are age mates. Nice work you do in the forums.
    Just dropped by to say hi, anyways.
    Cheers.
  12. Photo

    RetardedGenius Icon

    20 Apr 2011 - 18:56
    Excellent C# tutorials, they've taught me a lot I didn't know. Please keep more of the good stuff coming! :D
  13. Photo

    Curtis Rutland Icon

    24 Mar 2011 - 14:55
    Yeah, felt like "professionalizing".
  14. Photo

    Dogstopper Icon

    23 Mar 2011 - 17:08
    Woah. Name switch! I took a double take...
  15. Photo

    CodingSup3rnatur@l-360 Icon

    01 Mar 2011 - 14:35
    No problem at all. Glad I could contribute :)
  • (2 Pages)
  • +
  • 1
  • 2