I have a DataTable which I did use as the source for a DataGrid, teh data
table was popeulated form my database and when I made changes in the grid I
used the same DataAdapter to chnage the values in the database.
However, I now have the need (on a column by column basis) to show ...

I am a newbie to the ADO .NET. I use a dataset as datasource for a web
Crystal Report. I fill this dataset using a sqlDataAdapter. The
selectCommand is quite complex and use many table and relations. The
execution of the fill command is very long (it takes about 30 sec.),  but if ...

I'm trying to filter a range of dates in a dataview.
Problem is single digit days and months are getting mixed in with double
digit days and months.
eg)  rowfilter='DT>03/25/2005 AND <03/27/2005'

Using an informix database, I'm retrieving two datasets and copying the data
table from one dataset into the other, so I've got 1 dataset with 2 tables.
This is just background because it might be part of the problem.
After this, I simply want to create a data relation between ...

What I want to do is catch and dismiss expected errors during an update
(resolve the problem and allow the update to continue) but have unexpected
errors throw their exception normally (stopping the update). To accomplish
this, I created a method and attached it to the ...

I am using the following to remove a row from a DataSet:
myDataSet.Tables["Table1"].Rows.RemoveAt(indexSelected);
followed by;
myDataAdapter.Update(myDataSet);

... not sure what the best way to do this. What i need to do is return
all the records in 1 table that don't exist in another table.
scenio
Table A contains a list of Tasks to work on.

I am learning ADO.NET, so please bear with me.
Currently, I am coding in VB.NET and running a SQL Server
2000. My question is this, how do I use only one
SQLConnection for multiple web forms? Is this even

I have an xml from two different database source that I load into the dataset.
one of the column is a date field and I want to sort the date. Its sorting
the date as string as the datatype for the column is string.
Can I change the datatype of the column ?

Hi I am trying to find out if it is bad, and how bad, to start a database
transaction on a set of read operations.  By starting a transaction I can
keep open the database connection...but is there significant overhead for
transaction?

I am a newbie to the ADO .NET stuff.  I am using Visual Studio 2003/ VB to
develop an app. Been doing development for a long time, but having a tough
time getting my hands around the new way of doing things.  Hoping you can
help.

Okay so I'm using the Data Access application block in the Enterprise
Library. I'm using it to return a DataSet from an SQL Server (well, MSDE)
stored procedure. So that's an untyped DataSet. I have no access to the
DataAdapter used to retrieve the DataSet (the Enterprise Library ...

Is there any way to use in my application Query Builder that Microsoft is
using in SQL Server and DataAdapter Wizard where I can drag and drop tables,
link them in graphical designer and run resulting sql statement?
Is it possible or is it just part of SQL Server and VS?

Question.
Is there a way I can get the order preserved (possibly with a SQL
config option or such) using the folowing;
Select ..... into #temptable where ... Order By ...

Hi everyone, i'm a newbie to VB.NET programming and i need help here. I'm
current doing an application for pocket pc and i get this sqlexception error
when i try to retrieve stuff from the database. My guess is that the error
lies with the connection string. I've tried serveral ...