I web application is in asp.net with Access databasesome times my application giving this error message "Could not read the record; currently locked by another user." or "Could not update; currently locked."I am using IDbConnection and IDbTransaction object.
View 2 RepliesI am using an access database to store my data. I have Add page which inserts data in the database. Also i have created an Edit page to read and then edit the data. In both these pages I am using FCKEditor. So I can take HTML values and insert in the database for a field called Desciption. Now when I am inserting a data having a long value for theDescription field and then editing that data using the Edit page the Description field get locked and the update command doesn't work. This happens for a data having a longDescription value. I have used the datatype Memo for Description field
View 3 Repliesi need to start reading a recordset starting from a specific record using SQL. For example: i've 10 records in my msaccess table and i'd like starting read it from record number 6 till the EOF.
View 4 RepliesI have a website deployed on IIS 7 . And want one of my pages authenticated by windows authentication. But While trying this I am getting error "This feature has been locked or Read Only".
View 1 Replieshow to check with vb in asp.net if a MDB is locked?
View 4 RepliesI have a webpage that you pass in an id parameter (via a querystring), which it then uses to fetch data from a database. Typically, a user would navigate to this page from another page that lists only those records that the user has access to. However, if they go directly to the page by typing in the URL in the Address Bar, they can effectively view any record they like. to type something like http://localhost/TestSite/ClientAdmin/ManageLocation.aspx?LocationID=5 into their Address Bar, they can access the database record with the LocationID equal to five - even though they shouldn't have access to it
View 2 RepliesI have written a script to write several values to an Access Database Table, but I need to ammend i so it checks for two values (Asset and LName) to see if they match if they do it updates the record if not it writes a new record, my script so far is as follows :
[Code]....
I'm just stuck as I can't work out the best way to do it,
We have a web site on customer server. It is being locked every 2 or 3 months. I posted this subject before. For understanding the error I created a log file. When the server locked I look the log file and saw "system resource exceeded" error message. Have you any idea about this error.. When restarting the server it continue.
View 5 RepliesI am using forms authentication (built into ASP.Net) and allow users 5 attempts to login with an invalid password. After that they are locked out. How can I programmatically unlock someone?
[Code]....
What is the best way when using the ASP login to display to the user that they are locked out?I want the user to know that their account has been locked and action needs to be taken.
View 2 RepliesI am using framework 4.0 and database is in access. I have saved data in database via admin panel. but when i am updating the existing data, it showing an error as below:
"System.Data.OleDb.OleDbException (0x80004005): Could not save; currently locked by another user."
What I am trying is, whenever user enters his Name and Address into the textbox on the webpage, I am going to displaying it in a Gridview. Now if second member will do the same thing thing the GridView will be updated and his Name and Address will display in second row and likewise for other users. But what happened in my code is when second user will try to add his record, it remove the record of first user and add the record of second at row1. I want the record should be added one after another. below is my code
[code]...
I know this looks similar to other questions here but I don't think my case is the same as theirs.
I have a website that uses the AspNetSqlMembershipProvider to validate users. I would like to use the same database from a console application. According to several articles on the web I can use the System.Web.Security.Membership class from outside ASP.NET by copying the appropriate sections from web.config to app.config. That is what I did.
My console appliction can get the user with the requested name and I can confirm that the user is approved and is not locked out but ValidateUser returns false for a correct username and password pair.
I have found articles where people have had trouble with migrating code which may be due to a machine key mismatch but have also found a reference saying that machine key is only used if the passwordFormat property equals encrypted whereas I am using hashed.
Is the issue that the two pieces of code - the website and the console app - are in different assemblies and the assembly name or other property is being used during password hashing? In both cases the application name property is set to /.
Should I continue with this approach or just access the database directly and hash the password myself?
user phoned me and said he received an error when attempting to login stating that his account had been locked. I had to unlock the user account today manually through the user interface. Several hours later I had to do it again. Afterwards, when I looked at the aspnet_Membership table it showed NO failed login attempts. LastLockout date for that particular user was set to min date. FailedPasswardAttemptCount was zero. FailedPasswordAttemptWindowStart was min date. I then proceeded to fail logging with the users account name.
View 3 RepliesI have a delete button bellow my gridview and I want a pop up to show when no record is selected and tell the user to first select a record. The button click event would show the pop up, but my gridview data blanks out.
Here is my code:
[Code]....
I have my code output a gridview with all the data with an option to select records. I'm trying to make a code which would allow me to select a record, and then print this record using a specific Report stored in MS Access.
I've located the code to print the Report it self, but it prints ether all the records or a range.
is it possible to get the last record from .read()?
View 2 Replieshow to read last 20 record form a table for example (tb1) and the table consist of 3 column
View 4 RepliesI have a table that contain 1000 record and a webpage that contain 10 label to show the data in table and tow linkbutton for showing (next-previous) records. I want a query when i click on next show next 10 record and when i click on previous show previous 10 record (code in c# if possible)
View 3 Repliesi open a sqldatasource for binding on listview.
I would like also to read a field on first record for print it.
How can i access to my sqldatasource from code behind ?
after i can copy my file to another folder i realised that if this webapplication is used by multiple users at once, then some users are going to get locked out because each one is trying to copy those files.
so how do i tell the user thats trying to use a file to wait untill the file is available.
StreamWriter WriterTotxt = new StreamWriter("date.txt", false);
DateTime LastAccess = File.GetLastWriteTime("path.dbf");
WriterTotxt.Write(LastAccess);
WriterTotxt.Flush();
WriterTotxt.Close();
string ReadTextFile = File.ReadAllText(txtFile);
DateTime test = Convert.ToDateTime(ReadTextFile);
if (File.GetLastWriteTime(LatestUpdatedTime).CompareTo(test) > 0)
{
File.Copy(Path.Combine(sourcefile, fName), Path.Combine(destinationfile, fName), true);
}
best way to read millions of record from sql server database.i have tried dataset but the performance is not good
View 5 Repliesi want to read last 20 record of a column in c# code
View 2 RepliesWe have a web application with feature for logging in with credientials The important requirement is once the user logs in he is not allowed to login from any other system or even another browser on same system We used following solution which is mssql based : We have kept " Is_Loggedin" as a column with data type "bit" in a table. when a user logs in we set the flag as "1" sowhen someone tries to log again ,the system is showing the error "The user is already logged in"When user logsout bit turns to "0"indicating user logged out. However this logic is failing in following scenarios Problem scenario:When user closes the browser the flag is "1"and user is locked in or situations when user gets system problem and unable to log out.
View 5 Replieshow to use update using ADO.NET dataadapters.
View 2 Replies