關於利用ODP特性批量插入數據到ORACLE,結果總是插入失敗!代碼如下:
public void button2_Click(object sender, EventArgs e)
{
RESULT.Clear();
boxsnstr = new string[3000];
openFileDialog1.Filter = "TXT文檔(*.txt)|*.txt";
if(openFileDialog1.ShowDialog()==DialogResult.OK)
{ DIRECTORYBOX.Text = openFileDialog1.FileName;
StreamReader sr = new StreamReader(openFileDialog1.FileName);
while (sr.Peek()>-1)
{ RESULT.Add(sr.ReadLine()); }
sr.Close();
int T = RESULT.Count;
RESULT.CopyTo(boxsnstr, 0);
string snn = string.Format("insert into sfis1.temp_temp values(:serial_number)");----?????
OracleCommand insn = new OracleCommand(snn, DBHelper.conn);
insn.ArrayBindCount = T;
boxsnstr = new string[T];
insn.Parameters.Add("serial_number", OracleDbType.Varchar2).Value = boxsnstr;
insn.Parameters["serial_number"].Direction = ParameterDirection.Input;
for (int i = 0; i < T; i++)
{
boxsnstr[i] = i.ToString();-???????
}
insn.ExecuteNonQuery();運行結果沒有插入數據!?
這段程式是我在網上看到照葫蘆畫瓢寫的,有兩個地方不明白,請教大神
1.string snn = string.Format("insert into sfis1.temp_temp values(:serial_number)")
自己也覺得有問題," :serial_number” 這種格式是表示傳入的參數么?
2.
for (int i = 0; i < T; i++)
{
boxsnstr[i] = i.ToString();-???????
}
這個循環好像提供的不是正確的參數值,i只是個數值,實在不明白!!,請幫忙解答解答!非常感謝!!幫忙瞧瞧我這個爛程式,實在有點羞愧啊!
public void button2_Click(object sender, EventArgs e)
{
RESULT.Clear();
boxsnstr = new string[3000];
openFileDialog1.Filter = "TXT文檔(*.txt)|*.txt";
if(openFileDialog1.ShowDialog()==DialogResult.OK)
{ DIRECTORYBOX.Text = openFileDialog1.FileName;
StreamReader sr = new StreamReader(openFileDialog1.FileName);
while (sr.Peek()>-1)
{ RESULT.Add(sr.ReadLine()); }
sr.Close();
int T = RESULT.Count;
RESULT.CopyTo(boxsnstr, 0);
string snn = string.Format("insert into sfis1.temp_temp values(:serial_number)");----?????
OracleCommand insn = new OracleCommand(snn, DBHelper.conn);
insn.ArrayBindCount = T;
boxsnstr = new string[T];
insn.Parameters.Add("serial_number", OracleDbType.Varchar2).Value = boxsnstr;
insn.Parameters["serial_number"].Direction = ParameterDirection.Input;
for (int i = 0; i < T; i++)
{
boxsnstr[i] = i.ToString();-???????
}
insn.ExecuteNonQuery();運行結果沒有插入數據!?
這段程式是我在網上看到照葫蘆畫瓢寫的,有兩個地方不明白,請教大神
1.string snn = string.Format("insert into sfis1.temp_temp values(:serial_number)")
自己也覺得有問題," :serial_number” 這種格式是表示傳入的參數么?
2.
for (int i = 0; i < T; i++)
{
boxsnstr[i] = i.ToString();-???????
}
這個循環好像提供的不是正確的參數值,i只是個數值,實在不明白!!,請幫忙解答解答!非常感謝!!幫忙瞧瞧我這個爛程式,實在有點羞愧啊!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货