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 - 22:55 by sali22.
Tags: ,


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