Questions tagged as 'oledb'

Tagged questions
3
answers

What are providers? What is the difference between OLE DB and ODBC?

I need to read dbf files. I found a tutorial to read the same where the author uses these two providers. In the code I only saw differences in the connection string. What are these providers? What's the difference between them?     
asked by 25.06.2014 / 17:56
2
answers

How to check the name of the Excel C #

How to check the name of the "Sheet" of the Excel worksheet before performing the% pro SQL ? My code so far: protected void btnProcessar_Click(object sender, EventArgs e) { string path = Server.MapPath(".") + "\" + FileUp...
asked by 15.08.2016 / 18:32
1
answer

Select columns with no specific name

I'm 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, ColunaGenerica2 FROM ["+ planilha +"]";...
asked by 09.02.2018 / 13:21
1
answer

Wpf C # OledbParameters Update where select

I am trying to change a query to use parameters but when I execute using parameter I get the error "Data type mismatch in criteria expression." No parameters works normally. Follow the two queries . cmd = new OleDbCommand("UPDATE tblPen...
asked by 23.12.2016 / 16:21
2
answers

Update OLEDB Not working

Good afternoon, I'm trying to update an excel worksheet but the command is not changing any values, it's just corrupting the worksheet. I create the last two columns and rewrite the other connection.ConnectionString = "Provider=Microsoft.AC...
asked by 02.02.2018 / 18:12
3
answers

Execute DELETE only when returning SELECT

I have a routine where I update the local database with data from another database. I simply run a DELETE and then INSERT INTO tblX (SELECT * FROM tblY (tblY is a linked table)) , as below. The problem is that there is a time between DE...
asked by 25.04.2017 / 00:24
2
answers

Fields Currency 1,99 saving as 199 in Access

I'm having a problem when I'm going to save the data from currency or decimal fields to an Access database using the Visual Studio components. When saving something of type 1.99m or has 1,99 in textbox the data goe...
asked by 23.08.2014 / 16:40
1
answer

How to list all names of Access tables?

Hi, I'm wanting to display the names of the tables that are inside the Access file and play for a variable. How can I do this? Does the C # platform itself provide attributes so I can do this? I am using the System.Data.OleDb reference . Bel...
asked by 29.07.2018 / 23:12
1
answer

How do you use the UPDATE command more than once? [duplicate]

I can not use the UPDATE command more than once. For example, when I perform the update at id 43, that's fine. But when I try to finish 44, it does not finish, but the 43 that gets the update .. Code: Int att,index; Private vo...
asked by 23.05.2018 / 16:03
1
answer

C # Oledb truncating column excel

I'm doing a select in an excel where I have an observation column (open text). The problem is that on some lines it truncates the contents of that column by bringing only one part. try { conn = new OleDbConnection("Provider=Microsoft.ACE.O...
asked by 10.04.2017 / 22:40