Most voted "oledb" questions
OLE DB is an API developed by Microsoft based on COM.
Learn more…27 questions
Sort by count of
-
16
votes3
answers6549
viewsWhat are providers? What is the difference between OLE DB and ODBC?
I need to read files dbf. I found a tutorial to read the same where the author uses these two providers. I only saw differences in the connection string. What are these providers? What is the…
-
4
votes1
answer903
viewsC# Read Excel Spreadsheet
Hello, I have 1 problem reading an excel spreadsheet, ListaNomes.Add(new Entidades() { GrupoFornecParceiro = rd["Grupo do Fornec./Parceiro+"].ToString() }); when it goes to Add the value of the…
-
4
votes1
answer2127
viewsHow to add Microsoft.ACE.OLEDB.12. 0 to my app’s installer . NET?
Hi, I have an app that I programmed through Visual Studio 2017 using the Microsoft.ACE.OLEDB.12.0 to consult on files Excel and return data. Now that I finished the project I had to publish. But…
-
3
votes2
answers1413
viewsHow to verify which is the name of the spreadsheet tab Excel C#
How to verify what is the name of the "Tab" (Sheet$) of the Excel spreadsheet before performing the import pro SQL ? My code so far: protected void btnProcessar_Click(object sender, EventArgs e) {…
-
3
votes1
answer74
viewsQuery search C# Oledb
In the program I am working on, I have made a data search form, where the name entered will be searched in the database and will return next results (Search screen) The problem is that the query…
-
2
votes1
answer52
viewsWpf C# Oledbparameters Update Where select
I’m trying to change a query to use Parameters but when running using Parameter I get the "Data type Mismatch in criteria Expression" error. Without Parameters works normally. Follow the two…
-
2
votes1
answer371
viewsSelect columns with no specific name
I am developing a C# application that consumes data from a spreadsheet and at some point I need a query string that will feed a variable. For example: strComando1 = "SELECT TOP 2 ColunaGenerica1,…
-
2
votes2
answers211
views -
1
votes2
answers223
viewsCurrency fields 1.99 saving as 199 on Access
I have a problem when I go to save the data of fields currency or decimal in an Access database using Visual Studio components. When I save something like 1.99m or has 1,99 in the textbox the data…
-
1
votes1
answer535
viewsProblems reading all lines of an Excel with OLEDB and C#
I am developing a program to import spreadsheets Excel with language C#, using the component OLEDB, when importing a spreadsheet with 100547 lines the program can only read 54046. Follow the source…
-
1
votes1
answer86
views -
1
votes0
answers60
viewsHow to get Excel formula in C# using Oledb?
I need to get the formula contained in an Excel cell. I am using Oledb to access the spreadsheet, I wonder if you have how to use it to access the formula of a cell?
-
1
votes3
answers190
viewsRun DELETE only when you return SELECT
I have a routine where I update the local database with the data from another database. I simply execute a DELETE and then a INSERT INTO tblX (SELECT * FROM tblY (tblY is a linked table)), as below.…
-
1
votes1
answer105
viewsHow do you use the UPDATE command more than once?
I cannot use the UPDATE command more than once. For example, when I do the update on id 43, sure. But when I try to finish 44, it does not finish, but 43 that gets the update.. Code: Int att,index;…
-
1
votes1
answer861
viewsHow to list all Access table names?
Hi, I’m wanting to display the table names that are inside the Access file and play for a variable. How can I do this? Does the C# platform itself provide attributes for me to do this? I’m using the…
-
1
votes0
answers17
viewsOledb does not work on other machines
I made a WPF application and at some point it should read an Excel file. I did this through Oledb. The file is in the same application folder. The application works perfectly with me but does not…
-
0
votes2
answers336
viewsI’m having difficulty returning my ID using nextval, to later do the Insert in my table
I’m having difficulty returning my ID using nextval, to later do the Insert in my table OleDbConnection cnx = new OleDbConnection(new AdministradorDAO().conexao); cnx.Open(); string seq = ("select…
-
0
votes1
answer43
viewsError when executing select with alias
When executing the query below using "AT" in place of "T" as alias of Join is returned the following error: "Ierrorinfo.Getdescription failed with E_FAIL(0x80004005)." OleDbDataAdapter da = new…
-
0
votes1
answer644
viewsProblems when working with dates in the database using a maskedtextbox in dd/MM/yyyy format
I am using a Maskedtextbox in BR culture to force the user to fill in the date in the correct format (dd/MM/yyyy). I remove the Maskedtextbox string to insert into the database and record…
-
0
votes2
answers44
viewsPersistent 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 =…
-
0
votes2
answers131
viewsUpdate OLEDB Not working
Good afternoon, I am trying to update an excel spreadsheet but the command is not changing any value, it is only corrupting the spreadsheet. I create the last two columns and rewrite the rest…
-
0
votes0
answers55
views -
0
votes1
answer226
viewsHow to fill out combobox with SQL query? C#
I wonder 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. I am doing this way:…
-
0
votes1
answer17
viewsReportviewer deleting data from Access database
I recently added Reportviewer to my Visual Studio 2015 Community for creating and printing reports. My database already contained information, added before adding Reportviewer. I am currently 4…
-
0
votes2
answers192
viewsSeparate COM object from adjacent RCW
In this Try-catch occurs the following error message: The code: try { dbConnection.Open(); cmdQry.CommandText = "SELECT * FROM tbl_ItensEmbaOrdem WHERE idOrdem=?"; cmdQry.Parameters.Clear();…
-
0
votes1
answer200
viewsUndefined object reference for an object instance. '
Hello, In my code there is this error System.Nullreferenceexception: 'Undefined object reference for an instance of an object.', _oleCmd was null. How do I fix it? (I’m a C beginner#) using System;…
-
0
votes1
answer56
viewsHow to query Data values on a C# connection to excel using Oledb?
Follow below the line of code private void button7_Click(object sender, EventArgs e) { string conex = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + textBox1.Text + ";Extended Properties=\"Excel…