Skip to content

不带参数的数据录入

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());
}