We help IT Professionals succeed at work.

objcmd.Parameters.Add = 3 Pulldown Values

net_susan
net_susan asked
on
Medium Priority
237 Views
Last Modified: 2008-03-06
I want this:
objcmd.Parameters.Add("@SDOB", SqlDbType.DateTime).Value =

to equal the values from my three pulldowns:
bdaymonth.SelectedValue
bdayday.SelectedValue
bdayyear.SelectedValue

in this format:

11/28/1968

How would I do that?

I'm thinking maybe something like this:
objcmd.Parameters.Add("@SDOB", SqlDbType.DateTime).Value = bdaymonth.SelectedValue + bdayday.SelectedValue + bdayyear.SelectedValue

Comment
Watch Question

SQL Server Architect
CERTIFIED EXPERT
Commented:
Or you could do something like:

objcmd.Parameters.Add("@SDOB", SqlDbType.DateTime).Value = String.Format("{0}/{1}/{2}", bdaymonth.SelectedValue, bdayday.SelectedValue, bdayyear.SelectedValue)

And if you wanted it to be in a DateTime format then you would just wrap it with

DateTime.Parse(string.Format......)

Ben.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Groovy. :)
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.