I have to agree with the previous poster.  If you only ever want one table from the dataset, binding by default to the dataset is bad form.  Not specifying the...

I have to agree with the previous poster.  If you only ever want one table from the dataset, binding by default to the dataset is bad form.  Not specifying the...

Could it be some type of AD/Security setting?  One site is in a Trusted Zone and the other isnt?

The behaviour you are describing for opening something with the content type...

The solution above is fine, except that every client machine would have to be touched to make those settings.

Another option to explore is the Office Web Component (OWC).  Its an...

I always thought this forum section was for Programming questions, but then I am a developer and not a DBA.  So why not use this?  But if your aren't comfortable...

The above poster is correct, a stored proc (or any method to get data back into the DB) followed by reloading and rebinding the data would be a great solution. ...

What type of control is TxtTitle?  I assume a textbox (but you know what they say about assumption).  Based on the code given, you don't seem to be databinding any...

Without seeing more code, I'd have to hazard a guess that either your original dataadapter/dataset is not being cached between postbacks or its being overwritten upon each postback and before your...

You may want to also take out the label in your fill method, there by only calling: 

DataAdaptor.Fill(ds)

I believe this will also fill your dataset with all of the results...

You may want to actually go back to using the DataReader on this one, then you can take advantage of the NextResult method of the Datareader.