I had a friend ask me about writing a program that would allow data entry and then run and display a report each day at 11:00 am. What is the best/easiest way to make the report run at a specified hour? He wants something that can run on a standalone (laptop) computer running windows xp. Most of my experience is with asp.net and c#.
I am developing an intranet web application. i am using asp.net,C# and MS sql. Now i want to make everyone hour to bring a grid view page with lists of names whose contractperiod is expiring soon. So how do I make an asp.net page to be pop up every hour.
i have used the Created_Date = DateTime.Now, to set the default value of a datebut i want that date to include inaddtion to the day the hour minutes and seconds
I want to call a function on every after one hour. I wrote this function in Global.asax file on Aplication_Start event. Its work fine in Local Host but not working after publishing it on web server.here is my code:
I have a page that does an upload of an xlsx file to a datatable and write into SQL.
That is working, my problem is when i upload the file and pass the values to the datatable some of them are showing in the wrong format and the column name dont appears.
e.g.:
Hours at home Hours working 3:00 8:00 01-01-1900 1:35:00 01-01-1900 2:35:00 01-01-1900 3:35:00
The first 2 columns its how i want the info the third is how my problem looks like.
I've tested and the problem occurs when the same column has more than one value.
The format of the cells is h:mm if i change it to text it works fine but i dont want that because the time will be converted to semething like this 0,123456789.
I dont know if it matters but the xlsx file is kinda complex and has 10,2MB.
i have a table which records visits to a page, what i want to do is get a count of the last 24 hours and group the visits by the hour.
This is my table structure;
ID, ChannelNewsID, AddDate
This is what i did so far however it gives me both past and future records where as i want 24 hours previously starting from when the query was run. Here is what my query looks like;
i have a problem with web application bulit on vs2005,an application work client/server .the application End event fire every 1 hour almost,although there is no changes on web.config or deleting files!
("Working_Hour") = (Convert.ToDateTime(dr(4)) - Convert.ToDateTime(dr(3))) + (Convert.ToDateTime(dr(6)) - Convert.ToDateTime(dr(5))) + (Convert.ToDateTime(dr(8)) - Convert.ToDateTime(dr(7))) '"if entries are 6 then add this line in working hour
I want to organize twenty-four-hour local network monitoring. Could you tell me about such program? The program has to ping hosts and save results in files on hard drive for viewing.
I keep getting errors when I try to convert. I have a date row that when my page loads it displays as
1/28/2010 12:00:00 AM.
I have my default value set to '00:00:00" for it. I'm trying to convert it to 24 hour format so that it will read out as 00:00:00 initially. SQL Statement(The one that is working)
SELECT user_id, bpi_title, HoR, Date, Duration FROM tblViewLog2 JOIN tblBPIModules on tblViewLog2.module_id = tblBPIModules.id
I assume that I need to modify my SQL statement, but I'm having a hard time with the exact syntax. I'm trying to figure out exactly what I need to do with the information below in order to get what I want.
14 or 114 24 hour time with milliseconds. HH:mm:ss:fff 21:00:00:000
cancel plane ticket before 4 hours of departure time if dep time is 08:00:00 AM then Passengers can cancel ticket till 04:00:00 AM? I have two textboxes textbox1 and textbox2 in asp.net(vb) webform I want If in textbox1 the time would be appear as 08:20:20 AM Then in textbox2 the time would be automatically generated 4 hours before as compared to textbox1 i.e ( the time in textbox2 the time would be appear as 04:20:21 AM ) Means simply logic i want ... if the time in Textbox1 is 08:00:05 PM then autogenerated time in textbox2 will be 04:00:06 PM Means whatever the time in Textbox1 the textbox 2 will autogenerate time in 4 hours time slot.
I am using time picker control which you have created but I stuck in one issue. Iam using 24 hour format. but i its throwing in msg box standard hour instead of 24 hour format. How to get 24 hour format.
DateTime time = DateTime.Parse(string.Format("{0}:{1}", TimeSelector1.Hour, TimeSelector1.Minute));
I got a code from internet for creating Crystal reports in Visual studio 2008 .net. It shows on how to pass parameters from web form to Crystal reports. Everything is ok, except the report crystal report viewer. How can I declare and assign report crystal report viewer manually in Visual studio .net?.
Is it possible to show 3 "Crystal Report" in single "Report Viewer Control" page??My current code for 1 Crystal Report and 1 Report Viewer control Page is below:Below code Page name is "JpsCrystalReport.aspx"
using CrystalDecisions.CrystalReports.Engine; //for crystal report using CrystalDecisions.ReportSource; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString);
[code]...
I want that when i click on button it redirects to "JpsCrystalReport.aspx" page as per condition given. Then on "JpsCrystalReport.aspx" page it should execute the 3 crystal reports as per conditions given on button click.Or I had to create 3 different "JpsCrystalReport.aspx" pages (that contains Report Viewer control) to show 3 Different Crystal Reports as per condition on button click?