During db development one of the most frustrating thing is the Concurrency
Violation error which seems to be a general error message for any error
during saving of record(s). How can one debug such an error and get more
specific information on the underlying reason for error and ...

Using c# 3.5, I have a dataset (not strongly typed) where all the table
column names are a, b, c, etc. like the sample below.  I need to rename the
table columns into something more user friendly such as ID, Name, StartDate,
etc...  Also, this is something that will  happen over ...

Are there any RAD apps to speed up one-many db application development that
are worth considering?
Thanks
Regards

Since my application uses the Excel driver to read some files, I used the
same Excel driver to write some CSV files.  I also tried using the Text
driver to write CSV files.  The results are correct but they take enormous
amounts of CPU time.

Recently I had to switch out my XP machine with vb.2005 express and SQL
Express ( the computer died )
to vb.2008 Express with SQL Express and Vista.
The wierd part is, my microsoft book stopped working with the connection

I already searched old posts, but still confused.
I am a asp.net application and user "everyone" does have write and
read right to the excel file
public static readonly string sConnectionString1 =

is there anyway to get the data as it is returend from the sql server? I
have a command object that returns 100,000 records which I want to see as
they come back... kinda like how SQL Managment studio does when you execute
a query it shows the data as it comes in... any way to do ...

I have a small app with bound controls that do not seem to be copying across
the data entered into them to the underlying row for the update. This one
really has me stump even though these are very simple steps and I can't see
where I am going wrong. Any help would be appreciated ...

Is there a way to downgraded a vs2008 project to vs2005?
Thanks
Regards

Still trying to get my head around VB.Net/ADO.Net and have a question.
I can't work out how to 'process' a stored procedure multiple times.
In other words, in VB6/ADO I would do something like:
For i = 1 to 10

Many a times I have been told off here for asking question on a backend
other than sql sever. So I have finally seen the light and have decided to
take up my next project with sql server backend (vb.net front). So here is
my question;

I have a very simple db app that was created by dragging a couple of fields
onto a windows form. No additional code was added. The problem is that app
gives a concurrency error while deleting a record even though no other user
has access to the app.

I have a stored procedures that takes few parameters( lets say 2).
Parameters are value for particular columns.
A column of type "binary' can contain "null".
I want to update a row, so that first column will have some value and second

Hell All. I am trying to use ADO.NET: The Complete reference by Michael and
Denielle Otey . I wanted to download the code from the publisher's (Osborne)
website BUT when I go to the Osborne website and enter this title into the
"Search For" space, it says it cannot find that book ...

I have a winform db app that is "bound" to a dataset...via data adpater,
binding source and all that. As this is a multi-user app I need to refill
dataset from time to time so the newest data is available for user to view.
My problem is that I