这里不写教程,只做记录:
环境:
vs2015 c# oracle
1.数据插入。
string str1 =
"insert into LH_TREEDEVICEHIS (ID, TREE_NUMBER,DEVICE_NUMBER,SUNSHINE,AIR_TEMPERATURE,AIR_MOISTURE,SOIL_TEMPERATURE,SOIL_MOISTURE,SOIL_MOISTURE30,SOIL_PH,SAVE_DATE)" + " values ('" +
id0 + "' , '" + num +"', '"+id + "', '"+sunshine+"', '"+air_tempe+"','"+air_moi+"', '"+soil_tempe+"','"+
soil_moi + "','" + soil_moi30 +"','"+ soil_ph +"',"+"To_Date('"+ save_date + "','yyyy-mm-dd hh24:mi:ss'))";
OracleCommand cmd2= new OracleCommand(str1, mConnection);
if (cmd2.ExecuteNonQuery() > 0)
{
res = true;
}
else
{
Console.WriteLine("Failed to insert warn data into database!");
}
写上段代码遇到很多问题:主要还是格式的问题:找到命令格式很重要。
截图如下: