Click here to Skip to main content

store SQL query in database when I use parameter

Revision 4
can anyone help me how I can store SQL query (statement as log) in database when I use parameter to execute a query?... My prefer language = vb.net for example :
sql = "insert into model (name, age, date_of_confinement,type_of_sickness, type_of_IVfluid, number_of_bottles, drop_rate)" & _
                   " values (@name, @age, @dateOfConfinement, @sicknessType, @fluidType, @bottleAmount, @dropRate)"
I want to store SQL with entered values, but it stores the same as above code Thanks in advance
Posted 1-Oct-12 23:55pm by sali22.
Tags: ,


Advertise | Privacy | Mobile
Web01 | 2.8.141223.1 | Last Updated 5 Nov 2009
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid