Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL
The website is sometimes missing the data. If we are login at that time, it will automatically logged out, and if we wait for 2 min and click again in any link it will automatically log in. I think the database connection is missing for some time,after that it will connect automatically.i had set the Job in the server. I am using SQL Server 2008..What will be the issue. Please help me.
Posted 24-Jan-13 23:23pm
Comments
Member 9492907 at 25-Jan-13 5:40am
   
I am using Session. this was not the session issue..All the data are missing for sometime. all the dropdownlists are show as empty lists in all the pages..in all the user accounts.
aspnet_regiis -i at 25-Jan-13 6:24am
   
virus problem on the server.... you are doomed...
Member 9492907 at 25-Jan-13 6:28am
   
But how can we found if it is a virus problem. All the users are logged out at the same time, and the log in after same time if we refresh the page..please give me a solution
Member 9492907 at 28-Jan-13 1:08am
   
I found ,why the issue is happening. Some times if there is multiple users in the website, the data from one module is replace with the other module data..so i think the issue is related to the DAL structure..
 
My Function structure is like this
public static DataTable ABC(string UserName, out string Error)
{
Error = string.Empty;
objDataTable.Clear();
objDataTable = new DataTable();
DataCommand.CommandText = "SELECT restId FROM tblRestaur AS rb JOIN tblOwner AS o ON rb.ownerId = o.ownerId WHERE o.ownerUserName = @UserName";
DataCommand.Parameters.AddWithValue("@UserName", UserName);
DataCommand.CommandType = CommandType.Text;
try
{
if (DataConnection.State != ConnectionState.Open)
DataConnection.Open();
DataAdapter.Fill(objDataTable);
}
catch (Exception ex)
{
Error = ex.Message;
}
finally
{
DataCommand.Parameters.Clear();
DataConnection.Close();
}
return objDataTable;
}
 
What will be my mistake..plz help me

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 220
1 ProgramFOX 120
2 Richard MacCutchan 100
3 kbrandwijk 90
4 ChauhanAjay 80
0 Sergey Alexandrovich Kryukov 9,050
1 OriginalGriff 8,151
2 CPallini 2,613
3 Richard MacCutchan 2,221
4 Abhinav S 1,928


Advertise | Privacy | Mobile
Web02 | 2.8.140827.1 | Last Updated 25 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100