VOOZH about

URL: https://www.cdata.com/kb/tech/mongodb-ado-powerbuilder.rst

⇱ Connect to MongoDB Data from PowerBuilder via ADO.NET

Connect to MongoDB Data from PowerBuilder via ADO.NET

👁 Jerod Johnson
Jerod Johnson
Director, Technology Evangelism
This article demonstrates how to access MongoDB data from Appeon PowerBuilder using the CData ADO.NET Provider for MongoDB.

This article demonstrates using the CData ADO.NET Provider for MongoDB in PowerBuilder, showcasing the ease of use and compatibility of these standards-based controls across various platforms and development technologies that support Microsoft .NET, including Appeon PowerBuilder.

This article shows how to create a basic PowerBuilder application that uses the CData ADO.NET Provider for MongoDB to perform reads and writes.

About MongoDB Data Integration

Accessing and integrating live data from MongoDB has never been easier with CData. Customers rely on CData connectivity to:

MongoDB's flexibility means that it can be used as a transactional, operational, or analytical database. That means CData customers use our solutions to integrate their business data with MongoDB or integrate their MongoDB data with their data warehouse (or both). Customers also leverage our live connectivity options to analyze and report on MongoDB directly from their preferred tools, like Power BI and Tableau.

For more details on MongoDB use case and how CData enhances your MongoDB experience, check out our blog post: The Top 10 Real-World MongoDB Use Cases You Should Know in 2024.


Getting Started


  1. In a new WPF Window Application solution, add all the Visual Controls needed for the connection properties. Below is a typical connection string:

    Server=MyServer;Port=27017;Database=test;User=test;Password=Password;

    Set the Server, Database, User, and Password connection properties to connect to MongoDB. To access MongoDB collections as tables you can use automatic schema discovery or write your own schema definitions. Schemas are defined in .rsd files, which have a simple format. You can also execute free-form queries that are not tied to the schema.

  2. Add the DataGrid control from the .NET controls.
  3. Configure the columns of the DataGrid control. Below are several columns from the Account table: 
    <DataGrid AutoGenerateColumns="False" Margin="13,249,12,14" Name="datagrid1" TabIndex="70" ItemsSource="{Binding}">
<DataGrid.Columns>
 <DataGridTextColumn x:Name="idColumn" Binding="{Binding Path=_id}" Header="_id" Width="SizeToHeader" />
 <DataGridTextColumn x:Name="nameColumn" Binding="{Binding Path=borough}" Header="borough" Width="SizeToHeader" />
		...
	</DataGrid.Columns>
</DataGrid>
  4. Add a reference to the CData ADO.NET Provider for MongoDB assembly.

Connect the DataGrid

Once the visual elements have been configured, you can use standard ADO.NET objects like Connection, Command, and DataAdapter to populate a DataTable with the results of an SQL query: 

System.Data.CData.MongoDB.MongoDBConnection conn 
conn = create System.Data.CData.MongoDB.MongoDBConnection(connectionString)

System.Data.CData.MongoDB.MongoDBCommand comm 
comm = create System.Data.CData.MongoDB.MongoDBCommand(command, conn)

System.Data.DataTable table
table = create System.Data.DataTable

System.Data.CData.MongoDB.MongoDBDataAdapter dataAdapter
dataAdapter = create System.Data.CData.MongoDB.MongoDBDataAdapter(comm)
dataAdapter.Fill(table)	
datagrid1.ItemsSource=table.DefaultView

The code above can be used to bind data from the specified query to the DataGrid.