DataSource Controls :: Calculate Average Duration To Cover A Route Trip?

Jan 10, 2010

I want to calculate average time to cover a duration of a route.

A route can have multiple trip between different time slots.

trip have TripStartTime and TripEndTime.

For more clear of the Qns for Qns please go to this URL and for table structure please go to this Url.

Trip Time = TripEndTime - TripStartTime from columnin the table.

I have to calculate Actual trips time for different time slots group by Fleet Id which is related to route no in another table..

View 2 Replies


Similar Messages:

DataSource Controls :: How To Calculate 3 Days Average

Feb 26, 2010

how to calculate 3 days average

View 4 Replies

Social Networking :: Calculate Distance / Duration Of Travel And Draw (plot) Route On Google Maps V3

May 7, 2015

I have 2 texbox and button when i type the address on textboxes it generates 2 google map using google map api and it is working fine.

I need to know how can calculate the distance between 2 addresses?

View 1 Replies

AJAX :: Calculate The Duration Of Dates Between Two Calendar?

Dec 28, 2010

I am writing page to calculate the duration of dates between two ajax calender it is work outside the form view but when i but it inside form view

and if the format for the days is dd/MM/yyyy it is not work in correct way every time

this is the code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

View 3 Replies

Social Networking :: Google Maps V3 - Calculate Distance And Travel Duration Between Multiple Address Locations

May 7, 2015

Its relate to series of question again. I have datalist bind sql server whcih is fetching 3 address like

Address 1

Address 2

Address 3 

After data list I have textbox which is based address like "Based Address"

I have the below script which calculate distance between 2 textboxex.

I want to to calculate the distance between base textbox and address in datalist item so result will like this

Base Address Pune

Datalist address

Address 1 Bombay result distance between pune and bombay 200 Km

Address 1 Kolkota result distance between pune and kolkata 500 Km

