hi.All
I am having problem with date field binding to a DateTimePicker.
I have looked and try several so called *solutions* on the net,
they all don't work for me. they either don't set the check state

I have created at Dataset from an OleDB connected text file using schema.ini
and so forth, so far no problem, now what I need to do is take the data from
that dataset and update records in another database, (SQL Server) which has
a table that contains the same key as I used in the ...

I'm relatively new to .NET technologies and basically I need this information. We would like to persist the data returned from a database and present the user in Excel/?/Customized GUI Application in order to make him to change the data. Finally all the data updated are to ...

Does anyone know if implementing a Singleton design pattern class to be used as a data access component would make for a solid architecture for an enterprise-wide .NET system?
I'm wondering if having a single point of entry won't become a bottle-neck and reduce performance.
If ...

Hey All,
I`ll Pay someone to tell me this now, as its doing my head in, I carn`t see
out on the net and no one seems to know!
I have a form that connects to a Access database, and I have a combo box on

I have an SQLCE database into which I want to insert a datetim
INSERT INTO ADR_ADDRESS (Last_Edited) VALUES ( Convert('01-FEB-2004 11:12:22','dd-mon-yyyy hh:mi:si')
The table was defined wit
CREATE TABLE ADR_ADDRESS (

I have a case where I am creating a dataset from one database, then I want
to issue a series of updates to another database to update data based on a
common key between the two tables in two separate databases. eg
Database1.Table1

Hi - I've seen several clues to this but I wonder if any experts can
definitively confirm ......
Does the DataAdapter.Update method pass all updated datarows to the
database for some kind of batch process with multiple calls to the

I'm using a data reader and Microsoft's 'data access application block'
SqlHelper class.  CommandBehaviour.CloseConnection is being used so
theoretically the connection should close when closing the reader.
However I'm getting "timeout period elapsed prior to obtaining a connection

I'm just coming up to speed here on .NET and have a C# WinForm App that accesses a database. I've gotta form with the following code in the form_load event
        private void DocumentsDetail_Load(object sender, System.EventArgs e
            this.dsDocuments1.Clear()
            this.daDocuments ...

I am trying to transform an old application in FoxPro 2.6 into a VB.net
application.
I use Ado.net with the last VFPOLEDB driver.
I am opening a DBF File and his .idx file index by doing : "USE

I've heard some (I think wierd) ideas that it is much faster to use
XmlDocument then DataSet for storing and updateing data from database. The
idea is to use XmlDocument to store data, make add/update/delete operations
on it, keep track of changes and finally make changes into ...

Posted this to 'ado' group earlier but getting no replies...
I have a C# app that uses the base "System.Data" interfaces so it can
switch between Oledb and Odbc (mostly accessing a Jet database).
Everything has worked until I tried using parameters. The code below

I have a SqlDataAdapter that is not picking up Sql exceptions from the SQL Server database such as foreign key constrain violations.  When I call the update method of the dataadapter for either inserts or updates, it just fails silently.  If I do the update directly from the SQL ...

I ve an error "Connection is busy with result another command" with oledb and SQL Server 8.00.837 (SP3a
and Framework 1.1.4322.573, MDAC 2.8 RTM. It's not always on the same command and if i try on my serve
Oracle all are clean. I search in many forums but nothing help me for now. ...