Friday, March 28, 2025

How to find the dicrectory path of website

 Response.Write(Request.PhysicalApplicationPath );   //output C:\Users\Yash User\Documents\Visual Studio 2012\WebSites\YashWebsiteWebForm\

        Response.Write(Request.PhysicalPath + Environment.NewLine); // output C:\Users\Yash User\Documents\Visual Studio 2012\WebSites\YashWebsiteWebForm\Default3.aspx


        Response.Write(Request.RawUrl );  //output  /Default3.aspx

        Response.Write(Request.Url); // output http://localhost:49730/Default3.aspx


Server.MapPath ("");   //output C:\Users\Yash User\Documents\Visual Studio 2012\WebSites\YashWebsiteWebForm


Wednesday, March 26, 2025

How to write query with query builder in SQL server

 > Open Sql server management studio

> Right click on editor and click on "Design query in editor"

> And right click in that to change insert update or delete query.

How to create a new table with select query in SQL - INSERT RECORD FROM ONE TABLE TO ANOTHER - COPY TABLE

 SELECT   [Date]

      ,[SchemeNo] ,[Commission]

INTO        test3

FROM     PolicyDetails