how to import all files in a dir and sub dir with a selected filetype, lets say jpg to a listbox
ListBox1.DataSource = My.Computer.FileSystem.GetDirectoryInfo("c:").GetFiles("*.jpg")
or
[Code].....
Is there a way to get a list of all files in a folder but exclude a certain filetype/extension? Or is the only way to do it is to get all files & loop through them & exclude the filetype with an If statement?
View 3 RepliesWhen .Clear() is invoked, is the memory freed up that was allocated when all of the items were added? I need to load several lists of codes from a database depending on the import selected by the user. Each list of codes will be a List(Of String). My idea is that I will load only small strings into a List(Of String) along with a List(Of <class>) for the data I will be validating and manipulating. When I am done, I want all of the data from the Lists to be purged from memory. Will .Clear() take care of that or does the memory still remain allocated and have to be dumped by the OS once memory gets full? (And, incidentally, what causes the OS to decide which memory blocks to dump? FIFO concept?)
There are so many lists, I'm not sure if I just want them sitting in memory or not. Granted, the lists will just consist of a single string value for each code pulled from the database. So there won't be a ton of data, so maybe I could just load all the validation lists at the beginning of runtime and only worry about purging the data List since it will contain between 35-50 "fields" per record and there will be a couple thousand records each import that is run. I don't want my program to actually cause a hit in performance in the long run. I ultimately don't see a problem because I won't be running millions or even hundreds of thousands of records at once, but I just want to be sure.
I am new to using VB.NET, I've come from developing using MS Access.
I have started a project that will load csv/txt files into SQL Server, I have a form that has a browse for file and this will then display the csv/txt file name in a text box once chosen. How is it posible to use an ADO connection send the csv/txt file into a table within my database.
Can anyone give me little help to get the basics of creating code to import the csv/txt files.
I'm using VB.NET 2005 RC and I have built a custom component which consists of a search screen, data grid, dataset etc. The whole project is designed to be imported in to any new application as a custom control which can then be programmatically changed via its methods, events etc. When I tried to import the .dll in to a new windows forms project all the extra stuff contained in my project was also magically imported (such as the dataset I had used, the SQL connection) etc.I have set these their modifier to be private but still they are imported.
What can I do so when a developer imports this custom control in to their toolbox for use, only the control is shown? Otherwise it looks a bit weird to have access to the dataset I'm using with access to the dataset I'm using within the control.
I put a few different files into their my program, how i can do export them and choose to store on my computer
View 7 RepliesHow can i go about associating my application with a filetype e.g *.safsg ? How can i get my program to open them file types when that filetype is double clicked on desktop for example.
View 1 RepliesIn vb2010 I started getting an error message because I was still using FileListBoxes from VB6 and now they supposedly aren't supported in 64 bit systems. So I am replacing those with ListBoxes. I got the images to load fine into the list box using the FolderBrowserDialog. but (see the snippet below), I want to filter for several image types, not just one or a generic wild card which would pull in even non-image filetypes. This language will only accept one extension wildcard parameter it seems:
(sp is a string containing the folderbrowser dialogue path)
[Code]...
Is it possible to limit the asp.net fileupload dialog to view only XML files?(Filer, .xml only)
Note: Not to check whether the extension is .xml, but to actually only let the user view xml files in the dialog.
the files i import into the listbox have the full name so like... c:/users
View 8 RepliesI'm looking for a solution to import or link logs (csv and txt files) to Access using ODBC. These files are in a directory and I would like to link each of them to a table in Access to analyze their content. I'd like to use ODBC rather than the Access' Import Wizard because I want to keep the possibility to change the format and/or delimiters of my files if necessary.I settled an ODBC Driver "Microsoft Access Text Driver" but when I try to open the connection in Access, I get the error "You cannot use ODBC to import from, export to or link an external Microsoft Office Access or ISAM database table to your database".This connexion works perfectly in Excel and enable me to get the data in an excel spreadsheet. I'd like to do the same from Access to use Access' functionalities!
View 3 Replieseverytime I import some file to my program, like a picture, I write down the ImageLocation, but if after the program is ready I delete the picture or send the program to a friend who hasn't the same picture at the same location...
View 2 RepliesHow do you associate a filetype, for example ".tkoen" (idk..), to the registry without restarting Explorer.exe for updating the filtypes..in Explorer.exe..?
View 2 RepliesHow can I import all files within the boot c:\ drive, in listview? it has to be something like a openfiledialog window but then evrything in a list view. I have alredy this in a console aplication but this only load the systemfiles.
[Code]...
how I could go about making a simple little program in Visual Basic 2010 that has a button you click with drop down menu beside it to search for an excel or sql file on your computer and then you select it. Then you click a button saying "import into sql" or a different button saying "export to excel."
These buttons would of course do what they say... either importing the chosen excel file into sql or exporting the sql file into excel.
My application is often used to import volumes of data. The application currently supports .CSV, .XML, and XLS. The question relates to handling EXCEL files. Specifically, what are the best practices for coding?
Today, since customers are beginning to see .XLSX files coming in, I modified the code to use either JET.OLEDB.4.0 or .ACE.OLEDB.12.0 depending on whether it was reading an .XLS or an .XLSX. My instincts tell me that cannot be the correct way to go about this. First, customers still using Office 2003 are going to have to download the AccessDatabaseEngine in order to read the .XLSX files. Second, what if a customer installs Office 2010? Are they going to have the 12.0 stuff or am I now faced with another issue.
[Code]...
I am justing looking for how to Import whole directory with the text files and picture. I know about the file handling through which we can Import single file to form in vb.
View 4 Repliesthe function to call the command filetype=jes. My calls to the ftp site arequote site filetye=jesasciiput filename.extquote site filetype=seqI have looked at the system.net.ftpwebrequest class and it works great for sending and files but need this one command to finish the call
View 6 RepliesI am trying to select a folder in a very similar way that we do using "OpenFileDialog". I searched for different sites and did find something but all of codes were tweaking "OpenFileDialog" and selected files..... I have seen applications where the select dialog box does NOT show the "File Type" as well as the "Open" button has "Select" name on it. Any idea how to get such dialogbox?
View 8 Repliesi have a datagrid view, how can i use this or another item from toolbox to import and make excel files? if possible, include some coes that will make it work,I like...Understandable Answers
1 2 3 4 5
- - - - - Rate yourself And Have A Kitkat
5 5 5 5 5
I am using data grid view in Vb.net and would like to load two excel files into it. My two excel files look like this:
[Code]...
The problem I want to solve is the following:I would like to map the values from the data set in file 2 to the sorted data set from file 1. So for example If I want to sort all the data by id# descending then (using the example from above) the data in datagrid view1 and in datagridview2 should be reversed.
Right now if I sort the column from file1 in datagrid view all the other columns in THIS datagridview1 are also sorted in relation to column2. What I want is that the columns in file2 will also sort according to file1.
How do import all files whit the same extension (whit extension i mean all for example .exe files or .avi files) directly in an listbox as the program loads. [code]...
View 4 RepliesI am using Datagridview and ListView Controls in my windows desktop application using vb.net.I want to Import data directly to Excell sheet and CSV file directly from form.
View 3 RepliesI am writing a Windows service to import data from CSV files dropped into a directory. One of the steps is to load an XML file with validation rules which I load into a List(Of T). It will pull the data, and then I have it pass the list to a class that monitors the folder and processes the files. After that I clear the list and read in the next file configuration. Now I have noticed that the validation rules aren't matching up and it seems that the list is being passed as a reference type even though the signature is of a value type.Is there anything I can do to get around this?
[Code]...
So here when I pass it, at first it will have 3 validation rules in the new ImportService class I created, but when I call fields.Clear(), it wipes out the class member of the ImportService class.
I want it to do the following: When they click the import button, open multiple files (done) then save them as a settings. Then on form load, open those files so I do not have to re-import them!
I have tried this
CODE:
on form load and settings.txt included 2 file names and locations. It is only opening the 2nd file NOT the first. How can I make it open ALL files in that settings file? I also tied ReadLines
I am developing an app that will import numeric data and export it to various text files using ascii templates. I am basically converting the template file into a single string, replacing application fields in the string with {0}, {1}, etc... and adding the result into an array that is then passed to the String.Format(str_Template, Params()) to provide the final output. I have set it up so the template will use the standard VB.Net formatting syntax.
A simple template example:
{<prt_Mark>:G} {<prt_Qty>:F2} {<prt_Length>:F2} {<prt_Remarks>:G}
[code].....
Does anyone has a sample code that do like,Open and select excel file and select the exact excel sheet to import then connect to SQL server 2008 and append all the data from the certain sheet to the SQL table?
View 8 RepliesI've got a piece of VB script that runs from a logon script. It contains the line: objShell.run("regedit /s/c \SERVERNETLOGONScriptTest.reg", 0) Which imports a file into the registry just as I want. The /s switch means that I don't get the two warnings from the regedit program which is exactly what I'm looking for but everytime it runs the UAC asks for permission to make changes to the computer which of course I don't want to happen.
[Code]...
So I have two ListBoxes. Listbox1 gathers files from a directory and I have an add button to add selected files from Listbox1 over to Listbox2.
Is there a way to manually sort these items? Maybe with an up down buttons?
The reason I'd like to sort/reorder is I'll have a process that will run those selected files and each file will have to produce another file unique to the filename.
A quick example would be process FILE1.txt and produce FILE1.pdf, etc.
Is there an easier way to accomplish the sort/reorder?
UPDATE
Here is currently how I'm populating my listbox1, before adding anything to listbox2, which is the ListBox I'd like to have sorted so way or another.
Dim directoryInfo As _
New System.IO.DirectoryInfo(FolderBrowserDialog1.SelectedPath)
Dim fileInfos() As System.IO.FileInfo
[Code].....
I'd like to start off by saying I'm extremely new to programing (3weeks) and I've come across a problem with my code. I've created a form that copies files from one folder to another. A user can either copy all files or selects files from a list box. Due to the size of the files the program freezes when performing the task. I have used backgroundworker component for copying all files and it works fine (no freeezing ). When I use the backgroundworker component for copying selected files I receive an error.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
BackgroundWorker2.RunWorkerAsync()
End Sub
[code]....