I've a DataTable, and from my UI a such user deletes one or more rows from
it, I wish to get the deleted rows from the DataTable. I have to perform a
loop trough the deleted rows and invoke the Row.Accept changes method, but
if I try something like this:

Im using the VisualStudio 2005 designer to create typedDataSet (drag &
drop from the service explorer).
All the DataTables in the generated code inherit from
System.Data.DataTable, I would like the dataTables to inherit from

this was driving me crazy! I've a datatable its related sqlDataAdapter, if I
call the .Update method of the adapter everything is ok, but if I add a
compute column to the DataTable (a columns computed via a DataRelation) I
receive the "There is no Original data to access"

I have a headache with SQL Server and .net application which I hope you
can help with.
I have this trigger on my table 'tester' in sql server 2000. It calls
the external program exetest

I recently got into a discussion with a coworker about just how long to
leave a connection open. I have always opened as late as I can and closed at
the earliest possible point in time.
using (SqlConnection cn = new SqlConnection(DataConnection))

I have started using Typed Data Sets with VS2005 and so far so good,
however I am having a problem with adding a row to a data table and
returning the new Primary Key value.
My data set has been auto generated from a DB table and has an auto

I have a table as follows-
BUILDING  ROOM_NUMBER
MAIN        100
MAIN         101

I need to perform following querie in vb.net
The queries are;
NSERT INTO [destTbl] (field1, field2)
SELECT srcTbl.field1, srcTbl.field2

I have tried everything I can think of, I have even tried copying examples
from books and websites I have found, but every Formview control that I have
tried to create does not show the Paging controls. The first record from the
DataSource is displayed, but not the Paging ...

I defined in my Sql Server db a table with 2 int columns that don't allow
null values + their default values are set to 0.
I'm using a DataAdapter to read data, but it doesn't bring the default
setting :

I have a headache with SQL Server and .net application which I hope you
can help with.
I have this trigger on my table 'tester' in sql server 2000. It calls
the external program exetest

I have VS.net 2005 express and I have created a new project. I made a new
folder and added and existing MS Access DB (Maintenance.mdb). VS.net happily
went and created a DataSet class for me (MaintenanceDataSet). My question
is:

Hi, is there anyway of selecting rows with a particular date but ignoring
the time within a date time column?
something like...
DataTable.Select("DateTimeColumn".Date = '28/12/06')

I am getting the System.IndexOutOfRangeException was unhandled error on the
last line of below code;
Cmd = New OleDb.OleDbCommand("SELECT [Last Staff Update From Site] FROM
[Update Control]", LocalConn)

I need concatenate values of two fields in select command, but if I use this
select command in Query builder in VS I get error. I concatenate two string
values using SQL concatenation operator (||). It's a bug in Query builder? I
think....