Hello, It seems like all of the classes that inherit DbDataAdapter also implement IDbDataAdapter. The problem is making a class that uses a generic DataAdapter requires both the DbDataAdapter and IDbDataAdapter. This means the class has to ask for either a DbDataAdapter and unbox to I...more >>

I need to return null for a date field. Here is what I am doing, but it isnt working. What am I doing wrong? private DateTime ArriveTime() { return (DBNull.Value); }...more >>

Hi all, I have been searching around in MSDN for awhile and found no answer for this question. Say I have two data sources (Table) where they have the same schema but perhaps w/ different data contained. Can I actually Merge (I tried the one in Dataset and no idea how it can be used in th...more >>

Following on from my previous post, I have another quick question (sorry!): I want to retrieve the records into a dataset. Is it possible to use a DataReader for this, or can it only be done with a DataAdapter? The reason for asking is that I only need to read the data into the dataset, not upd...more >>

I need to know if there is a way to say take ds1 and ds2 and put them into the same dataset where I can create a relationship and have a parent child relationship. I know this can be done by using the SqlDataAdapter and using the same dataset with the Fill method, but can it be done without doin...more >>

Hello, A quick question! I have an OleDbCommand object that executes the following parameter query: SELECT *, Abs(X-?) AS DeltaX FROM VALUES ORDER BY Abs(X-?) Although there are two parameters, they both represent the same value. Do I need to add two parameters to the Parameters collectio...more >>

I need a bit of clarification about keys in a .NET Framework Dataset. Keys are defined at the Dataset Level, not just within a DataTable within the DataSet. I guess that this means that keys need to be unique within the Dataset. I assume that this means that I can't have 2 keys in the same Dataset ...more >>

I want to use FOR XML in my query so I'm going to use the ExecuteXmlReader method? The trouble I'm having now is streaming the results to a string for output as an XML document. Also, since the XML that comes from teh query is not a complete document it's a fragment without a root element. So,...more >>

would someone please post an example of how this works? "Merges an array of DataRow objects into the current DataSet" from MSDN but an example would be great! TIA. ...more >>

The timeout expired period elapsed prior to completion of the operation or server is not responding. This is a message that I got so often in the webserver and in my test machine I try different groups I and I do not how to fix it. What happen is that the reports print ok several times and then the ...more >>

Hi, While connecting to a database and using ExecuteReader in my application, I am getting the following error: ************************************************** An Unhandled Exception of type 'System.InvalidOperation Exception' occurred in System.Data.dll ExecuteReader: Connection Property...more >>

I have a situation where there are >' single quotes in my data. When I try to set the rowfilter to that, with the single quote in it I, I get an error, I've tried using escape codes and braces and that fails too... ..RowFilter = "Place = 'Joe's Place'" will fail any ideas? Thanks Chuck ...more >>

I am trying to call a query that uses a union in a Access 200 database, and I get the following error "Unspecified error: E_FAIL(0x80004005) I am pretty sure that it is because it is calling a query that has union since all my other calls to queries in this database work okay. Here is my cod...more >>

Hi, I would like to export the data in a table, or a subset of the data to an Excel file. Is this do-able? Any help is greatly appreciated. ...more >>

Hi all, Please can anyone help with the following: I want to display selected records retieved by a stored procedure in a datagrid (using a template column) - sorted by the category field, with relevant records displayed underneath. I can get as far as displaying all results, but the ...more >>

Hi all, I'm working on the project, using asp.net with sql server 2k. I have to read all the information in database, included TableName, FieldName, Views, Store Procedures, User Definined functions, .... How can I get them? If someone know about it, please help me! Thanks. nghiangodinh. ----...more >>

When I started working on an ADO.NET application that accessed Oracle 9 on the backend, I downloaded and installed ODP.NET from Oracle (http://otn.oracle.com/tech/windows/odpnet/index.html) which gave me the Oracle.DataAccess.Client namespace. Was impressed that the Oracle objects were in the ...more >>

Is there a setting in either ADO.NET or SQL Server 2000 that will allow me to receive an error when a parameter is passed to a stored procedure and the parameter is truncated? For instance: CREATE PROC foo ( parm varchar(30)) AS .... If I make the call to the stored proc and the value passe...more >>

Hi we have an C++ application (used Visual Studio .NET) where have converted the database interface to ADO.NET. I tried to install the app in a network with a Win2000 server and XP workstations. I downloaded dotnetfx and run it on the server and all the workstations. The application runs fine on t...more >>

I'm trying to set custom widths and headings for DataGrid columns, but they keep displaying as defaults. I did configure the params via the TableStyles collection -> ColumnStyles collection. MappingName is set to the name of the DataTable. My understanding is that the names should match or e...more >>

Hi, is it possible to access an xls Excel file via ADO.NET If possilble, what is the provider name Please advise Peter...more >>

Hi, I am pretty new about stored procedures things. I always believe in the past they were evil for the sake of DB independance. A few years back I worked in a place where we all use ANSI sql to retrieve anything we need. Also sometimes I needed to instantiate heaps of objects to finally rejec...more >>