常见数据类型参数方式插入示例

string connStr = "DSN=XuguDB;USER=SYSDBA;PWD=SYSDBA";
OdbcConnection conn = new OdbcConnection(connStr);
try
{
    conn.Open();
    OdbcCommand cmd = conn.CreateCommand();
    cmd.CommandType = CommandType.Text;
    cmd.CommandText = "insert into mytable (c1,c2,c3) values(?,?,?)";

    OdbcParameter[] parameters ={
        new OdbcParameter("c1",OdbcType.BigInt,8),
        new OdbcParameter("c2",OdbcType.SmallInt,2),
        new OdbcParameter("c3",OdbcType.TinyInt,1) };
    parameters[0].Value = 3141592653;
    parameters[1].Value = (short)31415;
    parameters[2].Value = 100;
    parameters[0].Direction = ParameterDirection.Input;
    parameters[1].Direction = ParameterDirection.Input;
    parameters[2].Direction = ParameterDirection.Input;

    cmd.Parameters.Add(parameters[0]);
    cmd.Parameters.Add(parameters[1]);
    cmd.Parameters.Add(parameters[2]);

    cmd.ExecuteNonQuery();

    conn.Close();
}
catch (Exception ex)
{
    Console.WriteLine(ex.Message);
}