How to open the link of hyperlink in new tab grid

 give Target="_blank"

 <asp:HyperLinkField Target="_blank" />

How to add string of array to data source of grid

 public class File1

{

    public string FileName { get; set; }

}

  List<File1> Files = new List<File1>();

if (Directory.GetFiles(Server.MapPath("/uploads/")).Count() > 0)

        {

            foreach (var item in Directory.GetFiles(Server.MapPath("/uploads/")))

            {

                

                Files.Add(new File1 { FileName = item });

                Response.Write(item);

                

                grdTest.DataSource = Files;

                grdTest.DataBind();

            }

        }

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

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

 SELECT   [Date]

      ,[SchemeNo] ,[Commission]

INTO        test3

FROM     PolicyDetails

How to change the color of Phone app - phone dialor

 >Go to settings

>Go to Sim cards

>Click on sim slot

>Change the color of sim slot

Difference Between Const, ReadOnly and Static ReadOnly in C#

 https://www.csharp.com/UploadFile/c210df/difference-between-const-readonly-and-static-readonly-in-C-Sharp/

Pivot function in SQL Server

 https://www.selectdistinct.co.uk/2023/05/22/pivot-function-in-sql/

Struct vs class

 https://www.geeksforgeeks.org/c-sharp-structures-set-1/

Types in C#

 https://learn.microsoft.com/en-us/dotnet/csharp/language-reference/language-specification/types#81-general