//*********DISTANCE AND DURATION**********************//
var service = new google.maps.DistanceMatrixService();
service.getDistanceMatrix({

[Code].....

View 1 Replies

DataSource Controls :: How To Run Stored Procedure After A Specified Time Duration

May 24, 2010

ALTER PROCEDURE [dbo].[backup_database]
(
@DbName VARCHAR(250),
@dbpath VARCHAR(500)
)
AS
DECLARE @Currentdate VARCHAR(10)
DECLARE @Currenttime VARCHAR(15)
BEGIN
BEGIN TRY
SET @Currentdate =CONVERT(VARCHAR(10),GETDATE(),105)
SET @Currenttime = REPLACE(RIGHT('0'+LTRIM(RIGHT(CONVERT(varchar,getDate(),100),8)),8),':','-')
SET @dbpath = @dbpath +'' +@Currentdate+'_'+@Currenttime+'_'+@DbName +'.' + 'bak'
PRINT @dbpath
BACKUP DATABASE @DbName TO DISK = @dbpath
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() as ErrorNumber,
ERROR_MESSAGE() as ErrorMessage
PRINT 'Backup Could not be taken for '+@DbName+''
END CATCH
END

I want to run the above procedure at an interval of 8 hours.

View 5 Replies

Social Networking :: Google Maps API V3 - Calculate Distance And Plot Route Between Two Locations

May 7, 2015

I want to  create a google maps that it can Calculate Distance, Travel Duration, draw (plot) Route  between two locations and display Directions. Now I want to hide Directions Panel.

View 1 Replies

Putting Average Of Column In Footer - Can Get The Average Of All The Numbers In The Column?

Dec 3, 2010

I am able to sum an entire column and put the total in a column, but what if i want to get the average of all the numbers in the column?

[code]....

View 1 Replies

DataSource Controls :: Calculate SQL Datediff For All Records?

Jun 17, 2010

I am trying to write some SQL to populate a gridview.

The sql should print out 3 columns:

Name, County, LastCollection (the amount of days since the last collection)

I have previously calculated the amount of days since last collection individually like this:

[Code]....

But am stuck on doing it for more than 1 record to populate the gridview which should show all the records and their last collection date.

View 9 Replies

DataSource Controls :: Calculate Percentage From Table?

Jun 22, 2010

I have a table that contain the votes(publicVotes) against each contestant. Now what i am trying to do is to calculate the percentage of votes each contestant recieved according to the column SchedularID. how i can get it done and would it be easy to user store procedure or view?

ID
ContestantID
SchedularID
PublicVotes
JudgesVotes
1
4
2
4
NULL
2
2
1
1
NULL
3
3
2
2
NULL

View 10 Replies

DataSource Controls :: Calculate The Slope Of A Dataset?

May 19, 2010

I have a certain report I want to make where I want to calculate the slope of a dataset(turnover column) following the formula:

SumXY-MeanY*SumX / SumXX-MeanX*SumX

In order to do that the X-range has to be an integer from 1 to the last datarow. In my report I get this exact number with the rownumber(nothing) formula. But it seems I can't calculate with it in the expression for the slope because it gives errors:

=(rownumber(nothing)-Avg(Fields!TurnOver.Value)*Sum(rownumber(nothing)))/ ((Sum(rownumber(nothing)*rownumber(nothing)-avg(rownumber(nothing))*sum(rownumber(nothing)))

View 1 Replies

DataSource Controls :: Calculate Repeated Chars In A String?

Jan 8, 2010

I have problem like to count the repeated chars from a string using sql server.Also i have used functions in sql server thats working fine.But i want the solution using a sql query...

[i have a column like ID,name,Secure_name],here 1 ,'kamal','welcome'.so findout 'e' howmany times repeated in a column secure_name.....

View 2 Replies

DataSource Controls :: Calculate Financial Year In Sql Server?

Jun 17, 2010

I need financial year in system date.actually i calculate financial year like below in VB code. [Code]....
i just like the same in sql server query.for example suppose my query like"select*from admission where std_code=1 and fnyr in (select finy in system date)"<---i need here.

View 18 Replies

DataSource Controls :: How To Calculate The Total Quantity Demanded By A Particular Customer

Mar 22, 2010

We have a demand system where customer can demand the quantity they want for a particular deal.

For each demand they submit, a new record is added to the DealDemandRequest table with the CustomerID, DealID, Quantity

I want to be able to to calculate the total quantity demanded by a particular customer. Current I query the DealDemandRequest table for all the records by a particular customer and then do a sum of the Quanity column.

However, we are expecting this table to be over 1 million record and it is reallly really slow right now.. Any better ways?

View 3 Replies

Forms Data Controls :: Calculate To Current Rowafter Update Quantity But Other Rows Don't Affect And Not Calculate

Jan 6, 2010

my code is calculate to current rowafter update quantity but other rows don't affect and not calculate i need to calculate all rows i think i need to use for loops but i dont know how to do it

[code]....

[Code]....

View 7 Replies

DataSource Controls :: Linq To Sql - Calculate Shopping Cart Total Amount

Jul 9, 2010

I am trying to calculate the total amount of shopping cart by multiplying the quantity with the product price and then sum up the sub results.I am doing this but it does not make the multiplication.

[Code]....

decimal? TotalAmount = (from shopCart in dc.KP_ShoppingCarts

View 1 Replies

DataSource Controls :: How To Calculate Current Financial Year Using Stored Procedure

Mar 6, 2010

I want to calculate the current financial year in my stored procedure and use it when generating a unique Id for the customer registring in my system.

View 2 Replies

Forms Data Controls :: GridView,calculate Value Based On Other Columns& Save To Datasource?

Nov 8, 2010

I had just started with Visual Studio 2008 + VB.net. I've now designed my tables, and basic gridview functions properly.Now I'm faced with the problem of having to calculate a value based on 2 - 3 columns/data in the gridview, display the result in an existing column in the same gridview, and saving the calculated value in the datasource.I had initially created the "Total" column as a textbox displaying a manually calculated amount that is saved in the datasource. Now, I want to change the field to auto-calculate based on 2 other columns.

View 4 Replies

Forms Data Controls :: Showing Average In The Footer Of Gridview?

Jul 1, 2010

I have a gridview, I am binding the gridview with a datatable and in the gridView, my autogenerateColumn is set to true since I am generating the columns dynamically coming from database. I am also doing doing showFooter =true. There are values in the rows of these dynamically generated columns. I need to calculate the average of each of these columns and display it in the footer. so for e.g, I have

A B C
10 11 12
13 14 15
16 12 11
-- -- --
13 12.3 12.6

View 19 Replies

Forms Data Controls :: Obtain The Average Price From A Particular State?

Feb 18, 2011

I have a table that includes a state column and a price column.

I am able to obtain the average price from a particular state using:

SELECT avg(Price)
FROM MainTable
WHERE StateId=x

I would like to display the average price from each state. The only way I know of doing this is 50 seperate datasource controls. Is there another way?

View 1 Replies

Forms Data Controls :: What Are The Average Number Of Records To Bind With A GridView

Aug 4, 2010

I am having some issues with the performance. I am binding a Gridview with around 200 records and it is taking a long time. At one time I only display 10 records on the page, but I bind all the 200 records.

Generally what is the number of records that should be bound to a gridview ?

View 2 Replies

Forms Data Controls :: Display Average Of Rating In Starts Not Numbers?

May 7, 2010

I have a small table that has ratings for a album let's say.

Instead of showing the rating from 1-4 I want to show start instead

Rating 1 the 1 star
Rating 3 3 stars
Rating 0 no star
etc.

I have an tiny int field in the table and I will make a drop down list to allow 0-4

Currently I have a list view to show the list of comments and ratings but not sure how to convert the 0-4 from tiny int to a the same amount of stars

View 2 Replies

MVC :: Webforms Route / Implementing Route In Global.asax

Mar 13, 2011

I tried to mix asp.net 4 webfrom and ASp.Net MVC 3. I add required lines in webconfig, but I've issues implementing route in global.asax

Currently I use several routes for webfroms. routs template are like below

routes.MapPageRoute("Node", _
"article/sport/{nID}/", _
"~/article/articleview.aspx")

I encounter error, when I add below lines to global.asax

routes.MapRoute( _
"Defaultss", _
"{controller}/{action}/{id}", _
New With {.controller = "Home", .action = "Index", .id = UrlParameter.Optional} _
)

I want to know how could I mix ASp.Net MVC routes with webforms routes.

View 3 Replies

Forms Data Controls :: "undisplay" The Items User Clicked In ListView Without DB Trip

Feb 2, 2010

I'm displaying a bunch of items in a ListView. Each item has a button that the user can click if he/she is not interested in the item. What I want to do is this: if the user clicks the button, I want to remove that item from the list but I don't want to necessarily make a datadabase trip for each and every item the user clicks. I'd rather make one DB trip and take care of all the items user has clicked. However, as the user clicks them, I'd like to remove them from the ListView.

View 2 Replies

Forms Data Controls :: Generate A Report For Each And Every Student With Their Details And Average Marks In Each Subject?

Jun 2, 2010

I have created a student webpage with many tables like student info,test1 marks,test 2 marks and so on now i have to generate a report for each and every student with their details and average marks in each subject

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved