带参数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;
    //参数赋值
    XuguParameters pidParam = new XuguParameters("pid", XuguDbType.Int);
    pidParam.Direction = ParameterDirection.Input;
    pidParam.Value = 2;
    cmd.Parameters.Add(pidParam);
    string c1string = "李四";
    XuguParameters nammeParam = new XuguParameters("name", XuguDbType.VarChar);
    nammeParam.Direction = ParameterDirection.Input;
    nammeParam.Value = c1string;
    cmd.Parameters.Add(nammeParam);

    cmd.ExecuteNonQuery();

    cmd.Parameters.Clear();
    cmd.Parameters.Add("pid", XuguDbType.Int).Value = 2;
    cmd.Parameters.Add("name", XuguDbType.VarChar).Value = "王五";
    cmd.ExecuteNonQuery();
    //重复执行参数赋值前，需清除前次参数
    cmd.Parameters.Clear();
    cmd.Parameters.Add("pid", XuguDbType.Int).Value = 3;
    cmd.Parameters.Add("name", XuguDbType.VarChar).Value = "赵七";
    cmd.ExecuteNonQuery();
    cmd.Parameters.Clear();
    cmd.Parameters.Add("pid", XuguDbType.Int).Value = 3;
    cmd.Parameters.Add("name", XuguDbType.VarChar).Value = "钱八";
    cmd.ExecuteNonQuery();
    return 1;
}
catch (System.Exception ex)
{
    Console.WriteLine(ex.ToString());
    conn.Close();
    return 0;
}