oledb

相关标签：javascript jquery android 多少钱 iPhone

retrieve the autonumber in sqldatasource after the insert operation

In my asp.net application,I want to use the detailsview to show/insert/update data in the db. After read the docs:[详细]

2023-03-13 21:28 分类：问答
OleDbDataAdapter can't fill dataset from access table that has MEMO field

I am trying to fill a dataset by OleDbDataAdapter from MS Access DB table. All columns are fine except the MEMO column. it is truncating after 256 character.[详细]

2023-03-13 14:48 分类：问答
Undefined function 'Replace' in expression

I am having a VB.Net application. I connect it with a MS Access database. Now I have to execute a query. My query is : Update table1 set field1=replace(fie开发者_开发知识库ld1,\'|\',\'\"\')[详细]

2023-03-12 13:42 分类：问答
OleDbAdapter reading column data

I have created a function to read an excel sheet using OLEDb. I can make the connection and read the excel sheet.[详细]

2023-03-12 10:08 分类：问答
OleDbDataAdapter datatype mismatch using Jet

I\'m using an OleDbDataAdapter (Microsoft.ACE.OLEDB.12.0 to be precise) to retrieve data from an Excel workbook. For one table I\'m using a typed dataset but for another table I can\'t do that since t[详细]

2023-03-11 21:06 分类：问答
Excel Jet OLE DB: Inserting a DateTime value

OLEDB can be used to read and write Excel sheets. Consider the following code example: using (OleDbConnection conn = new OleDbConnection(\"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\\\my\\\\exc[详细]

2023-03-10 13:21 分类：问答
Excel OLEDB /Jet connection strings & %APPDATA%

I have what is likely a common scenario. I have an MS-Access application split into front-end and back-end files. I want to set up us开发者_运维知识库ers with an Excel spreadsheet that connects to dat[详细]

2023-03-09 08:14 分类：问答
OLEDB Inserting a row in excel before the header columns of create table

I am using oledb to create excel sheets. I use create table to create a excel sheet. This creates a new sheet, as well as add the column names in first row of the sheet.[详细]

2023-03-08 06:52 分类：问答
Is there a database connection library out there that will handle multiple types of DB connections and operations (i.e. OleDb, SQLite, ADO, etc)?

What I have is an Access database that we are working on, but we need to convert it to SQLite and send it to another client while keeping the code working for the Access database as well for all other[详细]

2023-03-07 20:01 分类：问答
Using EXCEL as datasource through Microsoft OLE DB provider

We are frequently using some Excel files as a datasource for massive imports in our database. At the code level, we always refer to the corresponding data source as:[详细]

2023-03-07 15:32 分类：问答