Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Visual Basic > Document Management

Document Management

1-20 of 91     Previous     Next
CSV2DataTable - Importing the data contained in a CSV file into a new DataTable
by Marco Bellinaso
Import the data contained in a CSV file into a new DataTable. By default the values are Tab delimited, but you can use the second overload version to use any other string you want. Example: Dim table As DataTable = CSV2DataTable("D:\Users.txt") DataGrid1.DataSource = table
DataTable2CSV - Saving a DataTable to a CSV file
by Marco Bellinaso
Save the input DataTable to a CSV file. By default the values are Tab delimited, but you can use the second overload version to use any other string you want. Example: Dim ds As New DataSet SqlDataAdapter1.Fill(ds, "Users") DataTable2CSV(ds.Tables("Users"), "D:\Users.txt")
FindFiles - Finding all files with a given filespec
by Francesco Balena
Finding all files with a given filespec into an ArrayList. Optionally scan also subdirectories of the input dir Example: Dim files As New ArrayList FindFiles(files, "D:\Articles", "*.doc", True) For Each file As String In files Debug.WriteLine(file) Next
FileToArray - Reading all lines from a text file into a String array
by Marco Bellinaso
Read all lines from a text file into a String array Example: Dim lines As String() = FileToArray("D:\test.txt") Dim line As String For Each line In lines Debug.WriteLine(line) Next
JoinBinaryFiles - Joining a variable number of binary files into a single file
by Marco Bellinaso
Join a variable number of binary files into a single file Params: - resultFile: the complete path of the result file you want to create - sourceFiles: the sequence of files whose content will be joined together Example: JoinBinaryFiles("D:\Test.bin", "D:\Source1.bin", "D:\Source2.bin", ...
CountFileCharacters - Counting how many characters of a given type are in a file
by Marco Bellinaso
Count how many characters of a given type are in a file Example: Dim charCount(255) As Integer CountFileCharacters("c:\test.txt", charCount) Debug.WriteLine("the char 'A' was found " & charCount(Asc("A")) & " times") Debug.WriteLine("the char 'a' was found " & charCount(Asc("a")) & " ...
GetDriveLabel - Retrieving the label of the specified drive
by Marco Bellinaso
Retrieve the drive name (label) of the specified drive Note: requires a reference to the System.Management assembly Example: MessageBox.Show(GetDriveLabel("D"c))
GetDriveSerialNumber - Retrieving the serial number of the specified drive
by Marco Bellinaso
Retrieve the serial number of the specified drive Note: requires a reference to the System.Management assembly Example: MessageBox.Show(GetDriveSerialNumber("D"c))
GetUrlFromLinkFile - Retrieve the Url pointed by a link (*.url) file
by Marco Bellinaso
Get the Url pointed by the input link (*.url) file Example: print the Url of all the link files in the Favorites folder Dim filePath As String For Each filePath In System.IO.Directory.GetFiles( _ Environment.GetFolderPath(Environment.SpecialFolder.Favorites), "*.url") Debug.WriteLine(System.IO.
SetFileLength - Set the length in bytes of the input file
by Marco Bellinaso
Set the length in bytes of the input file Example: Dim filePath As String = "c:\test.txt" MessageBox.Show("Original length: " & New System.IO.FileInfo(filePath).Length) SetFileLength(filePath, 50000) MessageBox.Show("New length: " & New System.IO.FileInfo(filePath).Length)
GetResourceContent - Retrieving the content of an embedded text file
by Marco Bellinaso
Retrieve the content of an embedded text file Note: the file must be included in the project as an embedded resource. - after adding the file to the project set its Build Action property to Embedded Resource Example: txtScript.Text = GetResourceContent("script.sql")
IsDriveReady - Returns whether a drive is ready
by Marco Bellinaso
Returns a boolean indicating whether a given drive is ready Example: check if the floppy disk drive is ready Debug.WriteLine(IsDriveReady("a"))
IsExecutableFile - Returns whether the file is an executable
by Marco Bellinaso
Returns a boolean indicating whether the file is an executable
IsImageFile - Returns whether the file is an image
by Marco Bellinaso
Returns a boolean indicating whether the file is an image
SearchFileInDirTree - Searches a file on a directory tree
by Marco Bellinaso
Returns the complete path+name of the filename or a null string if the filename hasn't been found. Only the first occurrence of the file is returned. Example: Debug.WriteLine(SearchFileInDirTree("d:\codearchitects\codebox", "codebox.exe"))
SearchFileOnPath - Searching a file on the system
by Marco Bellinaso
Searches a file on the system Returns the complete file path+name, or "" if file not found If searchDirs is omitted, then the file is searched in the following directories, in this order 1. the directory from where the app loaded 2. the current directory 3. the \Windows\System32 directory ...
CompareFiles - Comparing two binary/text files
by Marco Bellinaso
Returns a boolean indicating whether two files are equal Example: Debug.WriteLine(CompareFiles("D:\File1.mdb", "D:\File2.mdb"))
ConcatenateFiles - Concatenating multiple text files
by Marco Bellinaso
Concatenate a variable number of text files into a single result file Params: - resultFile: the complete path of the result file you want to create - header: a string that is written when a file is added to the result file. Note: this string can contain the #FilePath# tag that will be ...
FolderHasFiles - Returns whether the specified folder has files
by Marco Bellinaso
Returns a boolean indicating whether the specified folder has files
FolderHasSubFolders - Returns whether the specified folder has sub-folders
by Marco Bellinaso
Returns a boolean indicating whether the specified folder has sub-folders
1-20 of 91     Previous     Next
Sitemap