I am doing a 3 tier thick client app and use a middle tier to get and put
dataset contents. I am using an approach, very similar to many prescribed by
Microsoft and in books to create a pseudokey as an identity/autoincrement
column with seed and step both -1. Then when database ...

I'm sorry for my incessant questions but I am architecting a Sql Server
2005/ADO.NET 2.0 project, and I just wanna be double sure of any
architecture decisions I make.
I found the following very interesting code in

The following very simple code does not seem to accept the DateTime variable
as a parameter - why?
The table (MS Access db) here contains only a primary key and a column Date
of type date/time.

Haiii!!!!
Is it possible to create stored procedure dynamically in C#.NET. Because
some of my requirements needs such a situation.

As suggested by Cor Ligthert, i've created a simpler sample, with the same
problem; this is the full source code,
so everyone can try itself:
Access database "dati.mdb":

Is this possible?  I want to concatenate two columns in my table and display
them in one datagrid column.  I have a TableStyle where I create
DataGridColumnStyle's. I'd like to set the MappingName to two columns but I
dont see how this can be done.

Tables: Parent, Child, Toys
Relationships: ParentToChildRel, ChildToToysRel.
dataGridParent.Datamember="Parent";
dataGridChild.Datamember="Parent.ParentToChildRel";

I have got a datareader by sqlcommand, now I wanna move forward or backward,
but I don't find first,last,prior and next methods. How can I do it?
thanks for your suggestion.
hui

I have a remote DataTable and I want to add 5 DataRows to it.  My
current code does a "remoteTable.Rows.Add( new object[] { .... } );".
That results in 5 remote calls, which is bad.
I already know the schema of the remote DataTable.  Is it possible to

Sorry for posting a long post, (the code) but, I am having a problem copying one data table to another new table in another
Access database that has the same table schema.  You will notice that I do not list exact column names etc. because this routine
needs to be generic so I can ...

I have got a datareader, now I wanna get last record or locate any record by
some integer step. How can I do it?
thanks
hui

I have  backed up a table from a database in an DataTable (dt ) object.
The table has been wiped up (in sql server) after the backup  but i still
have the copy in memory (in my DataTable object ).
now i need to restore the table from memory.

Hello all I have an interesting problem which is causing me to lose
sleep.  I have a vb.net app in use by approximately 100 people on a
daily basis.  This app is mission critical for the business.  I'm
using windows server 2003 for the web front end, SQL server 2k for the

this is a stange place for this request and I apologize.  However I asked in
both server sql and vs 2005 forums.  The frequency of posting is so low it's
impossible to carry out a dialog.
I have sql 2000 installed.  I ran the script for northwind.  Didn't seem to

My web app allows users to upload an excel file and then ado.net loads
the data (if there is any) into sql server.
I have a problem when if there is no data in the excel spread
(completed on a weekly basis), then the code fails when i try to fill