Report LinksWe do not store any files or images on our server. XenPaste only index and link to content provided by other non-affiliated sites. If your copyrighted material has been posted on XenPaste or if hyperlinks to your copyrighted material are returned through our search engine and you want this material removed, you must contact the owners of such sites where the files and images are stored.
CData ADO.NET Data Provider allows developers to easily connect .NET applications to Microsoft Excel, allowing Excel data to appear in your applications, such as sql tables. Developers can use CData ADO.NET Data Provider to connect data to data like a sql server. You can use Excel Data Provider through Visual Studio Explorer Server, classes and data controls such as DataGridView, GridView and DataSet.
Features of CData ADO.NET Data Provider:
Full .Net management: Full ADO.NET library support for .NET Framework 2.0 and above
Developer Friendly: Integrates with all versions of Visual Studio
Duplicate and save: Duplicate and save commands make it easy to copy data across Oracle, SQL Server, Google Cloud SQL, and Q
SQL string, date and numeric functions: Has a library of 50 functions that you can manipulate column values such as Regex, JSON, and XML
Easily customizable: add or remove columns and tables, change data types as needed to build new ones
Secure connection: Includes standard enterprise-class security features such as TLS / SSL data encryption for all client-server communications
Smart Storage: A customizable option that works by storing query data to a local database
Powerful ADO.NET Features: Support for ADO.NET Entity Framework (EF 5 & 6), ADO.NET 2.0 and LINQ to Datasets
Access Microsoft Excel data directly from Visual Studio Explorer Server
Configure the main connection to access Microsoft Excel account information