Help Online

By: Forthright Solutions  09-12-2011
Keywords: SQL Server, SQL

There is a 14 page document with more details, available for download by customers.  In brief:

1.  Note that the Demo version of the software available on this site is restricted to one database and only tables that start with the letters B, C, or D. 

3.  You must know your own connection information (not for the Demo - we'll take care of that). This includes the SQL Server name and the SQL User name and password that allow read access, or update if you choose to "Run" the stored procs right from this new tool.

4.  Start by creating all 5 stored procedures for a selected SQL table.  Adjust the Stored Procedure name before generating.  The View button will allow you to review generated stored procedures (when switching the radio at left).  We anticipate that you will want to either Run the procs into SQL or use the Copy/ Paste into Query Analyser for final completion (such as Joins for Select procs). If you want to change the SP text generated then paste into Query Analyzer, as the Run button will only load the SP generated (for security reasons).

5.  Use the Previous button to go back to indicate that you want to build the DAL Information Class.

6.  Returning once again to indicate you want to create the rest of the DAL, will bring you to a new page where the system will have remembered the Stored Proc names you created. 

Keywords: SQL, SQL Server

Contact Forthright Solutions


Print this page

Other products and services from Forthright Solutions



Web portal and application developments for Internet and custom Intranets and Rich Internet Applications via Silverlight. We are TEST primarily involved with contract and consulting services based on Microsoft development technologies. MSF is a set of guiding principles for project management and a suite of best practice models. Applications via Microsoft development tools, including Visual Studio .NET 3.5, 4.0.



Allows integration, communication and sharing of files, drawings and project financial data across multiple offices or site locations using a private intranet. Having delivered several custom project management solutions, we offer a "quick start template", called iPCM, as a starting point for other custom solutions. IPCM is an intranet Project Management portal for sharing project cost information via the internet.



In no event shall Forthright Solutions or its distributors be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or any other financial loss) arising out of the use of or inability to use this Forthright Solutions product and related materials.