VB.net 执行SQL文的输出
在VB。net中想看下执行的SQL语句例如:
Dim oc1_chrDate As Oracle.DataAccess.Client.OracleParameter
strSQL = "DELETE FROM Table1 T Where T.DATE<:oc1_chrDate"
oc1_chrDate.value = "20101025"
执行这个SQL语句
怎么能输入:[DELETE FROM Table1 T Where T.DATE<20101025]的字符串
哪位大侠知道,请多多指教,小弟谢谢了! --------------------编程问答-------------------- Dim oc1_chrDate As Oracle.DataAccess.Client.OracleParameter
strSQL = "DELETE FROM Table1 T Where T.DATE<" & oc1_chrDate.value
oc1_chrDate.value = "20101025" --------------------编程问答-------------------- strSQL = "DELETE FROM Table1 T Where T.DATE<" & 值
--------------------编程问答--------------------
--------------------编程问答-------------------- 晕,排版好傻。。。。
olecomm.Parameters("@imgdata").Value = .Item("designimage")
olecomm.CommandText = "insert into [ExImage] values ('" + .Item _("designnum").ToString.Trim + "',?,'" + .Item("txflag").ToString.Trim + "','" + .Item _("crtdat").ToString.Trim + "')"
olecomm.ExecuteNonQuery()
--------------------编程问答-------------------- 简单来说,就是在SQL语句中使用"?"来代替参数 --------------------编程问答--------------------
olecomm.Parameters("@imgdata").Value = .Item("designimage")
olecomm.CommandText = "insert into [ExImage] values ('" + .Item("designnum").ToString.Trim + "',?,'" + _
.Item("txflag").ToString.Trim + "','" + .Item("crtdat").ToString.Trim + "')"
olecomm.ExecuteNonQuery()
补充:.NET技术 , VB.NET