I’ve been asked to post a sample on how to use an oledb module to perform discovery. The scenario applies everytime you have to be managed entities listed in a generic OLEDB table. 1,990 more words
Tags » Oledb
ADO.NET interview questions: - Explain in detail the fundamental of connection pooling and how to enable/disable connection pooling?
When a connection is opened first time, a connection pool is created and is based on the exact match of the connection string given to create the connection object. 198 more words
If you’re happily running MS SQL Server 2012 on Windows Server 2012 Core, but you need to install the Microsoft OLE DB Provider for DB2 Version 4.0, that smile won’t last long. 210 more words
This code will read Ms. Excel File (.xls and .xlsx) and import to DataTable.
Import this references
String FileLocation = "file.xlsx"; OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FileLocation + "; Extended Properties=Excel 12.0;"); OleDbCommand cmd = new OleDbCommand("select * from ", con); con.Open(); OleDbDataAdapter adp = new OleDbDataAdapter(cmd); DataTable dt = new DataTable(); adp.Fill(dt); con.Close();