Thursday, May 10, 2018

ASP .NET AJAX - Maintain Or Set Page Scroll Position After Asynchronous Postback In ASP.NET AJAX

Now just add the below JavaScript code to the relevant section of your Web Page.

  1. <script type="text/javascript">  
  2.     var xPos, yPos, needScroll;  
  3.     var prm = Sys.WebForms.PageRequestManager.getInstance();  
  4.     prm.add_beginRequest(BeginRequestHandler);  
  5.     prm.add_pageLoaded(EndRequestHandler)  
  7.     function BeginRequestHandler(sender, args) {  
  8.         xPos = 0;  
  9.         yPos = window.pageYOffset || document.documentElement.scrollTop;  
  10.     }  
  12.     function EndRequestHandler(sender, args) {  
  13.         if (needScroll) {  
  14.             window.setTimeout("window.scrollTo(" + xPos + "," + yPos + ")", 100);  
  15.         }  
  16.     }  
  17. </script>  

After adding the above code at page script Tag on your code behind you need to add the below code at your .cs page to call the Javascript function after page completes its rendering after postback.

ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "ScrollTo", "var needScroll = true;", true);

Monday, May 15, 2017

How to fix ORA-01502 index or partition of such index is in usable state

If you get the error How to fix ORA-01502: index or partition of such index is in usable state in Oracle. It is possible that an index is broken from a table.

To fix this error, you can do the following:

rebuild the index with the following SQL command:

ALTER INDEX your_index_name REBUILD;

Thursday, May 11, 2017

Response.Headers -->This operation requires IIS integrated pipeline mode.

Try the following Solution:

Your Application Pool is in classic mode but your Application need integrated mode to fire. change it to Integrated Mode:

  1. Open IIS Manager
  2. Application Pool
  3. Select pool that your app are run in it (in case same app pool is used in multiple published web applications, in that case create a new appl. pool for this web application)
  4. In right panel select Basic Setting
  5. Manage Pipeline Mode change to Integrated

Sunday, April 2, 2017

Pen drive show empty even when data exists

Pen drive show empty even when data exists

Check if the files are not in hidden mode.

Click on "Start" -->Run --> Type cmd and press Enter.

Here I assume your pendrive drive letter as H:

Enter this command.

attrib -h -r -s /s /d h:\*.* --> Press Enter

Friday, February 17, 2017

To remove all debug breakpoints in Android Studio

To remove all debug breakpoints in Android Studio, follow the steps given below:

  1. Ctrl + Shift + F8 (open Breakpoints dialog)
  2. Ctrl + A (select all breakpoint)
  3. Alt + Delete (remove selected breakpoints)
  4. Enter (confirm)

Wednesday, January 18, 2017

How to Create users in SQL Server for accessing only one Database using Sql Server Management Studio

Steps Restrict SQL Server Login/User Access to only one database are given below:  

1. Connect to your SQL server instance using management studio
2. Goto Security -> Logins -> (RIGHT CLICK) New Login
3. fill in user details (userid/password etc.)
4. Under User Mapping, select the databases you want the user to be able to access and configure

Here is the list of the ROLES that can be assigned:

db_owner Members of the db_owner fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database.

db_securityadmin Members of the db_securityadmin fixed database role can modify role membership and manage permissions. Adding principals to this role could enable unintended privilege escalation.

db_accessadmin Members of the db_accessadmin fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.

db_backupoperator Members of the db_backupoperator fixed database role can back up the database.

db_ddladmin Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.

db_datawriter Members of the db_datawriter fixed database role can add, delete, or change data in all user tables.

db_datareader Members of the db_datareader fixed database role can read all data from all user tables.

db_denydatawriter Members of the db_denydatawriter fixed database role cannot add, modify, or delete any data in the user tables within a database.

db_denydatareader Members of the db_denydatareader fixed database role cannot read any data in the user tables within a database.

Sunday, August 7, 2016

Back up All databases in SQL Server Instance with one script

This Script will allow you to backup all dbs in the fly. the script looks for .mdf file in your sql instance and back all of the files it find except the system databases...

DECLARE @name VARCHAR(50) -- database name  
DECLARE @path VARCHAR(256) -- path for backup files  
DECLARE @fileName VARCHAR(256) -- filename for backup  
DECLARE @fileDate VARCHAR(20) -- used for file name 

-- please change the set @path = 'change to your backup location'. for example,  
-- SET @path = 'C:\backup\' 
-- or SET @path = 'O:\sqlbackup\' if you using remote drives
-- note that remotedrive setup is extra step you have to perform in sql server in order to backup your dbs to remote drive 
-- you have to chnage you sql server accont to a network account and add that user to have full access to the network drive you are backing up to

SET @path = 'your backup location'  


SELECT name 
FROM master.dbo.sysdatabases 
WHERE name NOT IN ('master','model','msdb','tempdb')  

OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @name   

       SET @fileName = @path + @name + '_' + @fileDate + '.BAK'  
       BACKUP DATABASE @name TO DISK = @fileName  

       FETCH NEXT FROM db_cursor INTO @name   

CLOSE db_cursor   
DEALLOCATE db_cursor