oracle表写不入数据,OracleDataAdapter.Update()写不进数据库也不报错。求帮助啊。…...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

public static void Adapter_updateDB(DataTable dt)

{

string sql_str = "insert into t_avgwindspeed(DATETIME,WINDMILLNUM,WINDSPEED,POWER)values(@DATETIME,@WINDMILLNUM,@WINDSPEED,@POWER)";

//string sql_str = "insert into t_avgwindspeed(DATETIME,WINDMILLNUM,WINDSPEED,POWER,TIMECELL)values(@DATETIME,@WINDMILLNUM,@WINDSPEED,@POWER,@TIMECELL)";

Connection = new OracleConnection(Conn_str);

OracleCommand com = new OracleCommand(sql_str,Connection);

com.Parameters.Add("@DATETIME", OracleDbType.Date, 32, "时间");

com.Parameters.Add("@WINDMILLNUM", OracleDbType.Varchar2, 32, "风机名");

com.Parameters.Add("@WINDSPEED", OracleDbType.Varchar2, 32, "风速");

com.Parameters.Add("@POWER", OracleDbType.Varchar2, 32, "功率");

//com.Parameters.Add("@TIMECELL", OracleDbType.Varchar2, 32, "时间间隔");

com.UpdatedRowSource = UpdateRowSource.None;

OracleDataAdapter da = new OracleDataAdapter();

da.InsertCommand = com;

Connection.Open();

da.Update(dt);

Connection.Close();

}