Stack Overflow
Stack Overflow

Questions tagged [oledbdataadapter]

OleDbDataAdapter is a part of the ADO.NET Data Provider and it resides in the System.Data.OleDb namespace.

OleDbDataAdapter provides the communication between the Dataset and the OleDb Data Sources. We can use OleDbDataAdapter Object in combination with Dataset Object.

The OleDbDataAdapter Object and DataSet objects are combined to perform both Data Access and Data Manipulation operations in the OleDb Data Sources. When the user performs the SQL operations like Select, Insert etc. in the data containing in the Dataset Object, it won't directly affect the Database, until the user invoke the Update method in the OleDbDataAdapter.

213 questions
2
votes
3 answers

Using an OleDbDataAdapter on a background thread causes my UI to not update correctly?

I have an app where users can select an Excel file, that excel file is read using an OleDbDataAdapter on another thread, and once it is finished being read it updates the CanExecute property of a Command in my ViewModel to true so the Save button is…
Rachel
  • 130,264
  • 66
  • 304
  • 490
2
votes
5 answers

How to sort 30Million csv records in Powershell

I am using oledbconnection to sort the first column of csv file. Oledb connection is executed up to 9 million records within 6 min duration successfully. But when am executing 10 million records, getting following alert message. Exception calling…
Ritthisha S
  • 113
  • 1
  • 9
2
votes
1 answer

How do I use prepared statements with an OleDbDataAdapter?

I'm writing an API that will query a database given certain parameters. Some of those parameters will be supplied by the calling app (which should be trustworthy), but some of them will be supplied from user input. If I were getting a small number…
GreySage
  • 1,153
  • 19
  • 39
2
votes
1 answer

How to Mock OleDbDataAdapter(query, connStr)

How can i mock OleDbDataAdapter(query, conn) in FilledDataInDataTable function? Can i? I have no idea how i do with dependency from query and connection string parameters. Public Class DataTableOfDataFromExportCSV Private _adp As…
Pat Zidane
  • 23
  • 4
2
votes
4 answers

OleDbDataAdapter and column casting while importing Excel to ASP.NET

I'm importing an excel using c#. But CustomerOrderNR column contains these kind values: 20283 20213 20625 50749-50 30687 31975 82253 But when I execute these codes: string QTam = @"SELECT Date, [Serial Number], [Status Code], Description,…
uzay95
  • 16,052
  • 31
  • 116
  • 182
2
votes
3 answers

Data adapter troubles

When I run the code the line which filled my datatable says that there is no value given for one or more parameters Order = New OleDb.OleDbDataAdapter("SELECT * FROM Orders WHERE Driver_ID = " & ID,…
the real swifty
  • 29
  • 5
2
votes
0 answers

OleDb Command for CSV with Date in FileName causes Microsoft Jet database engine could not find the object

One of my customers has found a problem and I am quietly confident it is a bug, but I can't find any official documentation. The error is: The Microsoft Jet database engine could not find the object 'Trades 23.11.177.csv' Here is the code to…
Jeremy Thompson
  • 61,933
  • 36
  • 195
  • 321
2
votes
1 answer

Initialization String Error in SSIS using Biml and c#

I'm trying to import some Config Datatable to execute a dynamic Staging with SSIS, BIML and C#. In the end I want to initialize the table ImportTable to build me a staging environment in SSIS. It throws me the following error: "Format of the…
Nico Shabadoo
  • 95
  • 6
2
votes
1 answer

OleDbDataAdapter throwing AccessViolationException when using statment including a Join

I have an old piece of code that has been working until last week. It uses a OleDb helper class to query a MS Access database. I've been able to pin point the error the a specific query. After a little experimentation, I can confirm that when the…
Red Gordon
  • 43
  • 9
2
votes
1 answer

Quirky SELECT from Excel file via OleDbDataAdapter method (C#)

I have got an Excel file in this form : Column 1 Column 2 Column 3 data1 data2 data1 data2 data1 data2 data1 data2 data1 data2 data3 That is, the whole Column 3 is empty except for…
SimoneF
  • 432
  • 1
  • 3
  • 15
2
votes
1 answer

Problems reading all the lines of an excel with OLEDB and C#

I am developing a program to import excel spreadsheets with C # language, using the OLEDB component, when importing a spreadsheet with 100547 rows the program can only read 54046. Follows the source code: public class ReadExcel { public…
Pedro Pagotto
  • 31
  • 5
2
votes
2 answers

OleDbCommand syntax error 0x80040E14 in SELECT Statement

This query runs perfectly in Access 2010: SELECT te.[EnterpirseName], COUNT(to.[ID]) AS Orgs, SUM(to.[Members]) AS Mems FROM tbl_Enterprise AS te, tbl_Organizations AS to WHERE to.[Enterprise_ID] = te.[ID] AND te.[Status] = 1 GROUP BY…
firefalcon
  • 500
  • 2
  • 8
  • 21
2
votes
1 answer

Reading columns from Excel, reformat cells

I am currently trying to read in cells from an excel spread sheet, and it seems to reformat cells when I don't want it to. I want it to come through as plan text. I have read a couple of solutions to this problem and I have implemented them, but I…
Sari Rahal
  • 1,897
  • 2
  • 32
  • 53
2
votes
1 answer

OleDbDataAdapter does not insert Datatable in access table

I have record in sql server table . I am filling all record in DataTable from sql server and after i want to insert all record in access table. But no data inserting and no error occured on inserting time. Please provide need help public bool…
user4667380
  • 61
  • 10
2
votes
1 answer

Export to Excel .xlsx File

I' m trying to export xlsx file with these codes: OleDbDataAdapter adapter = new OleDbDataAdapter(select, accessConnection); adapter.Update(dataTable); The connection string is Provider=Microsoft.ACE.OLEDB.12.0;Data…
Anil Kocabiyik
  • 1,178
  • 6
  • 17
  • 47
1
2
3
…
14 15