Problem with sql query string.

This is my sql query string –

string Qry = "INSERT INTO [CureDB].[dbo].[PurchaseInfo] ([PurchaseID],[PurchaseDate],[SupplierID],[PurchaseQty],[PurchaseValue],)VALUES('" + obj.PurchaseId + "','" + obj.PurchaseDate + "','" + obj.SupplierId + "'," + obj.Quantity + ","+ obj.Price +") "; 

When I run my application there is an exception thrown. That says *Unexpected ")" *. obj.Quantity and obj.Price is integer and decimal respectively. So what is the correct formation of this sql query string ?

Thank you.

by muztaba via /r/csharp

Leave a Reply