非参数方式更改数据示例

string connStr = "DSN=XGDB;USER=SYSDBA;PWD=SYSDBA";
OdbcConnection conn = new OdbcConnection(connStr);
try
{
    conn.Open();
    OdbcCommand cmd = conn.CreateCommand();
    cmd.CommandText = "udpate mytable set c2 = 'update' where id = 1";

    if (cmd.ExecuteNonQuery() > 0)
        Console.WriteLine("Update successful!");
    else
        Console.WriteLine("Update failed!");

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

string connStr = "DSN=XGDB;USER=SYSDBA;PWD=SYSDBA";
OdbcConnection conn = new OdbcConnection(connStr);
try
{
    conn.Open();
    OdbcCommand cmd = conn.CreateCommand();
    cmd.CommandText = "udpate mytable set c2 = 'update' where id = 1";

    if (cmd.ExecuteNonQuery() > 0)
        Console.WriteLine("Update successful!");
    else
        Console.WriteLine("Update failed!");

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