Top "Oledbcommand" questions

OleDbConnection - ExecuteNonQuery requires an open and available Connection. The connection's current state is closed

What am I doing wrong here? using System.Data; using System.Data.OleDb; namespace myProject.Account { public class DbManager { private …

c# oledbconnection oledbcommand

OleDbParameters and Parameter Names

I have an SQL statement that I'm executing through OleDb, the statement is something like this: INSERT INTO mytable (name, …

c# .net oledb oledbcommand oledbparameter

Undefined function 'Replace' in expression , Replace alternative?

as read in this question : Undefined function 'Replace' in expression , I'm getting the error "Undefined function 'Replace' in expression" because "…

c# sql ms-access oledbcommand

Storing an image into an Attachment field in an Access database

I'm writing a VB application where I need to store an image in the database. The user selects the image …

database vb.net attachment oledbcommand ms-access-2013

Export into excel file without headers c# using Oledb

I'm using OleDB and I want to export my objects into excel table. Each row in the sheet will be …

c# oledb oledbconnection oledbcommand

Importing from Excel - Header is not on row 1

Is there some simple way I am missing to import an Excel worksheet into a datatable using an OleDBConnection and …

c# asp.net import-from-excel oledbcommand

Alias parameters in SSIS

I am using an OLE DB command in SSIS for which the SQL command looks like this: UPDATE DBO.CLIENT …

sql sql-server ssis alias oledbcommand