Convert String to SqlDbType

Question

I am trying to convert a string values into a SqlDbType. My code is able to covert "Text" into SqlDbType.Text without any errors but when I try to convert "bit" into SqlDbType.Bit, I receive the following error: "Requested value 'bit' was not found."

The same thing happens when trying to convert "int" into SqlDbType.Int Error Message: "Requested value 'int' was not found."

Why will this work for "text" but not "bit" or "int"?

Dim MyType as String = "bit"
Dim sdtype As SqlDbType

sdtype = DirectCast([Enum].Parse(GetType(SqlDbType), MyType), SqlDbType)

Nicholas Carey · Accepted Answer · 2011-01-27 20:45:55Z

22

Because the enum value is SqlDbType.Bit, not SqlDbType.bit. Enum.Parse() is case-sensitive WRT to its input.

You need to use this overload of Enum.Parse:

SqlDbType type = (SqlDbType) Enum.Parse( typeof(SqlDbType) , "bit" , true ) ;

The third parameter indicates whether (true) or not (false) case should be ignored in parsing the enum's value from a string.

answered Jan 27, 2011 at 20:45

Nicholas Carey

75.1k16 gold badges96 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joe Enos · Accepted Answer · 2011-01-27 20:42:10Z

0

Looks like it's case-sensitive. Try "Bit" and see if that works out.

answered Jan 27, 2011 at 20:42

Joe Enos

40.6k11 gold badges86 silver badges144 bronze badges

1 Comment

crjunk Over a year ago

You are right. I just notice there is a flag that will ignore case. I added True and it works! sdtype = DirectCast([Enum].Parse(GetType(SqlDbType), MyType), SqlDbType, True)

Roy T. · Accepted Answer · 2011-01-27 20:44:49Z

0

What is the result of [Enum].Parse(GetType(SqlDbType))? Is this the result you expect? Because I think the error might be in there.

As a last alternative, could you try CTYpe instead if direct cast? (http://msdn.microsoft.com/en-us/library/7k6y2h6x(VS.71).aspx)

CType is slightly more flexible, however I do think it is a long shot, but maybe worth trying.

answered Jan 27, 2011 at 20:44

Roy T.

9,6782 gold badges54 silver badges74 bronze badges

Collectives™ on Stack Overflow

Convert String to SqlDbType

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related