Case Select Statements & Updating the Database

jackiew · #1 (**permalink**) April 11th, 2006, 11:10 AM

I have a Case Select Statement that is selecting what item price goes with what item. (Long and complicated, but this is what I need to do.)

I want to use the result from that Case Select to update the database with the price.

Here's the Case Statement

Code:

'--Logo Price based on LogoOption

Dim mySqlConn8 as SqlConnection
Dim mySqlCmd8 as SqlCommand
Dim LogoID as Integer
Dim LogoPrice as String

mySqlConn8 = new SqlConnection("DNS")
    mySqlCmd8 = new SqlCommand("SELECT LogoPrice FROM Logo", mySqlConn8)
    mySqlConn8.Open()

    Select Case(LogoPrice)
        Case LogoID = 1
            LogoPrice = "4.25"
        Case LogoID = 2
            LogoPrice = "4.25"
        Case LogoID = 3
            LogoPrice = "1.10"
        Case LogoID = 4
            LogoPrice = "1.10"
        Case LogoID = 5
            LogoPrice = "0.00"
    End Select
    mySqlConn8.Close()

And here is the update statements I'm using.

Code:

UpdateCMD.Parameters.Add("@LogoPrice", SqlDbType.Money, 8).Value = LogoPrice.Text

How do I get the result from the Case Statement to my Update Statement? I know its syntax, and I have tons of problems with syntax. I also know I probably didn't put the right code blocks here for you to look at. Just let me know what you need.

Help!

jackiew · #2 (**permalink**) April 11th, 2006, 11:47 AM

Thought I'd forward the error message I get with the above setup.

Code:

System.FormatException: Input string was not in a correct format.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at 
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at 
ASP.OrderPage_aspx.AddToCart(Object s, EventArgs e) in 
D:\Inetpub\Intranet\Apparel\OrderPage.aspx:line 269

With Line 269 being the Update Statement.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Updating database & saving it to another file	OnceANewbie	VB Databases Basics	1	December 1st, 2008 06:58 AM
Switch Case statements	ermy78	Access VBA	3	October 20th, 2006 08:58 AM
CASE Statements in T-SQL	atcs2152	SQL Server 2000	3	April 28th, 2006 10:53 AM
Case Statements	cfriedberg	SQL Server 2000	1	September 7th, 2005 08:46 PM
Case Statements in Access	dbegg	Access	2	September 17th, 2003 04:30 PM