I have a table called TABLE_PRICE. Which SQL give me RUNNING_SUM_OF_PRICE output? This is the running sum of column Price in the TABLE_PRICE. Date is increasing sequentialy.
TABLE_PRICE
Date
Price
2010-01-01
1
2010-01-02
2
2010-01-03
3
I have an Asp.Net web application system ,just wanted to know the procedure for increasing the idle time of a webpage
View 1 RepliesI have a problem, where i'm trying to find if a file exists, and if it does, update a textbox to the next number. These filenames with either start with one or two zeros (they are from a digital camera)My code goes like this:
[Code]....
The number increment is working, but if i start with 0053, the next number it puts is just 54. I need to keep the zeroes.
iam using asp.net with c#, iam having images in page .when i click on image the image size should be increase in the same window.then when i click again it should go to another page for edit.
View 1 RepliesI have an ASP.NET AJAX autocomplete extender with CompletionListCssClass=autocomplete_completionListElement :
.autocomplete_completionListElement
{
width:500px;
margin : 0px!important;
background-color : inherit;
color : windowtext;
border : buttonshadow;
border-width : 1px;
border-style : solid;
overflow :auto;
height : 200px;
text-align : left;
}
But for some odd reason the width of the auto complete list always takes up the width of the textbox even when I set the width to 500px.
I've got a loop that executes the stored procedure in a loop with over 40,000 iterations, like so:
SqlCommand command = new SqlCommand("WriteDataToDB");
command.Connection = _connection;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@SignalID", SqlDbType.Int).Value = Arg_Signal.SignalID;
command.Parameters.Add("@SignalStrength", SqlDbType.Float).Value = Arg_Signal.SignalSiggestion;
command.Parameters.Add("@Time", SqlDbType.BigInt).Value = Arg_Signal.TimeWasHit;
command.Parameters.Add("@Value", SqlDbType.Float).Value = Arg_Signal.ValueWasHit;
if (command.Connection.State != ConnectionState.Open)
{
command.Connection.Open();
}
command.ExecuteNonQuery();
This code is called from a loop where I intercept and time every 1000th iteration. The times I get are below:
[0]: "Started 0ms"
[1]: "1000 done 578.125ms"
[2]: "1000 done 921.875ms"
[3]: "1000 done 1328.125m"
[4]: "1000 done 1734.375ms"
[5]: "1000 done 1140.625ms"
[6]: "1000 done 1250ms"
[7]: "1000 done 1703.125ms"
[8]: "1000 done 1718.75ms"...........................
I have an application (asp.net 3.5) that uses a fileUpload control. I have the entry in web.config set to:
<httpRuntime executionTimeout="3600" maxRequestLength="2097151/>
If I try a large file upload (around 20M), I get the "Internet Explorer cannot display the webpage" error. This code worked on another server and works locally, but when put on a new web host's server, I am getting this error all of a sudden. Is there any way I can get more information as to the cause of the error? I set my browser to uncheck "Show friendly http error messages", but I don't get more information.
I want to implement the following page by Asp.net version 4.0 and ajax but I want to have loading by order like loading item 1 and 2 and so on. I have container or web part but mostly container like simple asp.net panel. how I can implement it ? I used updatepanel and update progress but it doesn't work that I have expected before.
View 3 RepliesI am using materpage for building my website....In the masterpage i used a table with two columns . In that table in one column i defined leftmenu and the other i placed content place holder. While building the child pages. I am placing all that required in content place holder. while doing that in one of my page i used GridView. When the GridView Size is increasing the left menu is also being disturbed.
View 2 RepliesI have recently moved our ASP.NET session state from InProc to a Sql Server solution. I can see session data being inserted into the Sql Server database. I'm monitoring the w3wp.exe process using the "Private bytes" & "# Bytes in all heaps" performance counters.As I navigate through the website it places data into session, however the private bytes counter still climbs on the server hosting the website? I thought the session data was being written to the database and not being stored in memory? The managed bytes remain constant, and I'm pretty sure all the objects going into the session are managed types.
View 1 Repliessee my jpg picture to identify problem easly
[URL]
when i change quantity up it s increasing 1 but sum doesnt increasing if i click twice its increasing but wrong where i am doing wrong
my code is
[Code]....
I am executing a long-running Oracle stored procedure from .NET. The procedure takes about three hours to run. Ideally, the user should be able to kick off the procedure, close the browser, and come back later to check the results.
The problem is that the connection to the Oracle procedure is lost after exactly an hour. As you would expect, the Oracle procedre runs to completion if it is executed from SQL Plus. Strangely enough, it will also run to completion if I run in debug mode on my local machine (I start two threads, one of which executes the procedure. I set a breakpoint on the second thread).
Here is my connection string:
data source= (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=serverx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TestSID)))
Some relevant sections from web.config:
<sessionState mode="InProc" cookieless="false" timeout="3000" stateNetworkTimeout="72000"/>
<httpRuntime executionTimeout="18000" maxRequestLength="2097151" />
Any thoughts as to why the connection is being lost in exactly an hour, and what I can do to maintain the connection until the procedure finishes?
I have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
View 5 RepliesA customer reported that our asmx web service is continually increasing in memory (mem usage as well as private bytes). We are able to reproduce the problem in our lab with Windows 2003 Server SP2 (fully patched) on some of the machines. The customer is using Windows 2008.
We created a Hello World web service targeting the 2.0 framework built under VS2005 SP1 and a test client that continues to call it. The memory increases steadily - approximately 40K per client request. If the test app is paused, the memory remains the same. When it is closed, the memory drops. Explicit calling of GC.Collect does not drop the memory.
We have run the memory profiler on the service and the leak is all native memory. We have uninstalled/re-installed the Framework on one of the machines but no difference. To our knowledge all of the security and IIS settings are not modified. We have compared app pool, default web site and virtual directory properties to machines that have no problem and they are identical.
i used below code for date time picker validation but it's not working.
Actually I want a date time picker which date dd/mm/yyyy format date. With validation for start and end date. Also for manual entry it should take only no. and for date rest like / or, will be auto formatted.means user should not be able to enter it.
I m using c# .net 2008.
[code]....
How to create Jobs, I am using SQL 2005, i need a query which should get current date and compare current date with date in table and Send Email according to Job scheduled.
View 4 RepliesI have a window that has 3 dropdownlist controls and a textbox with a Calendar Extender associated to it.
I have the following on my pageload event so when the Page loads the current Date is put in the date textbox:
[Code]....
I can change the date fine but when I select a value from one of the other dropdownlist controls it puts the date back to today's date...The only place I am setting the Date to the current date is in the pageload event...
how can I get it to keep the date to what I change it to after I select a new value from one of the dropdown lists?
I am filtering dataview using my Date Column but the result is not proper because the Field value also stores time, so I want to convert this Date Field to only Date during Filter. How can I achieve this? Here is my code. And the actual value I am getting in the Dataset Field "CreationDate" is a DateTime field which is like
2010-01-21 14:35:25.203
2010-01-22 12:55:18.033
2010-01-26 12:10:06.990
But I only want to neglet time value and want to compare Date only.
[Code]....
I have calenderextender in my asp.net 2.0 application, I need to show only first date and last date of the month in calenderextender... other dates will be visible false...
View 2 RepliesI am using AjaxCalendar Toolkit :
<asp:TextBox CssClass="form-control" ReadOnly="true" runat="server" id="StartTime"></asp:TextBox> <asp:CalendarExtender ID="Start_CalendarExtender" runat="server" Enabled="True" TargetControlID="StartTime">
</asp:CalendarExtender>
<asp:TextBox CssClass="form-control" ReadOnly="true" runat="server" id="EndTime"></asp:TextBox> <asp:CalendarExtender ID="Start_CalendarExtender" runat="server" Enabled="True" TargetControlID="EndTime">
</asp:CalendarExtender>
And On Page Load i have done this to avoid selecting previoud dates in start date :
protected void Page_Load(object sender, EventArgs e)
{
Start_CalendarExtender.StartDate = DateTime.Now;
}
Now i want to do that user cannot select end date less than start date , e.g if he choose 2-July-2014 ( as a start date) then he could not choose (1-July-2014) as End date , dates prior to Start Date must get disabled in End Date Calendar Extender.
How to get the date at which a record is created in SQL?..i.e, if i add a record to a database table db1 at 8/10/2010 11:30, I want to get the datetime, i.e 8/10/2010 11:30..;.Also let me know how to compare datetime values..
if(8/10/2010 11:30 >8/10/2010 10:30) will work or not?
i have the following query.
[code]....
but if there were no "hits" for a particular date range in the last week i only get the dates returned where there were hits. i need to get all the days returned and where there were no results, i need a zero returned.
hitdate hitsperday
2010-10-07 2
2010-10-06 58
2010-10-04 1645
2010-10-03 1192
what i need to return is this:
hitdate hitsperday
2010-10-08 0
2010-10-07 2
2010-10-06 58
2010-10-05 0
2010-10-04 1645
2010-10-03 1192
1) How can i display the date only till current date in ajax calendar extender ?
2)How to validate the date in one TextBox with the Date in another TextBox ?
i would like to compare the current date with the date entered by user..however, i'm encountering errors so far..
i tried something like this:
<asp:TextBox id="txtDate1" runat="server" />
<asp:CompareValidator runat="server" ErrorMessage="The date must be greater than today"
ControlToValidate="txtDate1" type="date"
ValuetoCompare="DateTime.Today.ToShortDateString()" />
and i got an error stating that the value of DateTime.Today.ToShortDateString() of the ValueToCompare property of "" cannot be converted to type 'date' i also tried ValueToCompare="DateTime.Now.Date()" and i got the same error message.
i already defined culture too in page. but still it's showing enter valid date
my markup
[Code]....