我需要把这个 richTextBox2中的5条数据,一行一行的插入到oracle中,命令如下:
int linecount = richTextBox2.Lines.Length;
for (int o = 0; o <= linecount - 1; o++)
{
string linestr = "";
linestr = richTextBox2.Lines[o];
OracleConnection con = new OracleConnection("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.6.161) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)));Persist Security Info=True;User Id=zhianguankong2; Password=zhianguankong2123");
con.Open();
string InsertSql = "insert into TB_BLACKLIST(VEHID,CARDID) values (sys_guid(),'" + linestr + "')";
OracleCommand com = new OracleCommand(InsertSql, con);
com.ExecuteNonQuery();
OracleDataAdapter ada = new OracleDataAdapter("select * from tb_Member", con);
DataSet ds = new DataSet();
ada.Fill(ds, "tb_Member ");
con.Close();
richTextBox3.Text = "添加成功!";
我做了个循环,但是这个循环做了还是不对,SQL语句中的linestr还是只有第一行数据,每次点击按钮,oracle中只有richTextBox中第一行的,