https://www.aspsnippets.com/Articles/Return-Identity-value-from-Stored-Procedure-in-SQL-Server.aspx
https://stackoverflow.com/questions/17112852/get-the-new-record-primary-key-id-from-mysql-insert-query
https://stackoverflow.com/questions/1920558/what-is-the-difference-between-scope-identity-identity-identity-and-ide
https://www.youtube.com/watch?v=tLD5tCP4jqM&list=PL_c9BZzLwBRKC2PJwLFxc2y6cyXYYQzj3&index=33
Computer keyword not working in the emulator.
jQuery(document).click()--
lock
------------------------------once we define own code inside document.click method in some other jQuery file.
then in current jQuery file openly written document.click() method will not call.
In that case, we have to override this document.click() by re-binding document.click()
in any currently running method.
https://github.com/Microsoft/TypeScript/issues/8518#issuecomment-229506507
Issue in handheld:(visual studio 2008)
----------------------------------------------------------------
Error: File is not a valid emulator saved-state file
Go to Tools->Device Emulator Manager->Select the emulator on which our code is running ->Then Right click and Clear Saved Data. Thats it.
Mail Sending Project Link
---------------------------------
https://www.codeproject.com/Articles/19546/MailMergeLib-A-Mail-Client-Library-for-Net
Centralized exception handling in WCF by implementing IErrorHandler interface
----------------------------------------------------------------------------------------------------
https://www.youtube.com/watch?v=7wF4QXcD9yo
http://csharp-video-tutorials.blogspot.in/2014/01/part-20-centralized-exception-handling_29.html
Javascript tutorial links
----------------------------------------------
http://tutorials.scrisoft.com/category/javascript/
JQuery Checker Tools
========================================================================
http://jshint.com/
JQuery Hacks
========================================================================
Javascript Encrypter
--------------------------
http://www.javascriptobfuscator.com/Javascript-Obfuscator.aspx
https://www.patrick-wied.at/blog/a-technique-for-hiding-your-javascript-code --encryption in image of a JS file.
Javascript Decrypter
--------------------------
http://jsbeautifier.org/
https://www.youtube.com/watch?v=6yVOomG0QVU decrypt in browser only.
https://baivong.github.io/de4js/
How to rotate a video.
https://www.dvdvideosoft.com/guides/free-video-flip-and-rotate.htm
How to design or create a video.
https://www.movavi.com/videoeditor/how-it-works.html?asrc=ve_webnag5stepstrial&app=videoeditor&app_ver=14-1-0&lang=en&partner=movavi&huid=a493794a1d38ddfd6fd1f80dc91154b2e7bda8e7#main
PS Tools Utility:
https://docs.microsoft.com/en-us/sysinternals/downloads/pstools
Sha256 security method not able to call from vs2008
-----------------------------------------------------------------
Make a wcf method to just encrypt the password using
Sha256 from WCF and return the encrypted string.
How to dynamic load dropdown with selected value in excel through c#,EPPLUS Library
------------------------------------------------------------------------------------------------------------
First make a private method to just load the header value and load the dropdown values next set the selected value in next row dropdown cells.
.CSPROJ
--------------
https://docs.microsoft.com/en-us/aspnet/web-forms/overview/deployment/web-deployment-in-the-enterprise/understanding-the-project-file
https://stackoverflow.com/questions/41809230/how-do-i-exclude-a-folder-from-a-project-but-not-from-publish
https://tedgustaf.com/blog/2011/customize-an-aspnet-project-to-control-which-files-are-included-when-publishing-or-deploying/
http://thomasardal.com/msbuild-tutorial/
https://stackoverflow.com/questions/12257110/can-you-force-visual-studio-to-always-run-as-an-administrator-in-windows-8?rq=1
Issue : Unable to open MS word document in window service in C#
----------------------------------------------------------------------------------
https://www.codeproject.com/Questions/1102430/Unable-to-open-MS-word-document-in-window-service
https://stackoverflow.com/questions/48198/how-can-you-find-out-which-process-is-listening-on-a-port-on-windows
https://docs.microsoft.com/en-us/sysinternals/downloads/tcpview
Microsoft enterprise library not working issue in windows app
----------------------------------------------------------------------------------
It is due to getting selected project in .net 4 client profile instead of .net 4 only.
For Sending a large file by mail
-----------------------------------------------------
https://wetransfer.com/
Note: file transfer expires after some time so need to download the attachment from recipient side soon.
Remote Desktop Softwares
----------------------------------------------------
anydesk
teamviewer
chrome-remote-desktop
https://underspy.com/blog/anydesk-vs-teamviewer/
https://chrome.google.com/webstore/detail/chrome-remote-desktop/gbchcmhmhahfdphkhkmpfmihenigjmpp/related?hl=en
Avast free antivirus
------------------------------------------------
https://www.avast.com/en-in/lp-ppc-hp?device=c&ppc=a2&gclid=Cj0KCQiAh_DTBRCTARIsABlT9MazEy1GeQMbZ9yjNHo4yi_ztaTmT0bENLbdppwKAITYX-17n47Oj7gaAtA_EALw_wcB&gclsrc=aw.ds&dclid=CKWd6oaTmNkCFZhHKwodm38OZQ
Dotnet Issues debugging in WCF Side
--------------------------------------------------------------
unable to automatically step into the server. Unable to determine a stopping location. Verify symbols are loaded. Error while processing breakpoint.
Solution is very simple set a breakpoint in wcf side.
Software that compares files and merging the changed part
------------------------------------------------------------------------------------------
https://www.scootersoftware.com/download.php
Error after publishing iis (http error 500.21 - internal server error managedpipelinehandler)
----------------------------------------------------------------------------------------------------------------
https://www.codeproject.com/Questions/412385/i-get-HTTP-Error-when-i-access-a-web-site-p
Best snipping tool software
----------------------------------------
https://app.prntscr.com/en/download.html
To see your all saved contact on google
----------------------------------------------------------------
https://contacts.google.com/
A device will sync all contact automatically once we login with gmail id in that device.
Screen recording softwares
---------------------------------------------------------------
https://www.screenpresso.com/download/
Why did a network-related or instance-specific error occur while establishing a connection to SQL Server?
--------------------------------------------------------------------------------------------------------------------------
https://stackoverflow.com/questions/1391503/why-did-a-network-related-or-instance-specific-error-occur-while-establishing-a
What can happen when from emulator request don't go to IIS?
The problem was with emulator IP Address...earlier i set 192.168.1.201 and my ip was 192.168.2.71-> The moment i change my emulator ip to 192.168.2.201 it started hitting IIS..So issue fixed..
Why IIS Sleeps and not responding after a certain period of time.
https://social.msdn.microsoft.com/Forums/en-US/8b3258e7-261c-49a0-888c-0b3e68b2af13/preventing-iis-from-falling-into-sleep?forum=wcf
Row not selecting in a datagrid:
availableTrucksGrid.Select(index);
availableTrucksGrid.CurrentRowIndex = index;
availableTrucksGrid.Refresh();//this portion was missing
Chrome debugging not working after installation of visual studio:
Just need to set one debug point in login page or any JavaScript.
Winforms not responding to keydown events:
https://stackoverflow.com/questions/3172731/forms-not-responding-to-keydown-events
Setup emulator on Windows 10:
https://www.swiftbyte.com/articles/windows-mobile/debugging-windows-mobile-6-5-application-on-windows-10
Visual studio 2017 slow debugging:
https://developercommunity.visualstudio.com/content/problem/26064/slow-debug-in-vs-2017.html
Bulzip Printer setting for PDF Download:
[PDF Printer]
; This is a sample global.ini file.
; It illustrates some common settings that can be found of this type of ini file.
; All lines prefixed with a semicolon are comment lines. Remove the semicolon on the lines below to activate the settings.
; More information on the individual settings can be found in the documentation.
;DisableOptionDialog=yes
;WipeMethod=3pass
;ShowSaveAS=always
;ShowSettings=never
[PDF Printer]
; This is a sample global.ini file.
; It illustrates some common settings that can be found of this type of ini file.
; All lines prefixed with a semicolon are comment lines. Remove the semicolon on the lines below to activate the settings.
; More information on the individual settings can be found in the documentation.
;DisableOptionDialog=yes
;WipeMethod=3pass
;ShowSaveAS=always
;ShowSettings=never
output=D:\PrintPreviewLogFiles\PreviewPDFFiles\<smarttitle>.pdf
confirmoverwrite=no
confirmnewfolder=no
appendifexists=no
email=no
rememberlastfilename=no
rememberlastfoldername=no
openfolder=no
showpdf=no
showsaveas=never
showsettings=never
suppresserrors=yes
device=pdfwrite
resx=150
resy=150
textalphabits=4
graphicsalphabits=4
author=
--------------------------------------------------------------------------------------------------------
Oracle Un-Installation:
=====================
https://oracle-base.com/articles/misc/manual-oracle-uninstall
https://superuser.com/questions/256762/how-do-i-completely-remove-oracle-11g
Remove environmental variable
Damaged Version of NetExtender on Windows 7
=====================================
https://www.sonicwall.com/en-us/support/knowledge-base/170502985895807
https://www.microsoft.com/en-us/download/confirmation.aspx?id=46148
Some time task bar will be crashed so may be no icons displayed in desktop and task bar will be hidden:
Steps to follow:
CTRL +ALT +DELETE -> Click on start task manager -> Click on Application -> Click on new task
-> in Open TextBox (Run Window) type explorer.exe and hit enter.
'The specified service already exists' during an installation:
https://www.jprog.com/wiki/How-do-I-resolve-the-error-The-specified-service-already-exists-during-an-installation.ashx
Memory Issue in IIS:
Memory gates checking failed because the free memory (321146880 bytes) is less than 5% of total memory. As a result, the service will not be available for incoming requests. To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.
Simply remove some unwanted processes.
Msbuild Issue in VS 2008:
https://community.embarcadero.com/article/technical-articles/16202-msbuildtoolspath-is-not-specified-for-the-toolsversion
How to enable SSL https in IIS:
https://www.youtube.com/watch?v=YpfATz2w-Uw
https://www.youtube.com/watch?v=gmxoC7HkylE
But if domain is already registered outside and portion of the IIS has to run with that domain then only frontend folders path has to be change from entered ip address to the domain path which should redirect to IIS link. In that case no need any setting in IIS.
IRCTC tatkal booking:
https://www.youtube.com/watch?v=cZjNDayKkb0&list=PLl_iLul_SiBRMgOYS47_W8VS7_UHpZGca
https://irctc-tatkal-magic-autofill-form.com/
How to configure IIS in window server 2012 R2:
https://docs.microsoft.com/en-us/iis/get-started/whats-new-in-iis-8/iis-80-using-aspnet-35-and-aspnet-45
Taking Remote Error:
Remote Desktop Authentication Error Has Occurred. The function requested is not supported
https://social.technet.microsoft.com/Forums/en-US/46e1cd52-52b3-4427-88a3-200f87319e23/remote-desktop-authentication-error-has-occurred-the-function-requested-is-not-supported?forum=w7itpronetworking
32 bit dll's not able to run in IIS 8
https://www.microsoft.com/en-in/download/details.aspx?id=5555
HTTP Error 404.3 - Not Found The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.
https://stackoverflow.com/questions/4388066/the-page-you-are-requesting-cannot-be-served-because-of-the-extension-configura
Automatically Installation popup closing while installing oracle 12c 32 bit client.
https://community.oracle.com/thread/3725625?start=0&tstart=0
Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. An attempt was made to load a program with an incorrect format oracle 12c
The Solution is change (NTS) to (NONE) to both 32 and 64 bit client sqlnet.ora file.
Adobe Reader newer version already installed error:
https://www.youtube.com/watch?v=Lk_8pibZNK8
Thunderbird mail client mail back and recovery:
https://support.mozilla.org/en-US/kb/moving-thunderbird-data-to-a-new-computer
Not able to publish VS2010 code using VS2017:
Some issue of the publish properties.
I closed the VS 2017, went to the properties folder and removed the PublishProfile folder.
I again opened the solution, and created new publish profile.
My project was published.
And also check
How to clear the cache in git so that git ignore works proper:
step-1: git rm -r --cached .
step-2: git add .
step-3: git commit -m "fixed untracked files"
note: All dotes are important
.gitIgnore file content:
Thumbs.db
*.obj
*.exe
*.pdb
*.user
*.aps
*.pch
*.vspscc
*_i.c
*_p.c
*.ncb
*.suo
*.sln.docstates
*.tlb
*.tlh
*.bak
*.cache
*.ilk
*.log
[Bb]in
[Dd]ebug*/
*.lib
*.sbr
obj/
[Rr]elease*/
_ReSharper*/
[Tt]est[Rr]esult*
*.vssscc
$tf*/
.vs/
*.xsd
*.scc
To add a folder which contains all dependency dlls for a project:
$ git add -f Dependencies
Employee Leave Management:https://kredily.com/
“Unable to launch the IIS Express Web server” error:
If using VS2015, close the solution, delete the following file, then re-open the solution.
<<path_to_solution_folder>>\.vs\config\applicationhost.config
https://stackoverflow.com/questions/18454751/unable-to-launch-the-iis-express-web-server-error
Connection string difference in my sql and oracle:
<add name="ApplicationConnection" connectionString="Datasource=192.168.2.220;Database=DB1;uid=user;pwd=pwd;Allow User Variables=True" providerName="MySql.Data.MySqlClient"/>
<add name="ApplicationConnection" connectionString="Server=DB1;User ID=user;Password=pwd;Min Pool Size=0;Max Pool Size=300;Connection Lifetime=15" providerName="System.Data.OracleClient" />
Mysql equivalent of decode function in oracle:
https://stackoverflow.com/questions/4706100/mysql-equivalent-of-decode-function-in-oracle
How to set directory browsing in visual studio IIS Express:
https://stackoverflow.com/questions/8543761/how-to-enable-directory-browsing-by-default-on-iis-express/42841369#42841369
<directoryBrowse enabled="true" /> add this in webconfig->webserver
MySQL restores database issue when we restore the big binary file as blob data to the MySQL database:
https://stackoverflow.com/questions/8062496/how-to-change-max-allowed-packet-size
ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected:This error came due to editing of heavy sql backup recovery. Editing distorts the file,
solution at a time one type of change then save then close. Repeat this. Use Vmeditor.
https://stackoverflow.com/questions/6175473/mysql-export-schema-without-data
mysqldump -h yourhostnameorIP -u root -p --no-data dbname > schema.sql
MS Sql Server Export Schema
Right Click on Database -> Tasks -> Generate Scripts
