Thank for ur reply.Whenever a complaint is raised, the complaint details will be inserted to the complaints table and a message related to the complaint will be inserted into the messages_Log table which has the column names as SerialNo
Now I display this table in the gridview in my UI
with the orderby time. Here is my Sql Statement.SELECT [Type], [Message], [Time] FROM [Messages_Log] ORDER BY [Time] DESC.
Now I need to display the count of the inserted records in every 1 hour time .How to write the query for that...This requirement is similar to the inbox in gmail or yahoo...!
I am stuck with this requirement since 1 month Please help me put to solve this issue........!