.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to determine when the cube refresh has completed?

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I'm trying run code after a cube refresh is completed, but I can't seem to figure out how to write code to determine when the cube refresh has been completed. If it were a simple calculation, I could use the code below to determine the "calculation state", but there doesn't seem to be "refresh state" that I'm aware of. Any help will be GREATLY appreciated!! Application.CalculationState = xlDone

View Complete Post

More Related Resource Links

determine the best way to refresh a gridview when textchanged event occurs


Good afternoon.

I have the following gridview inside an updatepanel that makes the bind from a datatable:

<asp:UpdatePanel ID="UpdatePanel1" runat="server">
                <asp:Button ID="ButtonAdd" runat="server" OnClick="ButtonAdd_Click" Text="Novo Artigo" />
                <asp:GridView ID="Dados" runat="server" AutoGenerateColumns="False" 
                    CssClass="Grid" Width="100%" CellPadding="4" ForeColor="#333333" 
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                        <asp:Button ID="AbrirModal" runat="server" Text="->" /> 
                                <asp:PopupControlExtender ID="PopupControlExtender1" runat="server"

TFS cube - How to get the list describing remaining work, completed work history?


I made a simple MDX query to get remaining work, completed work of all work items per revision number







    [Work Item].[System_Id].[System_Id] *

SSAS Cube to give an error when cube not available during refresh time



I am currently using the below query to know my last cube refresh time,

My cube refesh time is not fixed , I am trying to create a report which shows a status of cube availability i.e status should show red when cube is not available and when cube returns some value then it's green . How do I do that.

SELECT Cube_Name, Last_Data_Update


How to determine the user that completed a task when the task is assigned to a group?

I am using collect data from a user in a custom workflow.   I am assigning it to a group.   Where is the user stored that actually completes the task?

Determine whether Forms Server is installed on a server

Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

Image processing, determine white space and crop



