using CUBRID.Data.CUBRIDClient; namespace ParameterExample
{
class Program
{
static void Main(string[] args)
{
CUBRIDConnectionStringBuilder sb = new CUBRIDConnectionStringBuilder("localhost", "demodb", "public", "", "33000");
using (CUBRIDConnection conn = new CUBRIDConnection(sb.GetConnectionString()))
{
conn.Open();
using (CUBRIDCommand cmd = new CUBRIDCommand("create table t(a int, b varchar(20))", conn))
{
cmd.ExecuteNonQuery();
} using (CUBRIDCommand cmd = new CUBRIDCommand("insert into t values(?, ?)", conn))
{
CUBRIDParameter p1 = new CUBRIDParameter("?p1", CUBRIDDataType.CCI_U_TYPE_INT);
p1.Value = 1;
cmd.Parameters.Add(p1); CUBRIDParameter p2 = new CUBRIDParameter("?p2", CUBRIDDataType.CCI_U_TYPE_STRING);
p2.Value = "abc";
cmd.Parameters.Add(p2); cmd.ExecuteNonQuery();
}
conn.Close();
}
}
}
}
和net差不多,区别是 CUBRID.Data.CUBRIDClient封装了
using System; namespace System.Data
{
// Summary:
// Specifies the type of a parameter within a query relative to the System.Data.DataSet.
public enum ParameterDirection
{
// Summary:
// The parameter is an input parameter.
Input = 1,
//
// Summary:
// The parameter is an output parameter.
Output = 2,
//
// Summary:
// The parameter is capable of both input and output.
InputOutput = 3,
//
// Summary:
// The parameter represents a return value from an operation such as a stored
// procedure, built-in function, or user-defined function.
ReturnValue = 6,
}
}