Click here to Skip to main content
15,888,968 members

store SQL query in database when I use parameter

Latest Revision
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 :
VB
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:55pm by sali22.
Tags: ,