Thursday, May 4, 2023

what is SQL ?


sql is stand for structured query language.

• This database language is mainly designed for maintaining the data in relational database management systems.

• sql is standard language for accessing and manipulating database

Sunday, April 2, 2023

This site can't be reached error

Solution 1:

  1. open cmd as admin
  2. cd C:\Program Files (x86)\IIS Express
  3. IisExpressAdminCmd.exe setupsslUrl -url:https://localhost:portnumber/ -UseSelfSigned
Solution 2:


Tuesday, January 3, 2023

exception has been thrown by the target of an invocation in c#

 changes dll version or upgrade dll .. change old dll library to new dll library

...\packages\EntityFramework.6.2.0\lib\net45\EntityFramework.dll

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