I have created a image upload for our ID card system to allow users to upload new images, edit them and submit for approval.  This is all working well with a combination of asp.net (c#) and jquery to give a seemless editor etc.

We have had a few users who I cannot believe have scanned a photo of themself and then just submitted it with the A4 page of white and little photo.

I am wondering if anyone can help with a suggestion on how I could possibly reduce the load of these coming through (I can't believe they can be this stupid), it stipulates UK passport standards.

Would my only option be to check for a single continues colour that occurs and if it reaches a certain percentage point say 60% then to just send back an error stating they need to crop the image.

Can anyone help with providing sample or that I can use to move this one on.

I am still in disbelief on this one.  the other one is they take a photo of whole body and other in it and cut straight down middle chopping the people out but supplying a photo that no use for an id photo card....but that I can't imagine being solved programatically as I need to determine where their face dimensions are and what percentage of the actual photo is taken up by it and if it below a threshold reject it.

re load javascripts and jquaries after ajax refresh


I use javascript hints for my textbox and when page loads I set that, but after submiting data for example in the case of error in input and need for inputing again the data it doesn't show the hints, which means that when ajax sends Httprequest and gets Httpresponse and refreshes the update panel , that panel doesn't accept loaded jscripts again, so they should be loaded again.

I do not know how to do that in asp.net, any tips or recomendations?

how to refresh image updated with AsyncFileUpload


I've created an AsyncFileUpload device that uploads an image in ListView but it doesn't refresh on the page until the page is manually refreshed. Any ideas on how to accomplish this? This is the applicable code:

In ListView control:

<asp:UpdatePanel ID="udpPhoto" runat="server">
        <span style="text-align: center; vertical-align: middle; font-size: 7pt;">
            <br />
            <asp:Button ID="btnEPhoto" Font-Bold="False" TabIndex="160" Text="Upload/Change Photo"
                UseSubmitBehavior="False" OnClick="btnPhoto_Click" runat="server" />
            <br />
            <asp:Label ID="lblEPhoto" runat="server" Font-Bold="True" Text="Uploaded Photo:" />
            <br />
            <asp:HyperLink ID="lnkEPhoto" runat="server" BorderWidth="2px" NavigateUrl='<%# Eval("Photo_Recent") %>'
                <asp:Image runat="server" ImageUrl='<%# Eval("Photo_Recent") %>' Height="50px" ID="imgEPhoto">

"Your search cannot be completed because of a service error. Try ..."


i have a problem with search function where everytime i search any file/doc the error message "Your search cannot be completed because of a service error. Try your search again or contact your administrator for more information." occurred. I realized that there are items in central admin but it is "not available" in my site. I already follow several guides that had been provided in this forum but still the same. Even, i already create new SSP and configure the search scope, content source and also crawling. 

FYI, i used Microsoft Sharepoint 2007. 

Hope anyone could help me to solve this problem. Thanks.

Partial Views and Popups...After clicking on Close need to refresh the page....


Hi All,


I amusing the PopUp example as suggestedin the above forum link.....

But now i want to Refresh the page after clicking on Close(x) ...

So please help me....

Please advice...

Thanks in advance...



Refresh Parent on Pop Up Closed


This has probably been answered before but I was looking at some various posts but the needs I am trying to meet just don't see to work.

So here is the scenario:

User clicks the button and a javascript I have registered opens a pop up window and passes a query string

User then is presented with a gridview with a selection to make (the selection event is triggered again through javascript and mouseover event)

The data is updated in the table for the data being displayed in the parent which is all fine

When the page is done with this it closes and refreshes the parent


Now the problem:

All of this works fine up until the point that I close the window and after playing around with different snippets I have come across I just can't get the thing to refresh the parent properly because when I do the refresh I need to pass the current querystring as follows:

        Dim cScript As String
        cScript = "<script language='javascript'> opener.location.href = 'Workstations.aspx?ClientID=' & MyGUID & '&AddNew=' & 'False' & '&WksID=' & WksID'; </script>"
        Page.ClientScript.RegisterStartupScript(Me.GetType(), "parentwindow", cScript)



Hello..  I created a website in which I have an update panel being updated via a timer.  This works fine when there's only a few people online.

But now, during live testing, this bogs down the server because we have 30-60 people hitting the website and this page is being updated via the server.

Is there a way to have the page auto-update itself via javascript?  And how would I go about doing this so only a certain panel is updated instead of the full screen.


Refresh parent window and close popup window.


Hi All,

I've been spent the last couple hours trying to work on this issue. I an creating Facebook Oauth stuff, when i click on parent window. The popup shows the Facebook login, when i logged in with my details, it redirects to my site. But i need to close this popup after returning and refrsh the parent window.

can you please provide me this kind of stuff. i already spent whole day in this... Sealed Cry

If i could solve this then i will go for another logic but stucked on 1st step.



determine the screen height within javascript and set a property on an iframe


I have a webform  that has a header and iframe,  what I need to do is on load detemine the users screen height and then  set the height on the iframe. Can someone explain  or show me an example of how to do this.

Thanks in advance.

Refresh Parent Page


i having a grid and in a grid i have a template feild column called Edit Comment's

as soon as user click on edit comment's a pop up window gets open and user can add the following comment's

and click ok to save

now on my OK Button i have implemented my code to close down the Pop up

but only this is that the changes which are being made are not being displayed untill i referesh the browser

so is there a way where i can refresh my parent page from child popup page

thank you

How To: Refresh Menu or Toolbar content

Hey all...in my WPF main window, I have a Menu defined with several elements and it is using a Markupextension to do the binding of the content.   <MenuItem Header="{extension:method Label}"/>   I want to be able to re-initialize the menu so it refreshes the labels. (I also need to do this on other elements as well) I saw some examples using WeakEvents to do this but it looks like the menu or window has to be bound to it. When I tried this, my EventManager kept on dropping the listener after two passes. Is there another way to do this other than coding it: mnuItem.Header = DomyFunction("Content")   TIA AndrewAndrew MacNeill (MVP VFP)

How to determine if current SQL User is admin or owner?

I wish to determine, from my C# application, if the current user has admin or owner rights to the database they are connected to. I beleive I have all the information required: Servername Database name Windows/Database auth username (If database auth) password (if database auth) I'm trying to find a way that using the smo objects (smo.user), but as of yet I cant quite work it out: - How to get the appropriate user - How to determine if that user is an admin/owner. Any tips would be appreciated. If I have posted to the wrong forum, let me know - I couldnt find one that was obviously more appropriate. Thanks.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend