How to connect to a directory on a remote computer

[cBarry263]

1) Does anyone know how to connect to a directory on a remote computer, that requires a username and a password? For example, you would use Directory.GetFiles(pathname) to get files from a directory on the local machine, I want to get files from a directory on a remote server that is within the network.

2) How to delete a row in a database using an ODBC connection, the delete statements I am using don't delete anything.
objDeleteAdapter.DeleteCommand.CommandText = whatever does not seem to be working.

 

[ManicCW]

your second question: it does work but you need to execute that command!

 

[cBarry263]

Wait, I thought that did execute the command? If that doesn't do it, what does?? objDeleteAdapter.DeleteCommand?

 

[jmcilhinney]

The DeleteCommand is the command that will be used to delete records, but if you want to use it you have to delete come records from a DataTable and then call Update on your DataAdapter and pass the DataTable as an argument. I suggets that you do some reading on the Command and DataAdapter classes you are using. If you're using a DataAdapter you normally use the same one to retrieve the data from the database using Fill, then you make whatever inserts, updates and deletions you want and then call Update to commit them to the database.