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 ?
by muztaba via /r/csharp