In this post we will see a VB.Net Program to retrieve list of file names in a given folder/directory.  

Sample Output : 

In this post we will see a VB.Net Program to retrieve list of file names with full path in a given folder/directory.  

Sample Output : 

 

Sample Output :

 

Sample Output 1: Sample Output 2:

 

Sample output 1 : Sample output 2 : Sample output 3 :  

Output :  

 

Output : Explanation : Actually here we are printing the ASCII smbol of 3 . Which gives a love symbol. you can also print directly by writing the following code.  Console.Write(Convert.ToChar(3))  or  Console.Write(ChrW(3))  

  Sample Output :

Lets suppose Database Name is MYDB and TABLE1, TABLE2, TABLE3 are tables in MYDB databaseSql query to retrieve all the column names in a table : select COLUMN_NAME from MYDB.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ‘TABLE1’Sql query to get common Columns in two tables in Sql Server : select COLUMN_NAME from MYDB.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ‘TABLE1’ intersect select COLUMN_NAME from MYDB.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME… Continue Reading Sql query to get common Columns in multiple tables in Sql Server

Sample Output :