需要一些帮助将数据输入到oracle中 [英] want some help to enter datas into oracle

问题描述

我必须向oracle输入值.

I have to enter values to oracle.

orc.Open() 

 For i = 0 To ci 
 u(i) = Request.QueryString("t(" & ci & ")") 
query = "insert into dieselstate values('" & u(i) & "')" 
cmd = New OracleCommand(query, orc) 
cmd.ExecuteNonQuery() 
Next 

orc.Close() 

还有其他选择吗?

Are there any other options?

推荐答案

当然，还有更多选择.我不太确定您在寻找什么.

Of course there are some more options. I am not really sure what are you looking for.

最明显的其他选择是，如果Oracle将参数作为XML，则将所有值都以XML的形式串在一起，SQL Server肯定会这样做.

The most obvious other option is to string all your values together as XML, if Oracle will take paramaters as XML, which SQL Server certainly does.

这篇关于需要一些帮助将数据输入到oracle中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！