Posts by hericles

In your code you have this line:

if (cn.State == ConnectionState.Closed)

but I can't see a section where you continue if the cn.State is open. Depending on whether you handled any other opening/closing of that connection you may have a problem (the two functions here look OK but you may have other code that leaves the connection open elsewhere).

Also, you are selecting all from the database where user name and password matches but then, when checking if the data reader has rows you are running the same check again:

if ((rdr.GetString(1) == this.tbx_user.Text) && (rdr.GetString(2) == this.tbx_pwd.Text))

This seems unnecessary as the reader can only contain rows if the user name/password have already been matched.

An older version of MySQL would work fine, the issue isn't what database you use but how you make the remote application update, unless I've missed the point of the exercise. I wouldn't think database speed would be issue, both MS SQL and MySQL are used as production servers for massive databases.

If you are getting an error please include it in the post; but one solution would be to put the results from the first reader into a dataTable instead of keeping the reader open - so you would be better off using a dataAdapter to fill the dataTable. Then loop through the dataTable using the second reader as you have it here. I think closing the first reader as soon as you can might fix the problem.
Also don't use SELECT * from the database if you don't need all the data. It's lazy and bad practice:)

Thats a client side action so you will want to use Javascript (unless you are planning on having a page refresh or AJAX call on every key stroke)

How you retrieve the data from the database won't change but in terms of displaying it you could opt to use a repeater control (you've posted this in the asp.net forum so I'm guessing its a web app you're working on).
Whatever you choose (a datagridview will work just fine) you will want to alter the columns to display either text boxes or checkboxes depending on what you need. In the properties of the datagirdview you can specify what control you want to be in a particular column. After that, for text for example, the data from the database would be inserted into the text box rather than displayed as text on the page allowing it to be edited by the user.
I have some sample code on another computer that might be of use if you need more help.

Steve

You have to alter the names in some way. You can't have 2 files with exactly the same name in the same folder.

Tooltips aren't of any use to you? They display your help text when the control is hovered over

You need to use transactions. Transactions lock the records in use while one user is still altering them, blocking others until the resources are free again. You'll find plenty of examples online but basicallyyou begin a transaction, make your insertions, updates, deletes to the database and then either commit the changes or rollback if an error occurred.

Hope that helps,

Try changin your requestedExecutionLevel to level="requireAdministrator". Once your program runs as Admin it should be able to access everything. Or alter your code to check real file info is coming back from your getFiles().

Hi,
If you add a Global.asax file to your website you can access methods for session_start and session_end. They are managed by the server, not the browser. For example the Session_start method is called the moment a new user requests a page from the site. The timeout period can be specified there and the server monitors the inactive or total time spent by the user on the server.
I hope that helps,

I have to agree, your problem seems obvious. You've turned it off by setting it to false.