void _executeSelect(out SampleDbResultSet resultset)
{
// If no sample data exists, create it.
if (m_resultset == null)
{
_resultsetCreate();
}
// Return the sample results.
resultset = m_resultset;
}
void _executeUpdate(out SampleDbResultSet resultset)
{
// If no sample data exists, create it.
if (m_resultset == null)
{
_resultsetCreate();
}
// Change a row to simulate an update command.
m_resultset.data[2, 2] = 4199;
// Create a result set object that is empty except for the RecordsAffected field.
resultset = new SampleDbResultSet();
resultset.recordsAffected = 1;
}
public void Execute(string sCmd, out SampleDbResultSet resultset)
{
/*
* The sample code simulates SELECT and UPDATE operations.
*/
if (0 == string.Compare(sCmd, 0, SELECT_COMMAND, 0, SELECT_COMMAND.Length, true))
{
_executeSelect(out resultset);
}
else if (0 == string.Compare(sCmd, 0, UPDATE_COMMAND, 0, UPDATE_COMMAND.Length, true))
{
_executeUpdate(out resultset);
}
else
{
throw new NotSupportedException("Command string was not recognized");
}
}
void _resultsetCreate()
{
m_resultset = new SampleDbResultSet();
// RecordsAffected is always a zero value for a SELECT.
m_resultset.recordsAffected = 0;
const int numCols = 3;
m_resultset.metaData = new SampleDbResultSet.MetaData[numCols];
_resultsetFillColumn(0, "id", typeof(int), 0);
_resultsetFillColumn(1, "name", typeof(string), 64);
_resultsetFillColumn(2, "orderid", typeof(int), 0);
m_resultset.data = new object[5, numCols];
_resultsetFillRow(0, 1, "Biggs", 2001);
_resultsetFillRow(1, 2, "Brown", 2121);
_resultsetFillRow(2, 3, "Jones", 2543);
_resultsetFillRow(3, 4, "Smith", 2772);
_resultsetFillRow(4, 5, "Tyler", 3521);
}
