I created a windows form that has a progress bar on it. I am running  a bunch of statements to update data on the database.  I want the progress bar to increment (perform one step) after each update.  The problem is that the progress bar doesn't move (it just sits there until the ...

In my current application, I read 5 tables that are in a single MS dB file.
What I find is that there is about a 2 second hit per each table read when my
application loads.
What I'd like to do is to create another MDB file and transfer all the tables

This generates a compile error:
private void BuildFTPRec(DataRowView a)
{
   foreach (DataColumn dc in a)

I am using a timestamp column to manage my concurrency on updating.  My
question is on the update should I create a new timestamp colmn on the
server side or the client side?  And how would I accomplish that?
Thanks

I trying to create two columns in a dataset with the type of int32 and
Timespan but i get a message that this is not a valid datatype. In the
example code under the help text on DataType you find following text (cut
out of the helptext)

Can i show the progress of a  SqlDataAdapter1.Update(m_ds, "XLData") statment?

All,
By default, that SP is ran after every call I make to the database.  I can prevent it from by adding "Connection Reset=FALSE" to my connection string.
What is recommended?
Thanks

Does the ExecuteScalar function use a DataReader behind the scenes?  I
had 2 objects that used the same IDbConnection object, and each
object called ExecuteScalar(neither called ExecuteReader).  One
completed successfully, the other got the error that a DataReader was

I'm getting an "invalid cast" error message when trying do use Dataview.Find() method to get the row I need to update in my datagrid. The problem just occurs after I sort the datagrid by a non default order.
// Update grid code
string key = DataGrid1.DataKeys[e.Item.ItemIndex] ...

Howdy,
Can someone please explain the rational of letting an OleDbCommand take more
parameters than the query string is expecting. If i have 3, ???, in an
Access Query string, and i supply 4 parameters, it DOESN'T fall over/throw

In my ASP.net book it says you can put the sql of a stored procdure in which
you use parameters in the commandtext property in the designer and it will
automatically generate the code for adding the parameter objects to the
command objects. All's I get is an unable to parse update ...

I am fairly new to ADO.NET, is there an ADO.NET method that
is similar to the AddNew method that existed in ADO for adding new
records to a database.
Martin

Getting following error when I Update an OleDbDataAdapter: “Argument 'Prompt' cannot be converted to type 'String”.
I used the Wizard to generate the DataConenction and DataAdapter
Code is:
      OleDbDataAdapter1.Fill(ds, "PatientSummaryTBL")

Built a stored procedure to do an update on a table with 16 fields. When I
tried to update the database with the table data, I got a concurrency error.
Went through the code, the stored procedure, the command parameters, the
whole deal -- everything looked perfect. So I had the DACW ...

Is there any way to get rid of the hundreds of CS1591 'Missing XML comment
for publicly visible type or member' warnings on XSD.exe-generated
strongly-typed DataSet code?
I've got XML documentation generation 'on' for my solution (for use with