C#

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Text;


namespace Framework.Dal
{
    /// <summary>
    /// Result of the database connection and execution of SQL statements.
    /// </summary>
    public static class DBResult
    {
        //enums
        /** <summary>Status of the execution of the Query or Stored Procedure.</summary>*/
        public enum DB_STATUS
        {
            /** <summary>Undefined Status.</summary>*/
            UNDEFINED = 0,
            /** <summary>Connection with the database failed.</summary>*/
            CONNECTION_FAILED = 1,
            /** <summary>Connection with the database was OK.</summary>*/
            CONNECTION_OK = 2,
            /** <summary>The execution of the statement failed.</summary>*/
            EXECUTE_FAILED = 3,
            /** <summary>The execution of the statement was succesful.</summary>*/
            EXECUTE_OK = 4,
        }													//end enum DB_STATUS
    }														//end class DB_STATUS

    /// <summary>
    /// Interface for SQL, OleDb and Odbc database connections.
    /// </summary>
    public interface IDataBaseConnector
    {

        /// <summary>
        /// Sets the connectionstring for the database connection.
        /// </summary>
        /// <param name="connection_string">The connection string.</param>
        void SetConnection_String(string connection_string);

        /// <summary>
        /// Tests the database connection.
        /// </summary>
        /// <returns>true if connection is available.</returns>
        bool TestConnection();

        /// <summary>
        /// Executes a select statement.
        /// </summary>
        /// <param name="stmnt">The select statement to execute.</param>
        /// <returns>An integer equal to the DB_STATUS enumeration.</returns>
        DBResult.DB_STATUS ExecuteSelect(string stmnt);

		/// <summary>
		/// Executes a select statement by using parameters to prevent SQL-Injection.
		/// </summary>
		/// <param name="command">The select statement to execute.</param>
		/// <param name="paramnames">The object array to be used for the parameters.</param>
		/// <param name="paramvals">The object array to be used for the parameters.</param>
		/// <returns>An enumeration indicating the success/failure</returns>
        DBResult.DB_STATUS ExecuteSelectSafe(string command, string[] paramnames, object[] paramvals);

        /// <summary>
        /// Executes an update statement.
        /// </summary>
        /// <param name="stmnt">The update statement to execute.</param>
        /// <returns>An integer equal to the DB_STATUS enumeration.</returns>
        DBResult.DB_STATUS ExecuteUpdate(string stmnt);

		/// <summary>
		/// Executes an update statement by using parameters to prevent SQL-Injection.
		/// </summary>
		/// <param name="command">The update statement to execute.</param>
		/// <param name="paramnames">The string array to be used for the parameter namess.</param>
		/// <param name="paramvals">The object array to be used for the parameter values.</param>
		/// <returns>An Enum indicating Succes/Failure</returns>
        DBResult.DB_STATUS ExecuteUpdateSafe(string command, string[] paramnames, object[] paramvals);


        /// <summary>
        /// Executes an Insert statement.
        /// </summary>
        /// <param name="stmnt">The insert statement to execute.</param>
        /// <returns>An integer equal to the DB_STATUS enumeration.</returns>
        DBResult.DB_STATUS ExecuteInsert(string stmnt);

		/// <summary>
		/// Executes an Insert statement by using parameters to prevent SQL-Injection.
		/// </summary>
		/// <param name="command">The insert statement to execute.</param>
		/// <param name="paramnames">The string array to be used for the parameter namess.</param>
		/// <param name="paramvals">The object array to be used for the parameter valuess.</param>
		/// <returns>An Enum value indicating success/failure</returns>
		DBResult.DB_STATUS ExecuteInsertSafe(string command, string [] paramnames, object [] paramvals);

        /// <summary>
        /// Executes a delete statement.
        /// </summary>
        /// <param name="stmnt">The delete statement to execute.</param>
        /// <returns>An integer equal to the DB_STATUS enumeration.</returns>
        DBResult.DB_STATUS ExecuteDelete(string stmnt);

		/// <summary>
		/// Executes a delete statement by using parameters to prevent SQL-Injection.
		/// </summary>
		/// <param name="command">The delete statement to execute.</param>
		/// <param name="paramnames">The object array to be used for the parameter names.</param>
		/// <param name="paramvals">The object array to be used for the parameter values.</param>
		/// <returns>An Enum value indicating success/failure</returns>
        DBResult.DB_STATUS ExecuteDeleteSafe(string command, string[] paramnames, object[] paramvals);

        /// <summary>
        /// Executes a stored procedure.
        /// </summary>
        /// <param name="sp_name">The name of the stored procedure.</param>
        /// <param name="param_names">An array with the names of the parameters.</param>
        /// <param name="param_values">An array with the values of the parameters.</param>
        /// <returns>An integer equal to the DB_STATUS enumeration.</returns>
        DBResult.DB_STATUS ExecuteStoredProcedure(string sp_name, ArrayList param_names, ArrayList param_values);

        /// <summary>
        /// Executes a non-query.
        /// </summary>
        /// <param name="stmnt">The statement to execute.</param>
        /// <returns>An integer equal to the DB_STATUS enumeration.</returns>
        DBResult.DB_STATUS ExecuteNonQuery(string stmnt);

        /// <summary>
        /// Gets the dataset of the last succesfull ExecuteSelect call.
        /// </summary>
        /// <returns>The dataset</returns>
        DataSet GetDataSet();

        /// <summary>
        /// Gets a friendly error message of the last occurred error.
        /// </summary>
        /// <returns></returns>
        string GetLastErrorMessage();

        /// <summary>
        /// Returns the tables of the database.
        /// </summary>
        /// <returns>A string containing all the tablenames.</returns>
        string[] GetTables();

        /// <summary>
        /// Returns column information of a table.
        /// </summary>
        /// <param name="tablename">The tablename for which you want the columninformation.</param>
        /// <returns>A DataColumnCollection containing all necessary information about the columns.</returns>
        DataColumnCollection GetColumnInformation(string tablename);

        /// <summary>
        /// Gets the number of rows that where affected by a previous statement.
        /// </summary>
        /// <returns>the number of rows affected.</returns>
        int GetNrOfRowsAffected();
    }														//end interface IDataBaseConnector
}															//end namespace DatabaseTools

EnumDelegate delEnumfunc = new EnumDelegate(EnumWindowsProc);
IntPtr DesktopWindow = GetDesktopWindow();
bool bSuccessful = EnumDesktopWindows(hdesk, delEnumfunc, DesktopWindow);

var bounds = Screen.GetBounds(Point.Empty);

Trak4Net wrote:

I am not an accountant nor have I ever worked on any accounting software, but I have dealt with database applications a lot. Your suggested records per year of 50-80K will definitely not be an issue for a database table on platforms like MySQL or MSSQL or Oracle or the likes, unless you are running wide open queries such as (select * from table) without any filter or limitation on rows returned.

Database design can become complicated if you want a very efficient means of storing your data. You may look over your required data several times and see if there are relations to break out into separate tables as much as possible and use primary keys, foreign keys and joins to bring your data together. Such as your "year" you could create a table that contains a primary key, year identifier and other year associated data and then that primary key would be a foreign key in your transaction table to match those transactions to that year etc.

 

Hopefully that kind of makes some sense and helps in some way.

queenB&S wrote:

but it doesn't work.

public void method()
{
// this code is within <pre> tags
}

using dll_namespace;