C#

mbangh wrote:

I have a listview control

case DbType.Int64:
case DbType.UInt64:
    this._sql.Bind_Int64(this, index, Convert.ToInt64(obj2, CultureInfo.CurrentCulture));
    return;

using (var cmd = conn.CreateCommand()) {
    cmd.CommandText = "insert into tt (text, Value) values (@text, @tt)";
    cmd.Parameters.AddWithValue("@text", value.ToString());
    cmd.Parameters.AddWithValue("@tt", (long)value).DbType = DbType.UInt64;
    cmd.ExecuteNonQuery();
}

using (var cmd = conn.CreateCommand()) {
    cmd.CommandText = "select Value from tt order by Value desc";
    var reader = cmd.ExecuteReader();
    while (reader.Read()) {
        long l = (long) reader[0];
        Console.WriteLine(*((ulong*)&l));
    }
    reader.Close();
    cmd.ExecuteScalar();
}

CREATE TABLE "tt" (
    "ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    "Text" TEXT NOT NULL,
    "Value" UNSIGNED BIG INT NOT NULL
)

select * from tt where value = 18446744073709551614

using (var cmd = conn.CreateCommand()) {
    cmd.CommandText = "select * from tt where value = @val";
    cmd.Parameters.AddWithValue("@val", (long)18446744073709551614ul).DbType = DbType.UInt64;
    var reader = cmd.ExecuteReader(); 
    ...
}