Forms Data Controls :: Displaying Real Time Data (GridView)?
Mar 24, 2010
I have a Table (in SQL Server) that is being updated roughly every minute or so with new records being inserted from various sources. The number of records inserted in this duration varies from a few records up to dozens of new records. I am using an update panel to rebind my data every minute to keep the GridView current. Now that I have the data refreshing I am looking for a better solution than reloading the data every minute. how to best keep my GridView up to date? Here is what I would like to accomplish:
1. Load the GridView and refresh the contents every minute. (60 second intervals)
2. When the GridView is refreshed every minute I would like to append only the new records to the existing grid, rather than bringing back the entire result set with each round trip to the database.
3. I would like a visual cue to identify the rows that have been inserted into the GridView. If new rows were to flash/flicker with a background color (yellow) that would be ideal.
Am I even using the correct control for displaying real time data, or are their other options? I essentially am looking to find the preferred method of displaying data that is being updated in real time in a web application. I'm hoping there is a solution involving AJAX but I haven't been able to find much on The Google. I am open to changing anything and everything about my approach -- this is largely a learning exercise. For testing purposes I am currently using LinqDataSource in conjunction with a GridView in an UpdatePanel being refreshed by a Timer control every 60 seconds. Informational: I have also started playing with the [URL] in place of the Timer control. However, for the purposes of this example I would be content to achieve the desired behavior using native controls as I have described them above.
I have a Transport Detaisl in DB , i want to dispay data on gridview with marquee scrolling up. Cabs are scheduled for drop every hour. So if drop is at 7pm i hav to dispaly on data of that hour from 6:30 to 7:15 later after 7:15 i have to display next hour data ie 8:00 pm drop data. I am able to get scrollin g data on gridview but how to schedlue it to scroll for such timings
I need to display the real time data in the label.
Explain In detail:
The camera is counting the people and store the counted value in database every minute.
so i need to pick the data and display it same on the screen. There are lot of cameras counting. So i need to take camera number and display respective count.
Camera NUmber Counted Value 1 Label1(Display realtime data here) 2 Label2
Following is my case in detail.I have a class against which I will configure an objectDatasource(I have a datatable in the class which the data will be initially loaded from the database.)A gridview which has provisions to add/update/delete records will be bound to the objectdatasource
My methods i.e. insert/update/delete will be manipulating the datatable and NOT the database directly(I DONT WANT TO CONNECT TO THE DATABASE IN THESE STEPS. THE REASON IS THAT THE INSERTS/UPDATES/DELETES WILL BE PERSISTED ONLY WHEN THE USER CLICKS A SAVE BUTTON(MAY BE PLACED OUTSIDE THE GRID) . My class to which the objectDatasource points to will have anadditional AcceptChanges method which will be called on clicking the save button. This method is the one which connects to the database and where the adapter.update will be called.The query here is that how do I call the AcceptChanges method of my class instance which is bound to the grid? Also I would like to get some websites where I can see the real world implementations of gridview(with insert/update/delete options) so that I can improve my implementation.
I need to build a system which needs to show data on almost near real time basis from a MSMQ data source and this sould be showin in image with a circle as to where the incident occurs.
This is the description given.
The position of the Incident relative to the 123 mark is requested to be represented on a circular concentration diagram .
The algorithm will have to export the location of each incident relative to the 123 mark in polar coordinates (r,θ) and translate this position to the 'master image' coordinate system that will display Incident location.
I have two questions.
1. How can i show the data in an Image and also please point me to any material which might help me with the same.
2. How do i show almost real time data from a MSMQ data source and also how do i architect the same for performance.
I have a DataGrid which gets populated from a Dataset. One of the columns is of type DateTime. The stored proc returns the data correctly. I mean, It returns both the Date and Time. But, the datagrid is displaying only the date and not the time.
I am trying to figure out the best way to dynamically map time retrieved from a stored procedure with the report headers. For example, if my ReportViewer Headers are the following:
[code].....
I am trying to find a way to have the data dynamically map on the page in the correct location. 7:15 should be placed below the 7 header and between the 15 and 30 numbers as an example. Does any know how this might be coded using tables in the ReportViewer?
I have a gridview on my page. I have a checkbox in each row of this gridview. For each checkbox in the gridview, I'd like to update my table accordingly, but I don't want them to have to hit a submit button every time they check the checkbox. I want them to check all the boxes they need to and at the end, they should hit one submit button.
i have 2 dropdownlist and gridview. Im trying to make a link after displaying the relational data in the gridview like below But how can i get the value and combine with the link
I am doing a search function where when user enters specific value (either by keying product name or product code) into textbox, data will be displayed using gridview.
However i have problems displaying it in gridview.
I am currently trying to figure out the best way to handle a data formatting issue. I have a stored procedure that pulls back basically all the data I need, but using a gridview doesn't really give me what I need.
For example...currently the gridview displays data like:
In one of my application, I have around 2000 records which i am displaying in gridview with normal paging.
Now I want to change this paging facility and would like to show a "more" button at the footer(just like [URL] has). The moment user clicks it, the next set of data will be retreived. This will go on till all the records are fetched.
I have a gridview with 20 records and I have scroll bar to scroll down to view the records.I m displaying respective row data when click on the select button in grid view. The problem is whenever I select the
row, the gridview refreshes and scroll bar is going up. Ofcourse it is displaying correct data. but the gridview refreshes and scroll bar goes up.I want the selected row to be shown when I select that row.
I'm using the following code to retrieve the contents of a folder and display the info in a GridView - all good.
[Code]....
This works fine, but it returns ALL available data about the files, and I'd ideally like only a few of the columns. I'd also then like to be able to order the columns.
I am facing issue with displaying data in gridview Control. GridView is displaying data Twice . One with stylesheets applied another Just a plain text without styles. I checked t in the data base . I am receiveing the single data. There is no issue from the datadase Query. And also i tested data with a gridview without any panels and styles applied. It display only single data.
I'm trying to display soma data in a gridview. This is my table below:
ID Book Rating
1 MAGIC IN THE OUTFIELD 5 2 ONE GIANT LEAP 2 3 SPIDERS na 4 RULES 5 NO TALKING 1 6 NO TALKING 7 MAGIC IN THE OUTFIELD 3 8 SPIDERS 4 9 NO TALKING na 10 ONE GIANT LEAP 3
What I need to display in the gridview is this:
Book Average Rating MAGIC IN THE OUTFIELD 4 ONE GIANT LEAP 2.5 SPIDERS 0 RULES 0 NO TALKING 1
The problem is the database that I'm working with, as you can see some fields in the Rating column are empty or 'na'. How can I calulate the Average for each book.
I have one filed that is encrypted using Rajindal algorithm and stored in MSSQL db.When I retrieve that column in gridview it's displayed in encrypted. I have the code that decrypts it but the problem is:How can I all loop throw this column values in the gridview and decrypt them all and display it in the gridview decrypted.See my code below:
How to read this file and bind data to gridview control.
Right now i am using the following code but it stores whole data in a single column and a single row but i need it in four columns named NC, WC, PRC,ETAC and it's values in respected columns.
how to get data in four columns in Gridview as a tabular format. I am using technologies Visual Studio 2005, ASP.NET 2.0,C#.NET 2.0 and Windows Xp Operating system.
select distinct tbl.emp_code, b.EmplName, convert(varchar, tbl.punched_date,101) as Punched_date, (select convert(varchar(8),itbl.PUNCHED_TIME, 114)+', ' from Trn_Capture_Data_New itbl where itbl.EMP_CODE=tbl.emp_code and itbl.PUNCHED_DATE=tbl.punched_date and itbl.EMP_CODE='4' and tbl.punched_date >= '03/27/2013' and tbl.punched_date <= '03/28/2013' for xml path('')) Punched_Time
Now i need to Bind it to gridview, the gridview columns should be
Date,IN,OUT,IN,OUT
In punched time the first one should be IN and second OUT. A employee would have punched several time a day. Based on that I should take maximum punches and bring that of columns as IN and OUT in gridvew dynamically. How to achieve this?