David,

I assume that you are using untyped DataSets.  This being the case I would think that a Select Statement would be needed to generate the appropriate structure.

There is another type...

David,

I assume that you are using untyped DataSets.  This being the case I would think that a Select Statement would be needed to generate the appropriate structure.

There is another type...

David,

It is the DataSet that holds the data.  There is no requirement to have a select command associated with a DataAdapter.  If you only want it to insert data just...

David,

Place the code in a try... catch block and extract the error message

e.g

try{

   YourStuff();

} 

catch(Exception ex){

   MessageBox.Show(ex.Message);

}

This will give you a better idea of what is happening.

regards

Shaun

Hi Ross & David,

The prefix to avoid is actually 'sp_' because as you say SQL Server will look in the Master db first and therefore slow things down.

A good point!

regards

Shaun

Hi David,

Do you specifically need to use DataAdapters.  If not consider using a Connection object and a command object to execute stored procedures

e:g

SqlConnection cnn = new SqlConnection("Connection String");

SqlCommand cmd =...

In the web.config file you need to have this entry.  As the comment says, the run-time will now permit access to a non trusted server

<!-- Allows log...

Attaching a database does not automatically update users and permissions within the server.  You will have to recreate your logins and their permissions in the new server.  I believe that this will solve your problem.

Hope...

I think your best bet would be to execute stored procedures returning parameters and simply assign the output parameters to the appropriate controls.

eg Open the database, execute the stored procedures, close...

Hi,

I have tried a couple of methods and both have worked for me

the stored procedure sp_addlinkedserver.  This creates a linked server, which allows access to queries against the selected data source. ...