Online Home of Yash Kapoor: 2025

Private Declare Sub mouse_event Lib "user32" (ByVal dwFlags As Long, ByVal dx As Long, ByVal dy As Long, ByVal cButtons As Long, ByVal dwExtraInfo As Long)

' Define the mouse events

Public Const MOUSEEVENTF_LEFTDOWN = &H2

Public Const MOUSEEVENTF_LEFTUP = &H4

Public Const MOUSEEVENTF_ABSOLUTE = &H8000

Public Const MOUSEEVENTF_MOVE = &H1

Sub SimulateLeftClick(ByVal x As Long, ByVal y As Long)

' Move the cursor to the specified coordinates (screen coordinates)

SetCursorPos x, y

' Perform the left click (Down and then Up)

mouse_event MOUSEEVENTF_LEFTDOWN, 0, 0, 0, 0

mouse_event MOUSEEVENTF_LEFTUP, 0, 0, 0, 0

End Sub

Sub TestClick()

' Clicks at screen coordinates X=50, Y=50

Call SimulateLeftClick(40, 200)

End Sub

Friday, December 26, 2025

How to create notepad in Chrome

Enter below text in Chrome URL

data:text/html, <title>Notepad</title><body contenteditable style="font-size:18px;line-height:1.6;font-family:sans-serif;">

How to disable navigation pane in window 11 for windows - Disable left side in panel in window Explorer of Windows 11

>Open Windows Explorer

> Go to View

> Uncheck navigation Pane

Wednesday, December 24, 2025

How to Play two videos with videos.js

<html>

<head>

function init() {

var url = "https://dash.akamaized.net/akamai/test/caption_test/ElephantsDream/elephants_dream_480p_heaac5_1_https.mpd",

video = video = document.querySelector('video'),

player;

player = dashjs.MediaPlayer({}).create();

player.initialize(video, url, true);

}

</script>

</head>

<body>

<video

id="my-player"

class="video-js"

controls

preload="auto"

poster="//vjs.zencdn.net/v/oceans.png"

data-setup='{}'>

To view this video please enable JavaScript, and consider upgrading to a

web browser that

supports HTML5 video

</a>

</p>

</video>

<video

id="my-video"

class="video-js vjs-default-skin"

controls

preload="auto"

width="560"

height="300"

data-setup='{}'>

<source

src="https://vjs.zencdn.net/v/oceans.mp4"

type="video/mp4"

size="1080"

<track

kind="subtitles"

src="https://gist.githubusercontent.com/samdutton/ca37f3adaf4e23679957b8083e061177/raw/e19399fbccbc069a2af4266e5120ae6bad62699a/sample.vtt"

srclang="en"

label="English"

</video>

</body>

<html>

Tuesday, December 23, 2025

How to Add random values in Excel

=RANDBETWEEN(1, 100)

Monday, December 22, 2025

Refresh With powershell

Start-Sleep -Seconds 3

[System.Windows.Forms.SendKeys]::SendWait("^+{F10}")

[System.Windows.Forms.SendKeys]::SendWait("e")

Excel Shortcuts - Merging of Two cells

CTRL + E----- To merge two cells

ALT + H +O +I ----------- Column width Auto size

ALT +H + W or ALT + H + O +A ---------- Auto size column height

Right Click in powershell - Context menu in Powershell

#Context menu with Powershell

[System.Windows.Forms.SendKeys]::SendWait("^+{F10}")

Shift + F10

how to create Folder in Powershell - How to open explorer and create folder in powershell

Add-Type -AssemblyName System.Windows.Forms

Add-Type -AssemblyName Microsoft.VisualBasic

Start-Process -FilePath "explorer.exe"

# Wait for WinWord to open and become active

Start-Sleep -Seconds 1

(New-Object -ComObject "wscript.shell").SendKeys("^{l}")

Start-Sleep -Seconds 1

