Friday, December 9, 2022

Database from SINGLE USER mode to MULTI USER

 USE master;

GO

ALTER DATABASE MyDb2022

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

GO

ALTER DATABASE MyDb2022

SET READ_ONLY;

GO

Wednesday, November 30, 2022

How to insert a string value with an apostrophe (single quote) in a column

 INSERT INTO testtable VALUES (1,'Naresh C'houlla')

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ‘houlla’.
Msg 105, Level 15, State 1, Line 1
Unclosed quotation mark after the character string ‘)

 INSERT INTO testtable VALUES (1,'Naresh C''houlla')

Windows Malicious Software Removal Tool and record screen

Windows Malicious Software Removal Tool without software installation.. 

type mrt in the Windows search bar or Windows + R and type mrt.. 

and record - windows + alt +r or windows + g 

Tuesday, October 18, 2022

Cannot create/shadow copy 'dll' when that file already exists.

 updating your web.config with the following entry:


<configuration>

   <system.web>

      <hostingEnvironment shadowCopyBinAssemblies="false" />

   </system.web>

</configuration>

Friday, October 7, 2022

Anti forgery token is meant for user "" but the current user is "loginusermainid"

 Login time, if we click ,multiple time we will get this exception. that time use application error and rediredt to after login page

protected void Application_Error(object sender, EventArgs e)

      {

           try

            {

                string controller = Request.RequestContext.RouteData.Values["controller"].ToString();

                string action = Request.RequestContext.RouteData.Values["action"].ToString();

                Exception exception = Server.GetLastError();

                if (exception != null)

                {

                    if (exception is HttpAntiForgeryException)

                    {

                        

                        Response.Redirect("~/Account/Dashboard");

                    }

                }

            }

            catch (Exception ex)

            {

             throw;

            }

        }

Wednesday, July 27, 2022

The JSON request was too large to be deserialized.

 <appSettings>

  <add key="aspnet:MaxJsonDeserializerMembers" value="150000" />

</appSettings>


Wednesday, June 29, 2022

iis service manager - the process cannot access the file because it is being used by another process

if you are doing publish in local or local server.. if you change your port number application will work.. published code run in  your server or local machine

Monday, June 6, 2022

An error occurred while trying to restore packages.

 %appdata%\NuGet\NuGet.Config

 <?xml version="1.0" encoding="utf-8"?>
<configuration>
<packageRestore>
<add key="enabled" value="True" />
<add key="automatic" value="True" />
</packageRestore>
<packageSources>
<add key="nuget.org" value="https://api.nuget.org/v3/index.json" protocolVersion="3" />
<add key="nuget.org" value="https://www.nuget.org/api/v2/" />
<add key="Package source" value="E:\Download" />
</packageSources>
<activePackageSource>
<add key="All" value="(Aggregate source)" />
</activePackageSource>
</configuration>

  

Thursday, April 7, 2022

unable to check out the current file. the file may be read only or locked

 Goto tools > Options > Source Control > Current source control  plug- in select None and try to add service Or project run in admin mode and add.. it will work