data is not being saved after a time period

Question

sir in my project  i m saving data in database in every one minute in timer Event. So when i run it  data is saved for 10 or 15 minutes. after that timer event not insert the data in database. Kindly help in this problem why it is being happened. regards Vishal

Upendra Pratap Shahi · Answer

Your thread is sleeping after time so your data not inserted kindly check your code thoroughly ..

Vishal agrawal · Answer

MY CODE IS AS BELOW.... protected void timer1_tick(object sender EventArgs e) { // clientSocket = new Socket(AddressFamily.InterNetwork SocketType.Stream ProtocolType.Tcp); // clientSocket.Connect(new IPEndPoint(IPAddress.Parse(101.0.0.173) 9000)); // clientSocket.SetSocketOption(SocketOptionLevel.Socket SocketOptionName.ReuseAddress true); // clientSocket.Connect(new IPEndPoint(IPAddress.Parse(101.0.0.173) 9000)); ClientThreadStart(clientSocket); } private Boolean ClientThreadStart(Socket clientSocket) { // Send the file name. // clientSocket.Send(Encoding.ASCII.GetBytes(m_fileName)); // Receive the length of the filename. try { currentTime = DateTime.Now; currentTimeForSMS = DateTime.Now; if (previousTime == DateTime.Now || currentTime.TimeOfDay.Minutes - previousTime.TimeOfDay.Minutes == 1) { InsertInDB(); } string receivedValue = string.Empty; byte[] receivedBytes = new byte[1024]; int numBytes = clientSocket.Receive(receivedBytes); //int length = BitConverter.ToInt32(data 0); receivedValue += Encoding.ASCII.GetString(receivedBytes 0 numBytes); if (receivedValue.Length == 0) actualValue = 0; else { if (receivedValue.Length > 3) receivedValue = receivedValue.Remove(3); else receivedValue = receivedValue; actualValue = Convert.ToDecimal(Convert.ToDecimal(receivedValue) * 100) / 255; actualValue = Math.Round(actualValue 2); } //Response.Write(DateTime.Now); //actualValue = 21; if (actualValue { txtStatus.Value = Not Running; } else { txtStatus.Value = Running; } if (actualValue > 20 ) { // txtStatus.Value = Not Running; int count = currentTimeForSMS.TimeOfDay.Minutes - previousTimeForSMS.TimeOfDay.Minutes; if (count == 0) { editsmshigh(); System.Diagnostics.Process.Start(Server.MapPath(\asms\smsh.bat)); // System.Diagnostics.Process.Start(C:\asms\smsh.bat); // previousTimeForSMS = DateTime.Now; } if (count == 10) { editsmshigh(); System.Diagnostics.Process.Start(Server.MapPath(\asms\smsh.bat)); // System.Diagnostics.Process.Start(C:\asms\smsh.bat); previousTimeForSMS = DateTime.Now; sentSMS = true; } // count = count + 1; } else { // txtStatus.Value = Running; if (sentSMS == true) { // SendSMS(9574000515 username Dear Sir Opacity Meter Reading is OK -  + actualValue + .); // SendSMS(9574000551 username Dear Sir Opacity Meter Reading is OK -  + actualValue + .); // SendSMS(9574000501 username Dear Sir Opacity Meter Reading is OK -  + actualValue + .); //SendSMS(9574000589 username Dear Sir Opacity Meter Reading is OK -  + actualValue + .); System.Diagnostics.Process.Start(C:\asms\smsn.bat); sentSMS = false; } previousTimeForSMS = currentTimeForSMS; } if (receivedValue.IndexOf([FINAL]) > -1) { } // Console.WriteLine(Received value: {0} actualValue); // Response.Write(Received value: + actualValue); txtSPM.Value = Convert.ToString(actualValue); // SendSMS(9574000515 username Dear Sir Opacity Meter Reading is - + actualValue + . please check.); // SendSMS(9574000589 username Dear Sir Opacity Meter Reading is - + actualValue + . please check.); } catch (Exception) { return false; } return true; } private Boolean InsertInDB() { object objAffected; try { cnStr = Data Source=xxx; User Id = XXX; Password = XXX;; //query query = INSERT INTO opacity_data (P_VALUEP_DATE) Values( + txtSPM.Value +  sysdate); //Connection via Connection open Property. cn.Open(cnStr null null 0); cn.Execute(query out objAffected 0); cn.Close(); previousTime = DateTime.Now; return true; } catch (Exception) { return false; } }

Pankaj Kumar Choudhary · Answer

Hello @Vishal can you post your code .....

ramya bharath · Answer

Check whether the event is running after 10 minutes or its getting timed out or is it showing any error