Questions tagged as 'oledb'

Tagged questions
0
answers

How to add Microsoft.ACE.OLEDB.12.0 to the installer of my .NET application?

Hello, I have an application that I programmed through Visual Studio 2017 that uses Microsoft.ACE.OLEDB.12.0 to query Excel files and return data. Now that I finished the project I had to publish. But when you install the application on a mac...
asked by 19.07.2018 / 19:30
0
answers

How to get Excel formula in C # using OleDb?

I need to get the formula contained in an Excel cell. I'm using OleDb to access the spreadsheet, would you like to know if you have how to use it to access the formula of a cell?     
asked by 05.06.2018 / 19:41
1
answer

Problems reading all the rows of an Excel with OLEDB and C #

I am developing a program to import Excel spreadsheets with language C# , using the OLEDB component, when importing a spreadsheet with 100547 rows the program can only read 54046. Here is the source code: public class Re...
asked by 29.03.2017 / 19:16
2
answers

Persistent error in C # database

I was doing a project but there was a problem involving OleDbCommand occurring in two different places: dr_alu = _dataCommand.ExecuteReader(); if (dr_alu.HasRows == true) dr_reg_notas = _dataCommand.ExecuteReader();...
asked by 11.08.2017 / 02:15
1
answer

Error executing select with alias

When executing the query below using AT instead of "T" as a join alias, the following error is returned: "IErrorInfo.GetDescription failed with E_FAIL (0x80004005). " OleDbDataAdapter da = new OleDbDataAdapter("SELECT A.*, " +...
asked by 04.10.2017 / 23:08
1
answer

Problems working with dates in the database using a maskedtextbox in the format dd / MM / yyyy

I'm using a MaskedTextBox in the en-BR culture to force the user to fill the date in the correct format (dd / mm / yyyy). Retrieve the string from the MaskedTextBox to insert into the database and record information containing the date of this i...
asked by 07.03.2016 / 21:20
2
answers

I am having difficulty returning my ID using nextval, to later insert it into my table

I'm having trouble returning my ID using nextval, and then inserting it into my table OleDbConnection cnx = new OleDbConnection(new AdministradorDAO().conexao); cnx.Open(); string seq = ("select id_usuarios.nextval from dual");...
asked by 16.09.2014 / 14:21
1
answer

How to fill combobox with SQL query? W#

I would like to know if it is possible to pass data from an SQL query to a combobox using C #. I researched the subject and found examples, but when I adapted to my case, I could not use it. I'm doing it this way: private void carregacombo() {...
asked by 10.10.2018 / 04:21