(New-Object -ComObject "wscript.shell").SendKeys("D:\")

Start-Sleep -Seconds 1

(New-Object -ComObject "wscript.shell").SendKeys("{Enter}")

#Context menu with Powershell

[System.Windows.Forms.SendKeys]::SendWait("^+{F10}")

Start-Sleep -Seconds 1

[System.Windows.Forms.SendKeys]::SendWait("^+n")

Start-Sleep -Seconds 1

(New-Object -ComObject "wscript.shell").SendKeys("{Enter}")

How to set gif image in window 11 - How to set GIF wallpaper in Window 11

Use Lively Wallpaper software

ref:- https://apps.microsoft.com/detail/9ntm2qc6qws7?hl=en-US&gl=US

Friday, December 19, 2025

how to send a to z in Powershell - How to send alphabets in Powershell

#Note This first line is mandatory

[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")

# Start WinWord (if not already running)

Start-Process -FilePath "excel.exe"

# Wait for WinWord to open and become active

Start-Sleep -Seconds 3

# Activate the WinWord window (adjust the title if necessary)

$wshell = New-Object -ComObject wscript.shell

#$wshell.AppActivate("Document1 - Word") # Or the actual document title

Start-Sleep -Seconds 1

for ($i = 1; $i -le 5; $i++) {

$j = [char](65 + $i)

[System.Windows.Forms.SendKeys]::SendWait("$j")

}

for ($test = 0; $test -lt 26; $test++)

{

[char](65 + $test)

}

How to pause printer or stop printer for printing

>click on Start button

> Type Printers and scanners

>Select printer(Printer that you work like HP or Other) and Manage

> Click on Open Print Queue

> Click on Printer And Click on pause Printing(Check and Uncheck for Printing)

Monday, December 15, 2025

How to get x axis and y axis position of Mouse cursor in Powershell

# Load the necessary assemblies for accessing mouse position information

Add-Type -AssemblyName System.Drawing

Add-Type -AssemblyName System.Windows.Forms

Write-Host "Move your mouse. Press Ctrl+C to stop."

while ($true) {

# Get the current mouse position

$cursorPosition = [System.Windows.Forms.Cursor]::Position

$x = $cursorPosition.X

$y = $cursorPosition.Y

# Print the coordinates. Using Write-Host with -NoNewline and carriage return `r`

# overwrites the previous line in the console for a cleaner continuous update.

Write-Host "`rX: $x | Y: $y" -NoNewline

# Wait for a short period to prevent the loop from consuming too much CPU

Start-Sleep -Milliseconds 100

}

or for single position

Add-Type -AssemblyName System.Windows.Forms

$mousePosition = [System.Windows.Forms.Cursor]::Position

Write-Host "Current mouse position is X: $($mousePosition.X), Y: $($mousePosition.Y)"

How to move mouse position with powershell - Inverse for loop in Powershell

for ($i = 100; $i -ge 10; $i--) {

Start-Sleep -Milliseconds 1

Write-Host "Iteration: $i"

[System.Windows.Forms.Cursor]::Position = "$i, $i "

}

or with 10 decrement

for ($i = 1000; $i -ge 10; $i -= 10) {

Start-Sleep -Milliseconds 1

Write-Host "Iteration: $i"

[System.Windows.Forms.Cursor]::Position = "$i, $i "

}

How to change the Cursor position with Powershell - How to change the mouse position with Powershell

[System.Windows.Forms.Cursor]::Position = "700,700"

How to open and send keys in Calculator and Add operation in Powershell

Add-Type –AssemblyName UIAutomationClient

Add-Type –AssemblyName UIAutomationTypes

$calc = [Diagnostics.Process]::Start('calc')

#wait for the UI to appear

$null = $calc.WaitForInputIdle(5000)

sleep –s 2

$calcWindowId = ((Get-Process).where{$_.MainWindowTitle -eq 'Calculator'})[0].Id

$root = [Windows.Automation.AutomationElement]::RootElement

$condition = New-Object Windows.Automation.PropertyCondition([Windows.Automation.AutomationElement]::ProcessIdProperty, $calcWindowId)

$calcUI = $root.FindFirst([Windows.Automation.TreeScope]::Children, $condition)

function FindAndClickButton($name){

$condition1 = New-Object Windows.Automation.PropertyCondition([Windows.Automation.AutomationElement]::ClassNameProperty, "Button")

$condition2 = New-Object Windows.Automation.PropertyCondition([Windows.Automation.AutomationElement]::NameProperty, $name)

$condition = New-Object Windows.Automation.AndCondition($condition1, $condition2)

$button = $calcUI.FindFirst([Windows.Automation.TreeScope]::Descendants, $condition)

$button.GetCurrentPattern([Windows.Automation.InvokePattern]::Pattern).Invoke()

}

#get and click the buttons for the calculation

FindAndClickButton Five

FindAndClickButton Plus

FindAndClickButton Nine

FindAndClickButton Equals

#get the result

$condition = New-Object Windows.Automation.PropertyCondition([Windows.Automation.AutomationElement]::AutomationIdProperty, "CalculatorResults")

$result = $calcUI.FindFirst([Windows.Automation.TreeScope]::Descendants, $condition)

$result.current.name

Wednesday, December 10, 2025

How to copy and paste in notepad excel with Arrow VBA

Sub CommandButton1_Click()

Shell "Notepad.exe", vbNormalFocus

Dim I As Integer

SendKeys "one"

SendKeys "{Enter}"

Application.Wait (Now + TimeValue("00:00:01"))

SendKeys "^a"

Application.Wait (Now + TimeValue("00:00:01"))

SendKeys "^c"

Application.Wait (Now + TimeValue("00:00:01"))

SendKeys "{right}"

Application.Wait (Now + TimeValue("00:00:01"))

SendKeys "two"

Application.Wait (Now + TimeValue("00:00:01"))

End Sub

How to send up and down keys in Excel or VBA

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/sendkeys-statement

How to open notepad with for loop and enter a to z characters in excel automatically - alphabets in excel

Sub SendAlphabet_AtoZ()

Shell "Notepad.exe", vbNormalFocus

Dim i As Integer

Dim char_code As Integer

Dim current_char As String

Dim row_num As Integer

Dim z As Integer

For z = 1 To 50

row_num = 1

' Loop through ASCII codes for lowercase 'a' (97) to 'z' (122)

For char_code = 50 To 122

' Convert the ASCII code to a character

current_char = Chr(char_code)

Application.Wait (Now + TimeValue("00:00:00"))

' Place the character in the active worksheet in column A

SendKeys current_char

' Move to the next row

Next char_code

Next z

End Sub

How to send Ctrl + F4 key in Powershell - How to send CTRL ALT Shift keys in Powershell - How to open Application in Powershell - How to open File Explorer in Powershell

Start-Sleep -Seconds 5

$wshell = New-Object -ComObject WScript.Shell

$wshell.SendKeys("^{F4}")

#Note This first line is mandatory

[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")

# Start WinWord (if not already running)

Start-Process -FilePath "explorer.exe"

# Wait for WinWord to open and become active

Start-Sleep -Seconds 3

(New-Object -ComObject "wscript.shell").SendKeys("^{ESC}")

# Activate the WinWord window (adjust the title if necessary)

[System.Windows.Forms.SendKeys]::SendWait("{ENTER}")

ref:- https://learn.microsoft.com/en-us/dotnet/api/system.windows.forms.sendkeys.send?view=windowsdesktop-10.0

https://stackoverflow.com/questions/19824799/how-can-i-send-ctrl-or-alt-any-other-key

How to count status in selected sheet open or close

=Countif('SheetName'!I3:I998, "Open")

I3:I998 is range

Thursday, November 27, 2025

How to send one thousand time window keys with powershell

for ($i = 0; $i -lt 1000; $i++) {

(New-Object -ComObject "wscript.shell").SendKeys("^{ESC}")

# Optional: Add a small delay (e.g., 10 milliseconds) to prevent overwhelming the system

Start-Sleep -Milliseconds 10

}

Note:- Start-Sleep -Milliseconds 10 // Fastest

Start-Sleep -Milliseconds 100 //More Fast

Start-Sleep -Milliseconds 1000 //Slow

How to click window button and open file explorer with powershell

(New-Object -ComObject "wscript.shell").SendKeys("^{ESC}")

Start-Sleep -Seconds 3

[System.Windows.Forms.SendKeys]::SendWait("file explorere")

[System.Windows.Forms.SendKeys]::SendWait("{ENTER}")

One thousand times left click in PowerShell

Add-Type -AssemblyName System.Windows.Forms

Add-Type -AssemblyName System.Drawing

function Send-MouseClick {

# Define the necessary Win32 API function for mouse events

$signature = @'

[DllImport("user32.dll", CharSet = CharSet.Auto, CallingConvention = CallingConvention.StdCall)]

public static extern void mouse_event(uint dwFlags, uint dx, uint dy, uint cButtons, uint dwExtraInfo);

$mouseEvents = Add-Type -MemberDefinition $signature -Name "Win32MouseEvents" -Namespace "Windows" -PassThru

# Mouse event flags

$MOUSEEVENTF_LEFTDOWN = 0x0002

$MOUSEEVENTF_LEFTUP = 0x0004

# Get current cursor position

$cursorPos = [System.Windows.Forms.Cursor]::Position

$x = $cursorPos.X

$y = $cursorPos.Y

# Perform the left mouse button down and up events

$mouseEvents::mouse_event($MOUSEEVENTF_LEFTDOWN, $x, $y, 0, 0)

$mouseEvents::mouse_event($MOUSEEVENTF_LEFTUP, $x, $y, 0, 0)

}

# Loop 1000 times to perform 1000 clicks

for ($i = 0; $i -lt 1000; $i++) {

Send-MouseClick

# Optional: Add a small delay (e.g., 10 milliseconds) to prevent overwhelming the system

Start-Sleep -Milliseconds 10

}

Write-Host "1000 clicks performed."

Tuesday, November 25, 2025

How to save file with VBA - How to save file with Macro - in Excel or MS Word

Sub Macro2()

Shell "winword", vbNormalFocus

SendKeys "George W. Bush"

SendKeys "%{F4}", True

SendKeys "{ENTER}", True

'SendKeys "George W. Bush.txt", True' 'Comment'

'SendKeys "%S"' 'Comment'

End Sub

How to use chrome as file explorer - How to open folder in Chrome

Type this below code in URL

file:///C:/

How to add styles to live website in chrome - How to change styles to live website in chrome - How to change background color in live website in chrome

> Open developer tools in chrome

> Go to sources tab and select overrides tab

> Click on "select folder for overrides" and Select the folder where you want to change the overrides

> Right click on element of website and change color of background or style

> Click on sources tab and Page tab and save the css file in folder where you select the folder above.

If you want to delete, goto sources tab and goto overrides tab and delete overrides. And the website will be able to run as it was.

Note:-

After the above steps, For Enable styles that you edit, right click and inspect > Go to Sources> Overrides> Check Enable Local Overrides

For disable styles that you edit, right click and inspect > Go to Sources> Overrides> UnCheck Enable Local Overrides or refresh page will disable style overrides

or you can use stylebot extension in chrome.

Monday, November 24, 2025

How to open Application in Excel VBA - How to open Notepad in Excel VBA - How to open Notepad and send keys in Excel VBA

Sub CommandButton1_Click()

Shell "Notepad.exe", vbNormalFocus

Dim I As Integer

SendKeys "one"

SendKeys "{Enter}"

SendKeys "two"

End Sub

How to print like console.writeline in Powershell - How to print in Powershell

Write-Host "Iteration:"

Friday, November 21, 2025

For loop in powershell

for ($i = 1; $i -le 5; $i++) {

Write-Host "Iteration: $i"

}

with 10 increments

for ($i = 1; $i -le 50; $i += 10) {

Write-Host "Iteration: $i"

}

How to declare variable in powershell

$name = "John Doe"

$age = 30

$isActive = $True

Thursday, November 20, 2025

How to automatically start word and type in it with Powershell

#Note This first line is mandatory

[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")

# Start WinWord (if not already running)

Start-Process -FilePath "winword.exe"

# Wait for WinWord to open and become active

Start-Sleep -Seconds 3

# Activate the WinWord window (adjust the title if necessary)

$wshell = New-Object -ComObject wscript.shell

#$wshell.AppActivate("Document1 - Word") # Or the actual document title

Start-Sleep -Seconds 1

# Send some text and an Enter key

[System.Windows.Forms.SendKeys]::SendWait("This is a test message.")

[System.Windows.Forms.SendKeys]::SendWait("{ENTER}")

[System.Windows.Forms.SendKeys]::SendWait("Another line of text.")

Tuesday, November 18, 2025

How to use mouse numlock keys in window 11 - How to use mouse keys with keyboard in window 11

https://support.microsoft.com/en-us/windows/use-mouse-keys-to-move-the-mouse-pointer-9e0c72c8-b882-7918-8e7b-391fd62adf33

Monday, November 17, 2025

How to stop applicaion in seconds in excel - step by step macro wait for one second - Excel Sleep

Application.Wait (Now + TimeValue("00:00:01"))

Application.Wait Now + TimeSerial(0, 0, 5)

Note: This is only work in Excel VBA, Not in Word VBA.

How to copy a cell in Excel with VBA and how to show MessageBox in excel - alert in Excel

Selection.Copy

MsgBox "Copied ---- " & Selection

Note:- Copy Only a single cell , if more than one cell copied, it will give error

Thursday, November 13, 2025

Action Replay extension for Chrome - How to auto replay work flows or How to auto play actions of website

> With the help of Action Replay Extension in chrome

> Google chrome recorder can also be used for replay of steps.

Tuesday, November 11, 2025

How to type auto in windows 11 with powershell - sending keys in power shell

[System.Windows.Forms.Cursor]::Position = New-Object System.Drawing.Point(100, 200)

$wshell = New-Object -ComObject wscript.shell

$wshell.AppActivate("Title of the application window") # Activate the target window

Start-Sleep -Seconds 5 # Give time for the window to activate

$wshell.SendKeys("Hello World{ENTER}")

After 5 seconds, it will paste in the window where cursor is clciked

Monday, November 10, 2025

copy and paste alternatives

ctrl + insert for copy

shift + insert key for paste

Thursday, November 6, 2025

How to create shortcut of URL in chrome

> First Open chrome

> Click on 3 dots and click on cast, save and share

>Click on create shortcut and a shortcut will be created.

Wednesday, October 29, 2025

Excel Image

In excel, when you you copy the cells, it will save as image in clipboard

Tuesday, October 28, 2025

How to block or unblock css in website in chrome - How to change agent of chrome

> Go to chrome developer tools

> Go to Network Tab

> Click on CSS, JS, ALL

> Press CTRL + F5 Key and you will see files. You can block that files.

> And you can change slow 4g or fast 4g or you can change agent in Chrome.

How to record website in chrome

>Open developer tools

> Click on Recorder

> Click on Create recording

> Click on Start recording.

> Click on website and when you click on buttons and anywhere it will save.

>You can import, export and delete the recordings.

>It will save as JSON file.

>Click on play recording to play.

Friday, October 3, 2025

if statement in MySql - if condition in MYSql - if in MySql

select IF(0 > 0, 'True', 'False') as message;

if exist drop and create database in MySql

create DATABASE IF not EXISTS test2;

drop DATABASE IF not EXISTS test2;

How to create new tab in My Sql

Click on Create a new Sql Tab. Below is the screenshot:-

What is called t1 and t2 in join

Select * from table1 t1 inner join table t2 on t1.id = t2.id

Here t1 and t2 are called alias.

Wednesday, October 1, 2025

How to create stored procedure in MySql and how to call stored procedure

DELIMITER $$

CREATE PROCEDURE new_procedure_procedure_name()

BEGIN

SELECT *

FROM test.new_table t1

LEFT JOIN test1.table1 t2 ON t1.id = t2.id;

END $$

DELIMITER ;

===============================

CALL new_procedure_procedure_name();

How to create new database in MYSql

> First open My SQL workbench

>Than click on Database menu and click on Connect to database

> Than in navigator , Select Schemes tabs

> Right click in navigator and click on Create schema

> and Type name and click on apply and click on apply and click on finish

How to connect MySql and how to install MySql

> First download MySql Workbench

> Than click on Database menu and click on Connect to database.

> Than click on OK button

> Than click on Schemas tab.

> Than write query

For Creating database

Create Schema test or Create Database test;

Tuesday, September 30, 2025

How to add chart in msword - How to add chart in ms word

> Open MSWord

> Go to Insert Menu

> Click on Chart

> Right Click on Char and Click on Edit data to edit the data

How to add watermark in msword

> Go to Design Menu

> Click on Watermark and add

Monday, September 29, 2025

How to add scale or ruler in MS Word

>First Click on Draw Menu

>Than Click on Ruler and with Mouse scroll, you can rotate Scale.

Note:-

Scale is also called Ruler.

Friday, September 19, 2025

how to print selected cell in excel

> Go to File

> Go to Print

> Go to Print What and Select Selection from Radio box

Monday, September 15, 2025

How to add automatic date in table column - How to insert automatic date in table column

Use

SELECT GETDATE() //will give current date

SELECT CAST(GETDATE() AS DATE) //will give only date

Thursday, September 11, 2025

How to call a function in VBA

Public Sub test()

MsgBox ("dfdfd")

test1

End Sub

Public Function test1()

MsgBox ("dfdfd")

End Function

ref:- https://learn.microsoft.com/en-us/office/vba/language/concepts/getting-started/calling-sub-and-function-procedures

Tuesday, September 9, 2025

How to add variable in Visual basic - vba

Dim Counter As Integer

How to add text to MS word Document - in VB

Sub mecro1()

Selection.TypeText "www.automateexcel.com"

MsgBox "You need to select some text."

End Sub

ref:- https://www.automateexcel.com/vba/word/macro-examples

Friday, September 5, 2025

How to do eye protection in window 11 - How to do eye protection in window 10

> Search for night light (Turn it on)option in search under display settings

> Also you can search for color filter settings in search option

> Also search for "adjust clear text" setting in search option under window button click

>Also you can search for brightness and change the brightness level

> Also you can increase Zoom in Chrome browser (Min 110% is good).

Also you can use apps like eye saver, CareUEyes

Also you can use Magnifier.

Also you can use scale from 100% to 110% from display settings.(Min 110% is good )

Also you can use resolution change. and color in Intel graphics command centre.

Also you can go to text size in scale in system settings and change it to 100% to 110%.(Min 110% is good )

Also you can use visual vibration images, examples :- https://img.freepik.com/free-vector/realistic-optical-illusion-background_52683-54383.jpg?semt=ais_hybrid&w=740&q=80

https://i.pinimg.com/736x/82/b2/5f/82b25fed9db53b364d55bc80f9d76efc.jpg

ref:- https://allthings.how/how-to-change-brightness-on-windows-11/

how to increase color in android or how to change color in android - how to decrease color

>You can use color changer app but it needs root permission

2) Display collaboration, blue light filter or sfilter , you can use these apps for android for decreasing color.

>Also simples is the rgb settings app for color changer.

Sunday, August 31, 2025

export to excel in grid - simplest way

Response.Clear();

Response.Buffer = true;

Response.ClearContent();

Response.ClearHeaders();

Response.Charset = "";

string FileName = "Vithal" + DateTime.Now + ".xls";

StringWriter strwritter = new StringWriter();

HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/vnd.ms-excel";

Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);

GridView1.GridLines = GridLines.Both;

GridView1.HeaderStyle.Font.Bold = true;

GridView1.RenderControl(htmltextwrtter);

Response.Write(strwritter.ToString());

Response.End();

RDLC Report manual export to pdf, image etc - report viewer export to pdf manually

https://www.c-sharpcorner.com/blogs/rdlc-report-export-on-server

https://www.aspsnippets.com/Articles/2568/Export-RDLC-Report-to-PDF-without-using-ReportViewer-in-ASPNet-with-C-and-VBNet/

Wednesday, August 20, 2025

How to add dummy data to datatable with multiple columns

DataTable dt = new DataTable("DummyData");

dt.Columns.Add("Id", typeof(int));

dt.Columns.Add("Name", typeof(string));

dt.Columns.Add("City", typeof(string));

DataTable dt1 = new DataTable("DummyData");

dt1.Columns.AddRange(new DataColumn[] {

new DataColumn("Id", typeof(int)),

new DataColumn("Name", typeof(string)),

new DataColumn("City", typeof(string))

});

dt.Rows.Add(1, "John Doe", "New York");

dt.Rows.Add(2, "Jane Smith", "London");

dt.Rows.Add(3, "Peter Jones", "Paris");

//or

// DataRow newRow = dt.NewRow();

newRow["Id"] = 4;

// newRow["Name"] = "Alice Brown";

//newRow["City"] = "Tokyo";

//dt.Rows.Add(newRow);

GridView1.DataSource = dt;

GridView1.DataBind();

How to add dummy data to datatable or gridview with array of string

string[] myString1 = { "sum", "minus"};

DataTable dt = new DataTable();

dt.Columns.Add("Name", typeof(string));

foreach (string item in myString1)

{

System.Data.DataRow row = dt.NewRow();

row["Name"] = item; // Assign the string to the column

dt.Rows.Add(row); // Add the row to the DataTable

}

GridView1.DataSource = dt;

GridView1.DataBind();

How to use same mouse for computer and mobile

>To use this, you have to first connect these devices by bluetooth

> Second you have to install GlideX, Phone mirror , Remote mouse, PC remote to your both devices

How to use two displays or two monitors with one mouse

>Right click on desktop

>Go to display settings

> and there is option of "Duplicate these videos", "Extend these videos" and click on Extend these videos , it will work for both monitors.

and use "microsoft without borders" for two different computers and having same mouse.

Friday, August 15, 2025

How to open binary file from database on browser- only display

byte[] bytes = file.FileData;

Response.Clear();

Response.ContentType = file.ContentType;

Response.BinaryWrite(bytes);

https://www.aspsnippets.com/questions/206135/Open-Show-Base64-PDF-data-in-new-window-Tab-using-C-and-VBNet-in-ASPNet/

How to open new window with width and height - using window.open

<a href="#" onclick="MyWindow=window.open('https://www.aspsnippets.com/Articles/660/Display-image-from-database-in-Image-control-without-using-Generic-Handler-in-ASPNet/','MyWindow','width=600,height=300'); ">click to open new window</a>

How to view the image in browser from database - binary image from database - asp.net

string alert1 = "var image = new Image();";

alert1+= "image.src='data:image/jpg;base64,"+ Convert.ToBase64String(bytes)+"';";

alert1 += "var w = window.open('');";

alert1+= "w.document.write(image.outerHTML);";

ScriptManager.RegisterStartupScript(this, this.GetType(), "OpenNewTabScript", alert1, true);

ref:-https://stackoverflow.com/questions/27798126/how-to-open-the-newly-created-image-in-a-new-tab

Thursday, August 14, 2025

System.InvalidOperationException: ExecuteScalar: Connection property has not been initialized.

This error comes when you write below code:-

using (SqlCommand cmd=new SqlCommand("SELECT TOP 1 [FileID] FROM [UploadFiles] order by Fileid desc"))

and not passed con as second parameter in SqlCommand. Use below code

using (SqlCommand cmd=new SqlCommand("SELECT TOP 1 [FileID] FROM [UploadFiles] order by Fileid desc", con))

also you have to add below line

cmd.CommandType = System.Data.CommandType.Text;

How to display binary images from database - How to view images from database - view binary images - asp.net c# - How to download file from database

protected void FetchImage(object sender, EventArgs e)

{

string id = ddlImages.SelectedItem.Value;

Image1.Visible = id != "0";

if (id != "0")

{

byte[] bytes = (byte[])GetData("SELECT Data FROM tblFiles WHERE Id =" + id).Rows[0]["Data"];

string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);

Image1.ImageUrl = "data:image/png;base64," + base64String;

}

ref:- https://www.aspsnippets.com/Articles/660/Display-image-from-database-in-Image-control-without-using-Generic-Handler-in-ASPNet/

How to run background music in website - HTML

https://www.tutorialspoint.com/how-to-add-background-music-to-your-web-page

Tuesday, August 12, 2025

How to download file using binarywrite function and download file from url link - using webclient function

protected void btnClickMe_Click(object sender, EventArgs e)

{

WebClient client = new WebClient();

byte[] bytes = client.DownloadData("https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgahqj6mU5OTtB-PLGl36tvYYv02OuXuR__pTakG-Y8dBc36TZaSboLga6RwM8DJUQKAwJ_sSjkp-4nhW1udweEejazbrZ50z2cb1ynJgIaZNBlrSIy827bc_5iY6UesB4/s220/WIN_20220808_12_53_18_Pro.jpg");

Response.Clear(); //This must be add ,without this the file that you save will not be open

Response.AddHeader("content-disposition", "attachment; filename=1.jpg");

//Response.ContentType = System.Net.Mime.MediaTypeNames.Image.Jpeg;

//"application/octet-stream";

Response.BinaryWrite(bytes);

Response.Flush();

Response.End();

}

Note:- Response.Clear(); //This must be add ,without this the file that you save will not be open

Monday, August 11, 2025

How to check ram in mobile android phone

> Go to developer option

> Click on memory and you will see the total memory usage.

Hartron question papers

https://www.scribd.com/

https://hartrondeo.in/hartron-deo-mix-questions/

https://wifiteachshala.blogspot.com/

Friday, August 8, 2025

How to change text font background of Menu Under Header of Blogger - Tabs of blogger - pages gadget of blogger

> Click on theme

>Click on Customize

>Click on advance

>Select tabs from dropdown list

> And you can change font size, font , background

>and click on save

Also you can change font size and font of other gadgets

Thursday, August 7, 2025

How to convert div to pdf using itextsharp asp.net - C# - Simplest and less code

First you have to download itextsharp.dll and itextsharp.pdfa.dll files and you have to give the font size as below because in some case it will give error that font size is small.

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>

<asp:Label runat="server" Text="Test" Font-Bold="true" Font-Size="13px" />

<br />

<asp:Label runat="server" Text="E-Admit Card" Font-Bold="true" Font-Size="13px" />

<br />

<tr>

<td>

<asp:Label runat="server" Text="Date Of Test:" Font-Size="13px" />

</td>

<td>

<asp:Label runat="server" Text="20/11/2024" Font-Size="13px" />

</td>

</tr>

</table>

</div>

<asp:Button ID="Button1" runat="server" Text="Print" OnClick="Button1_Click" />

</form>

===========================

protected void Button1_Click(object sender, EventArgs e)

{

Response.ContentType = "application/pdf";

Response.AddHeader("content-disposition", "attachment;filename=Panel.pdf");

Response.Cache.SetCacheability(HttpCacheability.NoCache);

StringWriter stringWriter = new StringWriter();

HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);

mainDiv.RenderControl(htmlTextWriter);

StringReader stringReader = new StringReader(stringWriter.ToString());

Document Doc = new Document(PageSize.A4, 10f, 10f, 100f, 0f);

HTMLWorker htmlparser = new HTMLWorker(Doc);

PdfWriter.GetInstance(Doc, Response.OutputStream);

Doc.Open();

htmlparser.Parse(stringReader);

Doc.Close();

Response.Write(Doc);

Response.End();

}

Tuesday, July 29, 2025

Nupkg extension file from nuget package

Convert nupkg file to zip file and you will get dll files in it.

On the right hand side of nuget website you will get "download package" option.

Monday, July 28, 2025

How to print a print statement of sql in asp.net c# - how to call a another event in asp.net event

using System;

using System.Data.SqlClient;

public class SqlPrintExample

{

public static void Main(string[] args)

{

string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=True";

string sqlQuery = "PRINT 'This message comes from SQL.'; SELECT GETDATE() AS CurrentDateTime;";

using (SqlConnection connection = new SqlConnection(connectionString))

{

// Attach an event handler to capture InfoMessage events (including PRINT statements)

connection.InfoMessage += Connection_InfoMessage;

or// conn.InfoMessage += new SqlInfoMessageEventHandler( Connection_InfoMessage);

try

{

connection.Open();

using (SqlCommand command = new SqlCommand(sqlQuery, connection))

{

using (SqlDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

Console.WriteLine($"Current Date Time from SQL: {reader["CurrentDateTime"]}");

}

catch (Exception ex)

{

Console.WriteLine($"Error: {ex.Message}");

}

private static void Connection_InfoMessage(object sender, SqlInfoMessageEventArgs e)

{

// Display the message from the SQL PRINT statement

Console.WriteLine($"SQL InfoMessage: {e.Message}");

}

do while loop in sql server - Cursor in Sql Server

For data looping in sql Server, we use While loop or cursor

DECLARE @cnt INT = 0;

WHILE @cnt < 10

BEGIN

PRINT 'Inside simulated FOR LOOP on TechOnTheNet.com';

SET @cnt = @cnt + 1;

END;

PRINT 'Done simulated FOR LOOP on TechOnTheNet.com';

For cursor:-

https://www.c-sharpcorner.com/blogs/how-to-use-cursors-and-while-loop-in-sql-server

Thursday, July 17, 2025

How to download the file secretly using webclient class -asp.net c#

using (WebClient client = new WebClient())

{

string url = "https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOJA1ZDa4CQ6OwLx-iL10cLEXpzoJZmZUVLHjJqHBr3-Q9TBEBpjD_ZZgtNGMj59CXGWtZ1yu-CfUoyuU8I7nGjgpwk0wCal_oGSPZNREQssIHeC5PFC10v8YdEIe5ie2wLyfGsrHSBR213ATgNXPyotNs66AoYF2CWPfAx9gu2cgYKw/s1600/Screenshot%202025-05-14%20184428.png";

string savePath = "D:/image1212.jpg";

client.DownloadFile(url, savePath);

}

How to call a http handler in web form - asp.net c#

</script>

public override ProcessRequestAsync(HttpContext context)

{

string targetUrl = context.Request.QueryString["url"];

}

Thursday, July 10, 2025

How to create and download txt file programaticaly with asp.net c# and write content in it

Response.Clear();

Response.Write("This is an HttpHandler Test.");

Response.Write("<p>Your Browser:</p>");

Response.AddHeader("content-disposition", "attachment; filename=t.txt");

Response.End();

How to download pdf file from server not on database only on server - Simplest way

//only two lines code is required that is uncommented

//Response.Clear(); // This is i am not using because response.clear is used for clearing http response (like text) but this is a file that is presently on server. Also when we create pdf of text file than we use clear function and we are getting pdf file from database (binary fromat) Response.buffer is default true so we don't need.

Response.AddHeader("content-disposition", "attachment; filename=t.pdf");

//Response.ContentType = System.Net.Mime.MediaTypeNames.Application.Pdf;

//"application/octet-stream";

Response.WriteFile(Server.MapPath("~/App_Data/Annexure.pdf")); // File must be there on server otherwise it will give error

//Response.end is also we are not using because we are not creating pdf file , if we create pdf file or we are getting from database than we use Response.End and Response.Clear() functions.

Response.WriteFile or Response.TransmitFile use in asp.net c# - how to view pdf or text file in web browser

It is used to show the content of any file in web browser. This is same as response.write but it will write the content of the file to web page. Mainly it is used to view the file content not to download the file. Both Response.WriteFile or Response.TransmitFile are same

example if text file than use code below

For PDF file

Response.ContentType = System.Net.Mime.MediaTypeNames.Application.Pdf;

Response.WriteFile(Server.MapPath("~/App_Data/Annexure.pdf"));

For txt file

Response.Clear();

Response.ContentType = System.Net.Mime.MediaTypeNames.Text.Plain; and use Text.html

//"application/octet-stream";

Response.WriteFile(Server.MapPath("~/App_Data/yash.txt"));

Response.End();

or on page load, simply we can show the content of text file

Response.WriteFile("~/App_Data/" + fileName);

Friday, June 20, 2025

Website admin tool - access rules for files and folders

Access rules are store in web.config for each folder

example like below:-

<?xml version="1.0" encoding="utf-8"?>

<system.web>

</authorization>

</system.web>

</configuration>

How to download the file using handler in asp.net c# of any format or extension - using anchor tag

public void ProcessRequest(HttpContext context)

{

if (context.User.Identity.IsAuthenticated)

{

string filename = context.Request.QueryString["File"];

//Validate the file name and make sure it is one that the user may access

context.Response.Buffer = true;

context.Response.Clear();

context.Response.AddHeader("content-disposition", "attachment; filename=" + filename);

context.Response.ContentType = "application/octet-stream";

//File(HelloWorld.txt) should be present on server in App_Data folder , otherwise it will show error

context.Response.WriteFile("~/App_Data/" + filename);

}

aspx page

<a href="MyFileHandler.ashx?File=HelloWorld.txt">Click Here to Get File</a>

string fileName = context.Request.Params["File"];

context.Response.ContentType = System.Net.Mime.MediaTypeNames.Application.Pdf; //"application/pdf"

//File(HelloWorld.txt) should be present on server in App_Data folder , otherwise it will show error

context.Response.WriteFile("~/App_Data/" + fileName);

How to download the file using transmitfile function in asp.net c#

Response.ContentType = "application/pdf";

Response.AppendHeader("Content-Disposition", "attachment; filename=MyFile.pdf");

//MyFile.pdf should be present in Files folder on server. other wise it will show error file not found.

Response.TransmitFile(Server.MapPath("~/Files/MyFile.pdf"));

Response.End();

reference:-https://www.c-sharpcorner.com/UploadFile/afenster/how-to-download-a-file-in-Asp-Net/

why Http Handler are used - Introduction to handler

Http handlers are used for

Binary files

Dynamic image views

Performance-critical web pages

XML files

Minimal web pages

and these are fast and it only gives minimum response. example when you write

Response.ContentType = "text/plain";

//MediaTypeNames.Text.Plain

in aspx page it will give lot of information.

and when you write this in handler it will give only specific information that you want.

Also no return type of processrequest funtion in http handler

you can create other return type function in handler and also create model in handler.

Thursday, June 19, 2025

Computer vs television - difference between computer and television

Computer is having data and english hindi lanuguage all time. and text is very small

but in television we have visual things , and text is very large if it had

Tuesday, June 17, 2025

How to split the comma separated string to list of array in C#

string tags = "9,3,12,43,2"

tags.Split(',').Select(int.Parse).ToList();

How to convert bytes to string and string to bytes in c#

string author = "Mahesh Chand";

// Convert a C# string to a byte array

byte[] bytes = Encoding.ASCII.GetBytes(author);

foreach (byte b in bytes)

{

Response.Write(b );

Response.Write(Environment.NewLine);

}

bytes to string

string myString = Encoding.ASCII.GetString(bytes);

Response.Write(str);

How to convert bytes to base64string in c#

using fileupload control

Convert.ToBase64String(fileUpload1.FileBytes);

using memory stream

Stream fs = fileUpload1.PostedFile.InputStream;

BinaryReader br = new BinaryReader(fs);

Byte[] bytes = br.ReadBytes((int)fs.Length);

Convert.ToBase64String(bytes );

base64 string meaning

the upper- and lower-case Roman alphabet characters (A–Z, a–z), the numerals (0–9), and the "+" and "/" symbols, with the "=" symbol as a special suffix code

How to save bytes data to image

using memory stream

MemoryStream m = new MemoryStream(bytes);

System.Drawing.Image MyImage = System.Drawing.Image.FromStream(m);

MyImage.Save(filepathandname)

====================

using fileupload control

fileUpload1.FileBytes;

string filepathandname = Server.MapPath(string.Format("~/uploads/{0}-{1}.{2}", DateTime.Now.ToShortDateString(), Guid.NewGuid(), ".png"));

MyImage.Save(filepathandname)

How to save a file to binary data to varbinary sql server in asp.net c# - How to save file to database with varbinary(max) datatype

Using fileupload field

byte[] bb = fileUpload1.FileBytes;

SqlConnection con = new SqlConnection(ConnectionString.ConString);

con.Open();

SqlCommand cmd = new SqlCommand("INSERT INTO UploadFiles (FileData, ContentType) VALUES (@filedata, @ContentType)", con);

cmd.CommandType = System.Data.CommandType.Text;

cmd.Parameters.AddWithValue("@FileData", fileUpload1.FileBytes);

cmd.Parameters.AddWithValue("@ContentType", fileUpload1.PostedFile.ContentType);

cmd.ExecuteNonQuery();

con.Close();

===============================

using binary reader

Stream fs = fileUpload1.PostedFile.InputStream;

BinaryReader br = new BinaryReader(fs);

Byte[] bytes = br.ReadBytes((int)fs.Length);

Stream fs = fileUpload1.PostedFile.InputStream;

Byte[] bytes = br.ReadBytes((int)fs.Length);

object vs instance - object instance - instance vs object in c#

object are also called instance.

Friday, June 6, 2025

Fundamental unit of data

Fundamental unit of data in computer is bit or binary digit 0, 1

how to convert byte array to image in asp.net

Byte[] bytes = fileUpload1.FileBytes;

MemoryStream m = new MemoryStream(bytes);

System.Drawing.Image MyImage = System.Drawing.Image.FromStream(m);

string filepathandname = Server.MapPath(string.Format("~/uploads/{0}-{1}-{2}", DateTime.Now.ToShortDateString(), Guid.NewGuid(), ".png"));

MyImage.Save(filepathandname);

Thursday, June 5, 2025

How to see or view a base 64 image file or image file in HTML page and how to see image file base 64 with URL - How to view image in html page

<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABkAAAAOECAYAAAD5Tf2iAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAP+lSURBVHhe7N0LYFTVuTb+B1AkeIGEm0CABBAiglyD3CINoqJoKRSRNqWtSEUK51NrgVKPHD48LYLHqt8fSvEgtlJaRAqlFouKIAUBCYIXREAggVwAA0lQgQgK//2uvfbMnvueaybx+dld9m1m1r5OZr17rbdOt249LoGIiIiIiIiIiIiIiKgWqav/JSIiIiIiIiIiIiIiqjUYACEiIiIiIiIiIiIiolqHARAiIiIiIiIiIiIiIqp1GAAhIiIiIiIiIiIiIqJahwEQIiIiIiIiIiIiIiKqdep069bjkh4nIiIiIiIiIiKq1erXv0KPEVFtdf78V3qMvu3YAoSIiIiIiIiIiIiIiGodBkCIiIiIiIiIiIiIiKjWqdeixbWz9Hi1qFevHn7zmydwyy1DUFVVhaKiIr2EiIiIiIiIiIgoturVu0yP

If error occurs in visual studio that iisexpress.exe access is denied and you build the web site it shows no error but it is having error

Than Run visual studio as administrator

Sunday, June 1, 2025

Web api get post delete and put difference in apicontroller class

public class ValuesController : ApiController

{

//For get all data

public IEnumerable<BookMaster> Get()

{

}

//For get by ID

public void Get(int id)

{

}

[HttpPost] // insert or add or create new

public string Post([FromBody]string value)

{

return value;

}

// PUT api/<controller>/5 update

public void Put(BookMaster bookMaster)

{

}

// DELETE api/<controller>/5

[HttpDelete]

public void Delete(int id)

{

}

How to use ObjectDataSource in asp.net with Model or business object and controller or login layer

>Add object datasource from controls in visual studio

> Add TypeName Property(class name .cs file) where you have get, update and delete methods.

>Click on configure data source and select dataset or typename file and you will get select insert update delete methods and click on finish and use this object datasource id in grid view or other controls.

bulk insert with single insert query in sql

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

Slider

Carousel Example

LinkList

Wednesday, December 31, 2025

Tuesday, December 30, 2025

Monday, December 29, 2025

Friday, December 26, 2025

Wednesday, December 24, 2025

Tuesday, December 23, 2025

Monday, December 22, 2025

Friday, December 19, 2025

Monday, December 15, 2025

Wednesday, December 10, 2025

Thursday, November 27, 2025

Tuesday, November 25, 2025

Monday, November 24, 2025

Friday, November 21, 2025

Thursday, November 20, 2025

Tuesday, November 18, 2025

Monday, November 17, 2025

Thursday, November 13, 2025

Tuesday, November 11, 2025

Monday, November 10, 2025

Thursday, November 6, 2025

Wednesday, October 29, 2025

Tuesday, October 28, 2025

Friday, October 3, 2025

Wednesday, October 1, 2025

Tuesday, September 30, 2025

Monday, September 29, 2025

Friday, September 19, 2025

Monday, September 15, 2025

Thursday, September 11, 2025

Tuesday, September 9, 2025

Friday, September 5, 2025

Sunday, August 31, 2025

Wednesday, August 20, 2025

Friday, August 15, 2025

Thursday, August 14, 2025

Tuesday, August 12, 2025

Monday, August 11, 2025

Friday, August 8, 2025

Thursday, August 7, 2025

Tuesday, July 29, 2025

Monday, July 28, 2025

Thursday, July 17, 2025

Thursday, July 10, 2025

//only two lines code is required that is uncommented

Friday, June 20, 2025

Thursday, June 19, 2025

Tuesday, June 17, 2025