display = "SELECT AlbumName,Category, QOH, MinLevel, Price, [Profit%] UserID FROM AlbumRec WHERE AlbumID = '" & found & "'"
                mySqlCommand = New SqlCommand(display, mySqlConnection)
                myReader = mySqlCommand.ExecuteReader
                lblRecord.Text = add

                If (myReader.Read()) Then

                    locked = myReader.Item("UserID").ToString.Trim
                    ALbumname = myReader.Item("AlbumName").ToString
                    Category = myReader.Item("Category").ToString
                    Qoh = myReader.Item("QOH").ToString()
                    minLevel = myReader.Item("MinLevel").ToString()
                    netprice = myReader.Item("Price").ToString()
               profit = myReader.Item("[Profit%]").ToString()

                    newRecord = False
                    myReader.Close()
                end if

i have successly to run the sqlcommand, but i am failly to get the value in myreader. the error occur, "[profit%]". so can anyone help me to solve this prob?? i am appreciated if u guy may help me to solve it, thank...thank a lot!!  

[Edited by bshaen on 10-01-2006 at 04:11 PM GMT]

____________________________
bshaen

Just a quick thought on this one.
It could be something to do with the "%" in your Field name. Try changing the Field Name to "ProfitPC" and see if that makes a difference.


____________________________
multi-tasking - the ability to hang more than one app. at the same time.