Hi

at the start of the code type
try
<insert rest of code here>

catch e as exception
messagebox.show(e.message)
end try



Duncan

I ran the catch program and this is the error that I got. Line1: incorrect syntax near 'false'. Well this line here---

Dim strSQl As String = strSQl = "INSERT INTO [Auto] (ItemImage) VALUES (@MyImage)"

strSQL is = to 'false' when I run my break points. When the user types in a value in a text box and clicks the add button, a new form appears with the drawing program. I have a menu at the top with the save menu in it. My question is when the user types in a value on the previous form and clicks the add button, it saves it to my database. On my drawing form how does it know to save it to that same row in the database. Is that part of my problem?

Hi

you code is wrong it should

dim strSql as string = "Insert into [Auto] (ItemImage) VALUES (@MyImage)

run this to see if it helps


Duncan

I change that and got a different error. Operand type clash = image is incompatible with int.?

I changed the value in my sql database to numeric just to see what would happen. I got the same error Operand type clash = image is incompatible with numeric but with numeric. What should the data type be?

Hi

Why are you trying to store an image into a numeric datatype, you have specified the data type in the parameter query as an system.data.sqldbtype.image, so I thought it would be obvious that the datatype in the database would need to be the same.


Duncan

You are 100% correct. Thanks for the input. The last problem that im having now is taking the value from a text box on the previous form and putting that in my update query on the current form. this is what I tried

Public AddItemNum As String
AddItemNum = Val(txtAddItemNumber)

But it says ((Argument 'Expression' cannot be converted to type 'TextBox'.))

Hi

If the previous form is shown using "showdialog" then you can get the values from that ie...

dim AdditemNumber as int32 'declare variable
dim frm as new form1 'this will create an instance of the form
frm.showdialog() 'this will show the form and let the user enter data
additemnumber = frm.txtadditemnumber.text
frm.close 'remeber to close the form as this will remain hidden




Duncan

Can I just declare a variable on one form and use its value on another. That seems like it would be easer. I know how to do it in regular vb.

Hi

Well not really because the variable declaration would not be inscope between the two forms, and declaring a global varible is a BIG No No. you might be best to create a public property that gets the value from the first form and the second form can read from that public property

first form
private _isAddItem as string 'or what ever data type you need
public property IsAddItem as string 'or what ever datatype you need
get
return _isadditem
end get
set (value as string)
_isadditem = value
end set
end property

in the text changed event
private sub Text1_changed(sender, e)
_isadditem = me.text1.text
end sub

in form two
you just need to call IsAddItem and you should get the value


Duncan