Will a .txt file open ok from multiple locations if on a network?

[Gary]

I'm writing a simple program to dish out incoming leads.

I don't understand database programming in c# and this needs to be
finished like yesterday - so i dont have the luxury of spending a
couple of weeks reading up on ADO.

I have used a simple technique in the past of storing data in a text
file and just reading this into an array and populating a listview
control from this.

This app will be used by about 6 users on a MS Network (Client/Server).


If i store the data txt file on the network share and have the 6
machines use this same file, will this be ok?

or will i have problems? (given that the machines update, and and
delete some basic data in this file)

If it is problematic what's the SIMPLEST solution to this?

Thankyou!

Gary.

 

[sloan]

You can run a


ExecuteReader

against a text file.

You can find the connection string here:
http://support.microsoft.com/kb/326548
(DO NOT USE HTE ADO object from this KB)



You can find an example of an ExecuteReader here
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1188419,00.html


Make SURE you do a dataReader.Close when you're done with it.

IDataReader idr = null;
try
{
//use the idr here
}
finally
{
if(null!=idr)
{
idr.Close();
}
}