Database Problem

Hi, Im using an access database to store a bunch of measurements. I have a dropdown menu so the user can pick measurements of an object then I assign these measurements to variables and then compare these measurements to the measurements stored in the database. From the database I am trying to retrieve a part number from the measurements the user has picked. The code does not work but I dont know why. The variables are picture,Number,and pictureCenter. Picture and pictureCenter do not keep pictures but the measurements. The columns in the database are HoseSize, FittingType, FittingSize conn.Open() AdaptID = New OleDbDataAdapter("Select PartNumber from TableID where " + CStr(picture) + " = FittingType and " + CStr(Number) + " = FittingSize and " + CStr(pictureCenter) + " = HoseSize", conn) AdaptID.Fill(TablePartNum) PartNumber = (TablePartNum.Rows(0)("PartNumber")).ToString() Label3.Text = "Left Part #: " + Partleft TablePartNum = Nothing AdaptID = Nothing conn.Dispose() thank you

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

MythicalMe21y ago
Your query is wrong. Try: AdaptID = new OleDbDataAdapter("SELECT PartNumber FROM TableID WHERE FittingType = " & _ CStr(picture) & " AND FittingSize = " & CStr(number) & " AND HoseSize = " & _ CStr(pictureCenter), conn) This assumes that: 1. Your database table name is TableID 2. All of your data is stored as numeric data 3. That the picture variable contains the FittingType data. 4. That the Number variable contains the FittngSize data. 5. That the pictureCenter variable contains the HoseSize data.