Thanks for the help in advance....
I am writing a form in vb.net to insert values to sql database. One of the fields is a money value and I keep getting errors when inserting null values as some of the fields need to remain null at the users dicretion.
Here is what I have tried and here is the result :
'if there are no duplicate records then start inserting the new product
insertQuer = "Insert into st_products (product_sku,product_name,product_short_desc,product_long_desc,brand,product_type,product_display_price) values (@psku,@pname,@psDesc,@plDesc,@pBrand,@pType,@pDprice)"
insertCmd = New SqlCommand(insertQuer, myconnection)
'start parameters for paramaterized query
insertCmd.Parameters.Add(New SqlParameter("@psku", SqlDbType.VarChar, 50))
insertCmd.Parameters("@psku").Value = Sku.Text
...
Go to the complete details ...