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); }