ComponentOne Studio - Cloud Business App Edition
Connect to a SQLServer Database

This topic demonstrates how to connect a screen to a SQL Server Database.

Complete the following steps:

  1. In Solution Explorer, right click Data Sources folder.
  2. Select Add Data Sources. The Attach Data Source Wizard appears.
  3. In the Choose a data Source Type page, click Database, and then click Next.
  4. The Choose Data Source dialog box appears, click Microsoft SQL Server, and then click Continue.

  5. In the Server name box of the Connection Properties dialog box, enter the name of the SQL Server instance that you want to connect to.
  6. If your database is set up to use Windows authentication, click Use Windows Authentication. Otherwise, click Use SQL Server Authentication, and then enter user name and password to access database.
  7. Click Select or enter a database name. Then, in the drop-down list, select or enter the name of the database that you want to connect to, and then click OK. The Choose Your Database Objects page appears.
  8. In the Choose Your Database Objects page, select the tables and views that you want to use in your project, and then click Finish.
  9. The database, tables, and views that you selected appear in Solution Explorer as sub nodes of the Data Sources node.
See Also

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Documentation Feedback  |  Product Support Forum