Thursday, May 4, 2023

DDL commands

DDL COMMANDS:

• DTM (Data Defined Languages) used to change the structure of the table Like creating the table, altering the table & Deleting the table.

All the commands in the DDL are auto Committed that means it permanently save all the changes in the database.

1. CREATE :

This command is used to create a new database or table.

Syntax:

CREATE TABLE table_name( columnl datatype, column2 datatype, column3 datatype,

Example:

CREATE TABLE Employee

EmployeelD int; FirstName varchar(255), LastName varchar(255), AddressLine varchar(255), City varchar(255)

);
2. UPDATE:

The UPDATE statement is used to modify the existing records in a table.

Syntax:

UPDATE table_name

SET colomn1 = value1, colomn2 = value2,..... WHARE CustomerID = 101;

Example:

UPDATE Customers

SET ContactName = 'naresh', City = 'hyd' WHERE CustomerID = 101;

3. DELETE :

The DELETE statement is used to delete the existing records in a table.

Syntax:

DELETE FROM table_name[WHERE condition];

Example:

DELETE Customers WHERE CuntomerName = "naresh";
4. TRUNCATE:

A truncate SQL statement is used to remove all rows (complete data) from a table. It is similar to the DELETE statement with no WHERE clause.

Syntax:

TRUNCATE TABLE table_name;

Example:

TRUNCATE TABLE Employee;

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>