Following are five of my favorite keyboard shortcuts in Microsoft Visual Studio.
Monday, August 8, 2016
Wednesday, June 29, 2016
Create XML using EXCEL
Many a time I have got question about how to create XML with excel, So I decided to add this into my blog. Hope this will help the readers.
step 1:
Create one schema file (A template that we will use to generate the xml).
Eg. (Save following lines in dataSchema.xml file)
Step 2:
Open your excel file containing the data.
step 1:
Create one schema file (A template that we will use to generate the xml).
Eg. (Save following lines in dataSchema.xml file)
Step 2:
Open your excel file containing the data.
CountryID | CountryName |
1 | India |
2 | Pak |
3 | Srilanka |
4 | China |
5 | Koria |
Step 3:
Go to the Developer TAB, if it is not on the top then you need to enable it from (File > Option )
Step 4:
Click "Source" under XML.
It will open XML source panel, having two buttons at the bottom. Click "XML Maps...".
Step 5:
Click "Add" to the XML Maps window.
Step 6:
Select "dataSchema.xml" file that we created in Step 1
Click OK twice
Step 7:
In XML Source you can now see the TREE VIEW of your columns.
Step 8:
Drag and Drop each column to the first row of your data.
Step 9.
Click "Export" button in Developers > XML tab.
Step 10:
You can now save this file as XML and that's it. Done.
Tuesday, June 7, 2016
Which programing languages are useful for hacking
Important Programming languages for Hackers
Many of our readers often send us queries about which programming language they should learn. Some want to know quick fix hacking solutions. Almost all tech gadgets are built with coding. Every App, game or site that you use is programmed in a particular computer language. You need to know that hacking is not a click-of-a-button job but a serialized and compartmentalized vocation which uses different programming languages for different uses.
Most of the websites out there will give you list of most popular programming languages in the world. We at Techworm try to make it more easy for budding security researchers and hackers by breaking up the programming languages used by hackers.
Hacking is usually meant to break a code. There are three sections of hacking ― Web Hacking, Exploit Writing & Reverse Engineering and each of it requires different programming language
1. Web Hacking
Since most of the tech is build around world wide web, it is important to learn web hacking to be a good hacker. Let’s say you are interested in hacking web apps and/or websites then you will need to learn web coding. Websites use mostly HTML, PHP and JavaScript so it is important to learn these three.
HTML:
One of the easiest and widely used static markup web language present in each and every website you see in your browser. It’s recommended to learn HTML because it helps understanding web actions, response, and logic.
JavaScript:
JS is a client-side web programming mostly used in web sites for better user interface and quick response. If you are interested in a hacking career you need to learn JavaScript because it helps to understand client-side mechanism which is essential for finding client-side flaws.
PHP:
A dynamic server-side language which is responsible for managing web-apps and database. PHP is considered one of the most essential language because it controls everything on site and server, like a captain of a ship. It is advised to learn PHP nicely.
SQL:
SQL is responsible for storing and managing sensitive and confidential data such as user credentials, bank and personal information about the website visitors. Black hat hackers mostly target SQL database and steal information which is later sold on underground dark web forum. If you want to be good security researcher, you should learn SQL so that you can find flaws in a website and report them.
2. Exploit Writing
After web hacking, another most important feature of hacking is exploits. You can crack a particular software by writing a exploit. But to write a exploit you need to learn either Python or Ruby.
Python:
It is said that a security researcher or hacker should know Python because it the core language for creating exploits and tools. Security experts and even pro hackers suggest that master Python is the best way to learn hacking. Python offers wider flexibility and you can create exploits only if you are good in Python.
Ruby:
Ruby is a simple yet complicated object-oriented language. Ruby is very useful when it comes to exploit writing. It is used for meterpreter scripting by hackers. The most famous hacker tool, Metasploit framework is programmed in Ruby. Though Ruby may not be as versatile as Python, knowledge of Ruby is must in understanding exploits.
3. Reverse Engineering
Reverse engineering, the process of taking a software program’s binary code and recreating it so as to trace it back to the original source code. If you know reverse engineering you can find flaws and bugs easily. If you want to learn reverse engineering you need to know C, C++ and Java. The process of converting the code written in high level language into a low level language without changing the original program is known as reverse engineering.
Do you think any other programming language is essential for wannabe hackers and security researchers? if yes then please comment below.
Reference:
Many of our readers often send us queries about which programming language they should learn. Some want to know quick fix hacking solutions. Almost all tech gadgets are built with coding. Every App, game or site that you use is programmed in a particular computer language. You need to know that hacking is not a click-of-a-button job but a serialized and compartmentalized vocation which uses different programming languages for different uses.
Most of the websites out there will give you list of most popular programming languages in the world. We at Techworm try to make it more easy for budding security researchers and hackers by breaking up the programming languages used by hackers.
Hacking is usually meant to break a code. There are three sections of hacking ― Web Hacking, Exploit Writing & Reverse Engineering and each of it requires different programming language
1. Web Hacking
Since most of the tech is build around world wide web, it is important to learn web hacking to be a good hacker. Let’s say you are interested in hacking web apps and/or websites then you will need to learn web coding. Websites use mostly HTML, PHP and JavaScript so it is important to learn these three.
HTML:
One of the easiest and widely used static markup web language present in each and every website you see in your browser. It’s recommended to learn HTML because it helps understanding web actions, response, and logic.
JavaScript:
JS is a client-side web programming mostly used in web sites for better user interface and quick response. If you are interested in a hacking career you need to learn JavaScript because it helps to understand client-side mechanism which is essential for finding client-side flaws.
PHP:
A dynamic server-side language which is responsible for managing web-apps and database. PHP is considered one of the most essential language because it controls everything on site and server, like a captain of a ship. It is advised to learn PHP nicely.
SQL:
SQL is responsible for storing and managing sensitive and confidential data such as user credentials, bank and personal information about the website visitors. Black hat hackers mostly target SQL database and steal information which is later sold on underground dark web forum. If you want to be good security researcher, you should learn SQL so that you can find flaws in a website and report them.
2. Exploit Writing
After web hacking, another most important feature of hacking is exploits. You can crack a particular software by writing a exploit. But to write a exploit you need to learn either Python or Ruby.
Python:
It is said that a security researcher or hacker should know Python because it the core language for creating exploits and tools. Security experts and even pro hackers suggest that master Python is the best way to learn hacking. Python offers wider flexibility and you can create exploits only if you are good in Python.
Ruby:
Ruby is a simple yet complicated object-oriented language. Ruby is very useful when it comes to exploit writing. It is used for meterpreter scripting by hackers. The most famous hacker tool, Metasploit framework is programmed in Ruby. Though Ruby may not be as versatile as Python, knowledge of Ruby is must in understanding exploits.
3. Reverse Engineering
Reverse engineering, the process of taking a software program’s binary code and recreating it so as to trace it back to the original source code. If you know reverse engineering you can find flaws and bugs easily. If you want to learn reverse engineering you need to know C, C++ and Java. The process of converting the code written in high level language into a low level language without changing the original program is known as reverse engineering.
Do you think any other programming language is essential for wannabe hackers and security researchers? if yes then please comment below.
Reference:
Saturday, May 28, 2016
USE FULL ABBREVIATIONS
1)GOOGLE: global organization of oriented group language of earth..
2)YAHOO: yet another hierarchical officious oracle..
3)WINDOW: Wide interactive network development for office work solution
4)COMPUTER: Communication oriented machine purposely utilized technical educational research a scholarly article.
5)VIRUS: virtually infected reputed utilized software
6)UMTS: universal mobile telecommunication system
7)AMOLED: active matrix organic emitting diode.
8)OLED: organic light emitting diode.
9)IMEI: international mobile equipment identity.
10)ESN: electronic serial number.
11)UPS: uninterruptiblepower supply.
12)HDMI: high definition multimedia interface.
13)VPN: virtual private network.
14)APN: access point name.
15)SIM: subscriber identity module.
16)LED: light emitting diode.
17)DLNA: digital line network access.
18)RAM: random access memory.
19)ROM: read only memory.
20)VGA: video graphic array.
21)QVGA: quarter video graphic array.
22)WVGA: wide video graphic array.
23)WXGA: wide extended graphic array.
24)USB: universal service bus.
25)WLAN: wireless local area network.
26)PPI: pixel per inch.
27)LCD: liquid crystal display.
28)HSDPA: high speed downlink packet access.
29)HSUPA: high speed upload packet access.
30)HSPA: high speed packet access.
31)GPRS: general packet radio service
32)EDGE: enhancement data rate for global evolution.
33)NFC: near field communication.
34)OTG: on-the-go
35)S-LCD: super clear liquid display.
36)O.S: operating system.
37)SNS: social networking sites
38)H.S: HOTSPOT
39)P.O.I: point of interest
40)GPS: global position system
41)DVD: digital video disc
42)DTP: desk top publishing.
43)DNSE: digital natural sound engine.
44)OVI: Ohio video intranet.
45)CDMA: code division multiple access.
46)WCDMA: wide-band code division multiple access.
47)GSM: global system for mobile communication.
48)WI-FI: wireless fidelity
49)DIVX: digital internet video access.
50)APK: authenticated public key.
51)J2ME: java 2 micro edition
52)SIS: symbian installation source.
53)DELL: digital electronic link library.
54)ACER: acquisition collaboration experimentation reflection.
55)RSS: really simple syndication
56)TFT: thin film transistor
57)AMR: adaptive multi rate
58)MPEG: moving pictures experts group
59)IVRS: interactive voice response system.
60)HP: Hewlett-Packard
Thursday, May 19, 2016
Retrieving data from SQL Server using RecordSet object in VBScript
Option Explicit
Dim Conn ' Connection Variable
Dim rs ' Recordset Variable
Dim sqlQuery
Dim serverName
Dim field
'Declare the SQL statement that will query the database
sqlQuery = "SELECT UserName FROM dbo.UserList WHERE ID = '9'"
'Create an instance of the ADO connection and recordset objects
Set Conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
'Open the connection to the database
Conn.Open "DSN=getUser;UID=user1;PWD=password;Database=dbUserList"
'Open the recordset object executing the SQL statement and return records
rs.Open sqlQuery,Conn
'Check if any record exist in table
If rs.EOF Then
wscript.echo "No Record Found"
wscript.quite
Else
Do While NOT rs.Eof
field = rs("UserName")
if field <> "" then
wscript.echo field
end if
rs.MoveNext
Loop
End If
'Close Connection and Recordset
rs.Close
Set rs=nothing
Conn.Close
Set Conn=nothing
Dim Conn ' Connection Variable
Dim rs ' Recordset Variable
Dim sqlQuery
Dim serverName
Dim field
'Declare the SQL statement that will query the database
sqlQuery = "SELECT UserName FROM dbo.UserList WHERE ID = '9'"
'Create an instance of the ADO connection and recordset objects
Set Conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
'Open the connection to the database
Conn.Open "DSN=getUser;UID=user1;PWD=password;Database=dbUserList"
'Open the recordset object executing the SQL statement and return records
rs.Open sqlQuery,Conn
'Check if any record exist in table
If rs.EOF Then
wscript.echo "No Record Found"
wscript.quite
Else
Do While NOT rs.Eof
field = rs("UserName")
if field <> "" then
wscript.echo field
end if
rs.MoveNext
Loop
End If
'Close Connection and Recordset
rs.Close
Set rs=nothing
Conn.Close
Set Conn=nothing
VBScript Prompt a User for Input
It was been ask by one of my friend that how to get input from user in VBScript. I though by adding this to blog, that will help other.
getStringValue = InputBox("Please enter some value :","Window Title")
You can also use this in condition also in this.
If getStringValue="" then
Wscript.Quite
else
Wscript.Echo getStringValue
End if
Wednesday, May 18, 2016
VBScript to update Access Database
Save following line to .VBS file
Const adOpenStatic = 3
Const adLockOptimistic = 3
Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")
objConnection.Open _
"Provider = Microsoft.Jet.OLEDB.4.0;; Data Source = C:\Temp\Local.mdb"
objRecordSet.Open "Update
objConnection, adOpenStatic, adLockOptimistic
OR
objRecordSet.Open "Insert into
objConnection, adOpenStatic, adLockOptimistic
Execute script Via Command Line
- Hold your windows key and press “R” to open the command prompt
- type: “%windir%\SysWoW64\wscript.exe
” - Press OK
Subscribe to:
Posts (Atom)