如题: 在C# WINFORM 里..连接ORACLE并创建新表. 提示无效操作,连接被关闭..代码如下const string ConnStr = "DATA SOURCE=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={0})(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME={1})));USER ID={2};PASSWORD={3}";
conn.ConnectionString = string.Format(ConnStr, "111.11.11.33", "xxxx", "xxxx", "1234");///
conn.Open(); OracleCommand com = conn.CreateCommand();
//OracleDataAdapter da = new OracleDataAdapter(com);
OracleCommand ce=new OracleCommand //创建临时表.... com.CommandText = "create table fang_temp_ppsjh as select t.serial_number,max(recv_time) jhsj from ucr_act1.tf_b_paylog_pps t where eparchy_code='0000' and to_char(recv_time,'yyyymmdd')>=20110601 group by t.serial_number";
ce.CommandText = CommandText;
ce.CommandType = CommandType.Text;
int oResult = ce.ExecuteNonQuery();
conn.ConnectionString = string.Format(ConnStr, "111.11.11.33", "xxxx", "xxxx", "1234");///
conn.Open(); OracleCommand com = conn.CreateCommand();
//OracleDataAdapter da = new OracleDataAdapter(com);
OracleCommand ce=new OracleCommand //创建临时表.... com.CommandText = "create table fang_temp_ppsjh as select t.serial_number,max(recv_time) jhsj from ucr_act1.tf_b_paylog_pps t where eparchy_code='0000' and to_char(recv_time,'yyyymmdd')>=20110601 group by t.serial_number";
ce.CommandText = CommandText;
ce.CommandType = CommandType.Text;
int oResult = ce.ExecuteNonQuery();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货