.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

QA refresh

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
Hi All, I'm in the process of refreshing the prod data of a particular Database to a Test server.It will overwrite the Test DB users with the Prod Users. I can fix the orphaned users on the Test box, but how can i restore the exact permissions of the users on that particular DB because we have users having differnt permissions on different databases.  Is there any mechanism  to restore the exact user level permissions.   Regards, Sandhya            

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"

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">

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.



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 when the cube refresh has completed?

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

SQL Server Management Studio Slow Grid Draw and Refresh

I've istalled SQL2005/SSMS on my development machine and connecting to a local SQL Server 2005. Executing queries is fast but the results grid populating is slow and so is the refresh of the same data. This is not a slow query, its the gridview draw/redraw. I've other PC's with slower processors and less ram with the same software run circles around the SMSS Performance on this Laptop   I've read posts about nvidia graphics drivers and mouse drivers causing issues similar to this. I do have an nvidia quadro x1600M (this is a laptop Compaq 8710w) and switching off the accelerator using Displays/Advanced/Troubleshooting by moving the slider to the middle/center position causes the gird refresh to dramatically increase. It's funny how turning oof the accelerator increases performance.   I have the latest HP nvidia drivers and SSMS is useable without hardware acceleration  but I also develop software that uses directx and its getting really troublesome to work this way.   I am running:   Operating System: Windows XP Professional (5.1, Build 2600) Service Pack 2 (2600.xpsp_sp2_qfe.070227-2300)Language: English (Regional Setting: English)System Manufacturer: Hewlett-PackardSystem Model: HP Compaq 8710wBIOS: EPP runtime BIOS - Version 1.1 Processor: Intel(R) Core(TM)2 Duo CPU     T7300  @ 2.00GHz (2 CPUs)Memory: 3072MB RAMPage File: 515MB used, 4439MB availableWindows Dir: C:\WIN

Application to Constantly query Table Values and Refresh with most recent value

Hello, I must apologize in advance because I am not sure if this is the correct place for this question. I am looking for ideas on how to build an application that in the most basic sense contains a field with the most current data from a table in a SQL Server database (this would be based off of a datetime timestamp in the table). I am new to this kind of problem and am unsure where to start looking for solution ideas. The table value updates variably and could possibly update every second to every hour. I would like to design an application that would be lightweight to both the server and the user's machine. This would take the place of an unneeded report on my Reporting Services server. Any and all suggestions would be welcome because I am not sure of options I even have on this. Thanks in advance for your time and consideration, Matt

Access denied when user clicks refresh BDC column button

Access denied occurs with any non Site Collection Administrator regardless of rights.  It only occurs in this site collections, others they are able to refresh.  In this particular collection they can add a BDC column to a list, edit an item and place/resolve a value in the bdc col; but when they refresh they are given an acess denied.  Any thoughts on what they need read access to?  This goes away if I give site admin privs (dont want to do that) or give them read only access on the web application (dont want to do that either).

close pop up and refresh main page after popup close

I am working on a application in which When user clicks on a button  he should be redirected to facebook login page and after successfull login he shud be reirected back to my page. It all is working fine but now I have to do like thiswhen user click on the Button the the facebookbacklogin page shud be opened in popUp and when login is done successfully the popup window shud be closed and the main page shud be refreshed. anf If user is already login the popup window shud not be opened.How can i do this..How can I KNow that a popup window is opened and how can I close that??How to refresh when popup window is closed.I ahve to do like on this site..http://blippy.com/

Ajax Refresh Panel

Hi, plz i want detailed explanation about  "Ajax Refresh Panel" like how to use it and what is the use of this control its urgent Thanx

Page Refresh Issue

Hi All,   My web application is on .NET 1.1 using C#. Page is not getting loaded properly, need to refresh page couple of times then the desired functionality works. Let me how to resolve this problem. Was trying to refresh with javascript but not able to write javascript it was getting into loop, page was continuously refreshing.   Let me what coluld be the reason for page not getting worked as expected, only works when page is refreshed. Let me know what what could be the issue, is it server issue where the application is. One more thing application works fine on my local machine when deployed to other TEST envrionment, it does not work.   Please help me on this.   Thanks Abdul 

Refresh Label on web page without postback

Hi , In my web page i got a button and when this button is clicked it will display message on the label. Example : label text changed from "Start" to "Processing to "Completed". Therefore I want to refresh the label text on my web page so from user site they are able to see the text on Label is changing.. Thanks Linoo  
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