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
View 1 Replies
I have a computed column "Time" in an SQL2005 table that contains minutes, e.g 75 that is created from datediff.
In a GridView control, how can I display it in a HH:MM format ?
I know how to format it when using a datetime field, but this is an integer field.
I can change the "Time" column to another format if required.
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.
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
[Code] ....
I have the above query and that gives me result
Emp_code EmplName Punched_date Punched_Time
4 XXX 3/27/2013 14:22:00, 09:44:00, 10:38:00, 11:01:00, 16:12:00, 18:25:00,
4 XXX 3/28/2013 13:14:00, 09:49:00, 18:02:00,
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?
None of my user controls display on a web form at design time. At runtime they work fine and at design time to design the user controls themselve is fine.
Is there a setting that is telling the controls not to render at design time?
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.
View 3 RepliesThe following works fine and is how I expect:
[Code]....
[Code]....
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 am working on window application with local (service based database ) database. but while i am inserting with this than no data insert into nor showing any error . but when connect with external sql server its working well.
SqlConnection con = new SqlConnection(@"Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database1.mdf;Integrated Security=True;User Instance=True");
using (var cmd = new SqlCommand("insert student (Id,Name,mobile,city) values (@Id,@Name,@mobile,@city)", con)) {
cmd.Parameters.AddWithValue("Id", 126262);
cmd.Parameters.AddWithValue("@Name", "manebde");
cmd.Parameters.AddWithValue("@mobile", 33333);
cmd.Parameters.AddWithValue("@city", "ss");
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("data saved");
}
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.
View 12 RepliesI am experiencing a problem on my aspx page.
I have a web form on which the user fills in a basic data: date (with drop down lists), an asset class (with a radioButtonList that is bound with en Enum) and other simple controls... The, when the form is submitted, I make a query on the database to retrieve my data and bind these data into a gridView.
Here are some bit of codes
protected void Page_Load(object sender, EventArgs e)
{
foreach (int assetclassVal in Enum.GetValues(typeof(AssetClass)))
{
[Code]....
The 1st time I submit the form everything is working well, the second time even if I change nothing in in the web form, the GridView1_RowCreated fires an exception when the property AssetClass is called. The error message is
Must specify valid information for parsing in the string.
This is because rblAssetClass.SelectedValue is empty, but I don't understand why.
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
[Code]....
this is the all of my code
[Code]....
I have created a web service and successfully displayed the data in a TextBox within another Project.
However, I have modified my web service so the data returned will return multiple enteries for the data rather than a singular value.
I would like to display all output fields from my web service into a GridView.
Is it possible to do this without modifying my GridView to display a ListView output etc...
Basically, I just want to place each field into a Gridview.
is there a possibility to do the following:
I have a GridView which has a button in each row. On click event I want to open a new window displaying the xml data of the row.
I tried to this with the following code in the RowCommand - event:
var doc = new XmlDocument();
doc.LoadXml(content);
Response.ContentType = "text/xml";
Response.ContentEncoding = System.Text.Encoding.UTF8;
doc.Save(context.Response.Output);
This always generates a script error:
Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed.
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.
Below is my code:
[code]...
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:
Date1 ProjectCode1 Hours ApproveChkBox
Date1 ProjectCode2 Hours ApproveChkBox
Date1 ProjectCode3 Hours ApproveChkBox
Date2 ProjectCode1 Hours ApproveChkBox
...
I would like to be able to display the information like:
[code]....
Is there anyway to do this using a nested gridview? Or is there a proper way to display this type of format?
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.
why displaying data in gridview that does not exist in database ?
View 3 RepliesI'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.
[code]....
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 created a gridView control and have successfully bound DataTable (dt) to it using
[Code]....
However, I want to add a dynamic hyperlink that will take the user somewhere based on the value of one of the columns in the selected row. I'm not sure how to do that.
How do i show the available data based on the dates? Something like the show only FUTURE dates data.
View 4 RepliesI have a Data Table which Populate from the Stored Procedure which is below
[Code]....
and iam binding the Gridview with Data Table it is working .Now i have to make some thing visible and Invisible based upon some Value like below
Datatable dtTable = (Viewstate)["StatusData"]; // Same Data Table which is Data Source of Gridview Control
[Code]....
Where Status.Open is an integer Enum value like Open = 1 and Close = 2 .row["Status"] is the Text Open and i want to compare with integer valueHow i compare the Values ? i have to use the same Data table or not?
