Can anyone help with with bit of code,i get a time value and store it in a variable,i want to update the variable every second so that it looks as if the variable is displaying the current time,how can i use count++ to update the time every second.
[Code]....
[Code]....
[Code]....
I recently re-develop our company's web system. However, when I just finished everything, our internal user complains that the page is noticable slower than the old one. I tested it on my machine and it seems to be ok. As it is a major concern of my manager, I decide to add a bit of code to return the time comsumed in page loading. Can someone give some idea about it? What I try to know is: from the time user click on "submit" button until the page is fully loaded to the user, how many seconds it costs. I have ajax in the page. Is it possible to do it in js? or any other sort of way is fine too.
View 10 Repliesfind page load time,i want to put some progress gif or animation untill the fully page load with all it content
for example.....u have familiar with facebook or orkut u will find some progress animation untill the all data content load
Is there any other way by not using updatepane...ajax
This is the sqlDateTime overflow problem again. Background. As I'm sure you know dates must be between 1/1/1753 and 12/31/2999. If you have an empty date field, it throws and exception. So I created a function (below) that solve the problem when attempting to update or insert a record with a date field. Works great.
Public Shared Function MakeDateField(ByVal pasDate As String) As Nullable(Of DateTime)
If IsDate(pasDate) Then
Try
If pasDate <= System.DateTime.MinValue Then
Return Nothing
Else
Return CType(pasDate, DateTime)
End If
Catch ex As NullReferenceException
Return Nothing
End Try
Else
Return Nothing
End If
End Function
So I thought about using a time field. I have the field, have the validator in place and then attempted to test the page. It resulted in my least favorite error message "sqlDateTime overflow".
I can think of several workarounds like adding a date or a fixed date to the time field, or converting it to a string. Each of these is problematic.
IS THERE A BETTER WAY TO UPDATE/INSERT TIME FIELDS.
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 have an aggregate stored procedure (named sp2) that returns a count of records meeting a certain criteria ASrecCount. I am using a DAL per the ASP.NET tutorial and have created a Table Adapter (named
sp2TableAdapter) with GetData and Fill methods. I have a button on an ASP.NET page that launches an event handler. In the button's event handler, I have this line: sp2TableAdapter sp2 = new sp2TableAdapter();
What works so far:
This code will bind the value of sp2 to a data control:
sp2TableAdapter sp2 = new sp2TableAdapter();
DropDownList1.DataSource = sp2.GetData();
DropDownList1.DataValueField = "recCount ";
DropDownList.DataTextField = "recCount";
DropDownList1.DataBind();
When running this page and clicking the button, the numeric value of recCount returned from sp2 is bound to the DropDownList control and 1 row is poplated with the recCount value (in my case 1451).
Problem:
In the event handler, I do not want to bind the value of recCount to a control, but want to to use it in some logic as an integer. What is the C# code that will do this? (In place of the DropDownList control lines above)
how to count that "/" is include n times in the URL
[URL]
I created the form in which i am showing count down time in label.
below is the code
[Code]....
Even i show the time in various format means Hour, Seconds, Tick but difficulty is that i want to show time in "hh:mm:ss" format & Time in label will be decreasing.
I need to synchronize the count down time for all users.So it will display identical remaining time to all in asp.net.
View 1 RepliesDateTime dt6 = DateTime.ParseExact(strvalue.Trim(), "hh:mm", null);
DateTime Test4 = DateTime.ParseExact(strvalue.Trim(), "hh:mm", null);
if(Test4!= Convert.ToDateTime(Test4.ToString("hh:mm")))
message= "Error" i get the time vvale in strvalue.Trim() ,
if the value is something liek 100 or anything which is not a valid time it should go in the if condition...
i use asp.net and ajax
I have a button and I want to count that, how many times was the button clicked in 1 minute.if the user clicked the button more than 5 times in 1 minute it will be deny for 5 minute.
I have a column in a table within my SQL database that is specified as a time variable. Not DateTime or Date, but just Time. So, I need to know how to convert a text string into the format that would be accepted for entry in the Time column of a table in SQL. I know how to convert dates, but not time.
View 4 RepliesI have a column in a Table within an SQL database that is defined as DateTime. I tried to store time data in it, but could only store date information. Am I doing something wrong?
View 6 RepliesI need to do an update a field in database every x minutes. ie: a person login and I need to update a field related to they every X minutes until the value reach a value. Like this, this person start a count event from 1 to 10, they log off the web, but this count must remain countting until reachs 10, 1 by 1 every 7 minutes. I cannot do a SQL Job. Should I User a System.Timer??? Should I record the time and value of the last update, when the person log in I cauculate and update the value??
View 4 RepliesIn the GridView_RowUpdated event the e.OldValues.count <> e.NewValues.Count. 1 out of 5 columns has been converted to a template field.
View 9 RepliesWhen a user submits the query to SQL when clicking a button I need to get a count of the number of rows that are returned. Which event does the gridview.count code need to be place in?
Right now I have it in the btn_click event, but in order to get it to count the rows you have to hit the button twice since the query is not returned yet. Here is my code.
[Code]....
Given a Database that has a table Called [Bid Transactions], which contains records of all available auctions that are currently running on an ASP.net website .. something similar to Ebay.com, when the deadline of the auction passed, I should close that auction, Send a notification message to both the item owner and the bidding winner to inform them.
how should I keep track of all open auctions? how could I monitor all their ending time and update the Auction status to be "Closed" on Real-time basis? ..
(1) Using SQL jobs ? .. that should reduce system performance .. shouldn't it ?
(2) A back-end service that is running on the server and uses Threading ? .. I have no clear background about that solution.
I have a requirement like need multiple update panel in web page and also i want to load only one (targeted one) update panel content when I click button on another update panel.
View 1 RepliesI'm not really much of a programmer but I've been working on something in visual web developer and VB...'ve got an asp.net page with a fileupload control and two buttons. One button is used to upload the file and then the other button does something else which involves accessing the file name of the uploaded file.
This is straight forward enough if you just use static text but I wanted to create a unique file name for the upload so thought about using a date/time value for this and delcaring it as a variable?This works great but how does the second button then access this file name? If I use the same variable name declared earlier it just generates a new one especially if mins and secs were used?
I'm not sure if that makes sense? But I'm basically wanting to create a unique file name for the uploaded file and then store that in a variable so it can be accessed by the other button? Without the variable constantly updating to a new ID?
I believe my SQL statement is sound. UPDATE [062610] SET abc = @abc FROM [062610] WHERE (dayID = @dayID) I cant seem to get my stupid variable @abc to sync with my GridView update command. I understand that I can let the GridView take care of my editting for me without having to write any code. But, I am running multiple tables and will be eventually needing to do this manually. Or at least as far as I know.
View 3 RepliesI'm trying (poorly I might add) to set up a select statement and due to my noobishness I simply have not found a way to do it RIGHT. Then again - I'm probably starting entirely wrong - but I've gotta' learn somewhere.I'm attempting to track product usage (think mild inventory tracking). In the system, I have independent parts and builds (combination of independent parts) - each has its own SQL table. Each time a "build" is completed, I want to update my part inventory with an updated count of that item.
Build_tbl
Build_ID (int/spec)B_nameB_desc
Part_tbl
Part_id (int/spec)P_nameP_cost
Build_asmb_tbl
[code]...
i have two clock times in my DB as varchar datatype.. i loaded it from db as varchar itself. in C# i have assigned this value to a datetime variable.. how can i get the time from the datetime variable without changing it into a string.
View 4 RepliesI have a typical scenario that I'm struggling with from a performance standpoint. The user selects a value from a dropdown and clicks a button. A stored procedure takes that value as an input parameter, executes, and returns the results to a grid. For just one of the values ('All'), the query runs for roughly 2.5 minutes. For the rest of the values the query runs less than 1ms.
Obviously, having the user wait for 2.5 minutes just isn't going to fly. So, what are some typical strategies to handle this? Some of my own thoughts:New table that stores the information for the 'All' value and is generated nightlyCache the data on the caching server
I have defined a column in a table I have in an SQL database as being a Time variable and not DateTime. How do I convert the time data that I get from my table into a text string using C#?
View 6 RepliesI have a problem with SELECT COUNT query in ASP.net. I want to create CMS with articles which have categories (which have the option to be deleted). The problem is that I want to get the number of articles within the specified category so if there aren't any articles with the specified category I can proceed with the category deletion.I have the following code:
[Code]....
After I click the button "Obriši" (Delete) I receive the following error: "Must declare the scalar variable "@KategorijaID"." I understand that the problem is with parameter, but I don't know how to correct it to use it for both the "command" and "brisanje" SQLCommands.