Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | BinaryInsert test modified to use ampersand parameters |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | sourceforge |
| Files: | files | file ages | folders |
| SHA1: |
58a81d6326bc6f40b1581ade673e1698 |
| User & Date: | rmsimpson 2005-11-21 16:30:33 |
Context
|
2005-11-22
| ||
| 14:53 | no message check-in: bd09265a2c user: rmsimpson tags: sourceforge | |
|
2005-11-21
| ||
| 16:30 | BinaryInsert test modified to use ampersand parameters check-in: 58a81d6326 user: rmsimpson tags: sourceforge | |
| 16:30 | Added more ISO8601 datetimes check-in: c16bb7e835 user: rmsimpson tags: sourceforge | |
Changes
Changes to test/TestCases.cs.
238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 |
cmd.Parameters.Add(Field4);
cmd.Parameters.Add(Field5);
cmd.ExecuteNonQuery();
}
}
internal static void BinaryInsert(DbConnection cnn)
{
using (DbCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = "INSERT INTO TestCase(Field6) VALUES($bin)";
DbParameter Field6 = cmd.CreateParameter();
byte[] b = new byte[4000];
b[0] = 1;
b[100] = 2;
b[1000] = 3;
b[2000] = 4;
b[3000] = 5;
Field6.ParameterName = "$bin";
Field6.Value = b;
cmd.Parameters.Add(Field6);
cmd.ExecuteNonQuery();
}
}
|
> | | |
238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 |
cmd.Parameters.Add(Field4);
cmd.Parameters.Add(Field5);
cmd.ExecuteNonQuery();
}
}
// Inserts binary data into the database using a named parameter
internal static void BinaryInsert(DbConnection cnn)
{
using (DbCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = "INSERT INTO TestCase(Field6) VALUES(@bin)";
DbParameter Field6 = cmd.CreateParameter();
byte[] b = new byte[4000];
b[0] = 1;
b[100] = 2;
b[1000] = 3;
b[2000] = 4;
b[3000] = 5;
Field6.ParameterName = "@bin";
Field6.Value = b;
cmd.Parameters.Add(Field6);
cmd.ExecuteNonQuery();
}
}
|