![]() XpoProvider= Amazon Redshift Server=127.0.0.1 User ID=MyUserName Password=MyPassword Database=MyDatabase Encoding=UNICODE XpoProvider= ODPManaged Data Source=TORCL User ID=MyUserName Password=MyPassword XpoProvider= ODP Data Source=TORCL User ID=MyUserName Password=MyPassword XpoProvider= Oracle Data Source=TORCL User ID=MyUserName Password=MyPassword XpoProvider= MSSqlServerCE Data Source=MyDatabase.sdf Password=MyPassword XpoProvider= MSAccess Provider=.12.0 Data Source=C:\mydatabase.accdb User Id=admin Password= XpoProvider= MSAccess Provider=.4.0 Data Source=C:\mydatabase.mdb User Id=admin Password= XpoProvider= MSSqlServer Data Source=(local) User ID=username Password=password Initial Catalog=database Persist Security Info=true See connection string examples in the table below. When you construct a connection string manually (see CustomStringConnectionParameters), use the XpoProvider parameter to identify the provider type. Only legacy SQL functions and operations are supported The SqlDataSource component supports the following data providers: If you bind an XtraReport to a data source that does not support the schema-only mode, call the data source’s Fill method before you call IReportPrintTool.ShowPreview. Ensure that your application references the 22.2.UI.dll assembly to access this class. Use the SqlDataSourceUIHelper class methods to configure a data connection in code. If you bind an XtraReport to an SqlDataSource, the Fill method is called when a report document is generated by the XtraReport.CreateDocument or IReportPrintTool.ShowPreview method. To view an example, see the following help topic: Binding to SQL Data. Call the SqlDataSource.Fill method to populate the data sources of these controls. To view a code example, see the following help topic: Bind a Report to a Microsoft SQL Server Database (Runtime Sample).Ĭorresponds to the SqlDataConnection.GetDBSchema method, which returns the database schema from the server and updates the schema on the client.Ĭertain controls (for instance, the GridControl) do not retrieve data when bound to the SqlDataSource component. When you use an SqlDataSource to bind an XtraReport to data, call the RebuildResultSchema method to update the data source structure in the End-User Report Designer’s Field List. This command does not affect the actual database schema on the server. Use the SqlDataSource.Result property to access the schema. The following image illustrates the Master-Detail Relation Editor.Ĭorresponds to the SqlDataSource.RebuildResultSchema method, which updates the result schema on the client side after the query is executed. This command is available when there are two or more queries in the collection. The following image illustrates the Manage Queries dialog.Ĭorresponds to the SqlDataSource.Relations property, which gives access to the data relations collection. To modify the data source, expand the SqlDataSource‘s smart tag.Ĭorresponds to the SqlDataSource.ConfigureDataConnection method that invokes the Connection Editor.Ĭorresponds to the SqlDataSource.Queries property, which provides access to the queries collection. Follow the Wizard pages to set up a connection. 22.2: Data
0 Comments
Leave a Reply. |