带参数SQL的数据录入

XuguConnection conn = new XuguConnection();
conn.ConnectionString = conn_xugu ;
Try
{
    conn.Open();
    XuguCommand cmd = new XuguCommand();
    cmd.Connection = conn;
    string sql = "insert into tp(pid,pname) values(?,?)"; 
    cmd.CommandText = sql;
    XuguTransaction trans = conn.BeginTransaction();//为连接创建显示事务，此时该连接事务处于非自动提交状态
    cmd.Transaction = trans;//指定申明命令事务环境

    //参数赋值
    cmd.Parameters.Add("pid", XuguDbType.Int).Value = 2;
    cmd.Parameters.Add("pname", XuguDbType.VarChar).Value = "开发部";
    cmd.ExecuteNonQuery();
    //重复执行参数赋值前，需清除前次参数
    cmd.Parameters.Clear();
    cmd.Parameters.Add("pid", XuguDbType.Int ).Value = 3;
    cmd.Parameters.Add("pname", XuguDbType.VarChar).Value = "测试部";
    cmd.ExecuteNonQuery();

    trans.Commit();//提交命令事务
    return 1;
}
catch (System.Exception ex)
{
    return 0;
}