使用参数时将SQL查询存储在数据库中 [英] store SQL query in database when I use parameter

问题描述

有人可以帮助我使用参数执行查询时如何在数据库中存储SQL查询(语句作为日志)吗?...

我更喜欢的语言= vb.net

例如:

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)"

我想用输入的值存储SQL，但是它存储与上面的代码相同的代码

在此先感谢

I want to store SQL with entered values, but it stores the same as above code

Thanks in advance

推荐答案

尝试:

Using con As New SqlConnection(strConnect)
	con.Open()
	Using com As New SqlCommand("INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)", con)
		com.Parameters.AddWithValue("@C1", myValueForColumn1)
		com.Parameters.AddWithValue("@C2", myValueForColumn2)
		com.ExecuteNonQuery()
	End Using
End Using

尝试这种方式:

Try this way:

Dim sql As String = "INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)"
       Dim sql_to_log As String = sql
       sql_to_log = sql_to_log.Replace("@C1", myValueForColumn1.tostring)
       sql_to_log = sql_to_log.Replace("@C2", myValueForColumn2.tostring)

保存到数据库"sql_to_log".

Save to database ''sql_to_log''.

没有其他解决方案了！!

让我再解释一次，
我想在使用参数后执行后显示查询字符串，

希望您能明白我的意思

there is no other solution !!?

let me explain again,,
I want to display the query string after execution when parameters have been used ,

I hope you will get what do i mean

这篇关于使用参数时将SQL查询存储在数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！