不带参数的数据录入
XuguConnection conn = new XuguConnection();
conn.ConnectionString = conn_xugu ;
Try
{
string insert_sql_ta = "insert into ta(pid,name) values(1,'张三')";
string insert_sql_tp = "insert into tp(pid,pname,modify_time) values(1,'财务部',to_date('2016-04-21 12:12:00','yyyy-mm-dd hh:mi:ss'))";
XuguConnection conn = new XuguConnection();
conn.ConnectionString = conn_xugu;
conn.Open();
XuguCommand cmd = new XuguCommand();
cmd.Connection = conn;
cmd.CommandText = insert_sql_ta;
cmd.ExecuteNonQuery();
cmd.CommandText = insert_sql_tp;
cmd.ExecuteNonQuery();
}
catch (System.Exception ex)
{
Console.WriteLine(ex.ToString());
conn.Close();
Console.WriteLine("测试关闭连接后连接当前状态" + conn.State.ToString());
}