I am using TextFieldParser to read a .txt file and create a DataTable I then filter the table and create 4 new tables I then bind those tables to BindingSources Then Bind ComboBoxs to the BindingSource Then bind TextBoxes to BindingSource I like the user to be able to Open a new file without having to close the program So upon opening a new file I have a sub routine that clears the tables the rows and the columns of each table as well the DataBindings to each control The problem is once I do the Text Binding as such
Then when I open a new file I get an error message conversion from string"""" to type double is not valid.If I never perform the binding I can open and reopen different files without a problem. So this is causing me to think that the problem is with the way I am clear something? But I am obviously not sureIs there something I am missing to clear everything properly in order to open and read and bind a new file?
I want to clear the history in an open file dialog, so that previous opened files won't be shown if a user clicks on the drop down arrow behind "File name". I have created an open file dialog and named it "ofd_openen".
Then I 've tried:
ofd_Openen.SafeFileNames = False and also ofd_Openen.FileNames.Clear()
I am trying to use the open file dialog box in VB 2005 to open up an existing txt, or rtf file from a directory into a rich text box. I am able to get the Open file dialog to appear and the directories, but when I try to open the file it doesnt import it into the text box. Here is the code I am using
I would like to open the excel file after create the excel file. The creating file function is done, but the system unable to open the excel file. My coding as below:
Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim misValue As Object = System.Reflection.Missing.Value
I'm getting this error 'column' argument cannot be null. Parameter name: column at the bold character instruction. Also I would like to know how to relate two tables with two key columns in each table
Dim connection As New OleDb.OleDbConnection(strTextoConn) Dim EnPartesdataSet As DataSet = New DataSet("Enpartes") Dim strsql As String
I am using the StreamWriter to create a log file for my application. However I do not see a method on how to clear the file (make the file blank again). Also before I clear the file I want to rename it so that I can have multiple log files, a new one produced everytime the application runs.
On my computer I've VB.net 2005. and also office 2007. I try to open an excel file like that
Imports Excel = Microsoft.Office.Interop.Excel Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click
would like to know if it is possible to have my application launch and open a file which will be called todays date. its just a simple text file and i am basing it on the streamreader style function.
The following code works to check if a file exist, but I need to also check if the file is open.How would I do that?
If System.IO.File.Exists(Application.StartupPath & "players.txt") = False Or System.IO.File.Exists(Application.StartupPath & "preferences.txt") = False Then bla bla bla End if
When the main program is doing it's routine, it is looking at, and using, data from the two files.So, when the user pauses the program by opening the control panel, one or both of the files may still be opened. When the control panel tries to open them, it causes an error.(I am guessing that to just tell it to close them will cause the same problem if they are already closed.)
At home I use Visual Studio 2008 Pro but a class of mine is trying to have us use Visual basic 2005 express edition. Since we need to submit source code files will there be a problem if I just submit the .vb file instead of the whole solution?
I'm looping through a csv file. For each line, I'm reading certain values, generating a filename, and writing the record to that file. Here is some logic
If <something that doesn't matter happens> Thendo somethingElseIf File.Exists(strOutFile & (strOutputFileName & "__" & strPrefixFileName & ".txt")) Then strFullFileName = strOutputFileName & "__" & strPrefixFileName & ".txt" '** Double Underscores after app name tsOutfile = New StreamWriter(strOutFile & strFullFileName) [Code] .....
Now, obviously with the above code, there's no reason for the elseif, since they both do the same thing. The problem, however, is if I need to create a new file and write to it, everything works fine. In fact, everything will work perfectly until I need to write to a file that I already created. If I go ahead and just try "tsOutfile = New StreamWriter(strOutFile & strFullFileName)" and point it to the already existing file, I get a permission error (says the file is already open). Is streamwriter keeping an open connection to all of these files that I create? Nothing else in the program is touching these files, only streamwriter.
Here's a quick example to illustrate what is happening Record 1 goes to file A Record 2 goes to file A Record 3 goes to file A Record 4 goes to file B Record 5 goes to file B Record 6 goes to file B Record 7 goes to file C Record 8 goes to file A (Error will occur here)
In my scheduling app I am exporting information to an excel file. When the first export runs it opens a new instance of an excel workbook. I have decided to save each schedule (AMRN, PMRN, AMTech, PMTech etc) to separate works sheets instead of appending the first worksheet. This way when the shedules need to be printed the whole workbook can be selected to print. When I try to open the existing workbook if it exist I get an error. Here is what I am trying to do.
vb.net Dim xlApp As excel.Application Dim xlWorkBook As excel.Workbook Dim xlWorkSheet As excel.Worksheet
I am trying to open an excel file and write to it as data becomes availableI can create an instance of excel and write to the selected worksheet once. But, I can't seem to write back to the existing file. I keep on getting a null reference error when I try to send new data to the file.The function I am using will run once, but when it returns to the main form, I lose the values of xlApp and xlWorksheet. It appears that going in to the function makes the original values null.
I need to make an E-Search engine for collage library , i can make it by using streamReader and streamWriter , but unfortunately i have to use Binary to make this project ... i've to many fields to put it on DAT file , and i've to use SPLIT to split lines and make arrays ..
what is the best way to do that ? how can i write an opened binary file on textbox and convert text to array ?
Suppose I have this Dim proc As Process proc = Process.Start("Notepad.exe", "C: est.txt") Now, if I want to use Notepad.exe to open another text file (ie. C:2ndTextFile.txt) without closing it, how am I going to do it?
I'm trying to write a program that will open a solidworks file in EDrawings and print it and so far the only way I can find to do that with an edrawings ActiveX Control displayed on my form.Does anyone know if it's possible to print drawings via EDrawings 2009 without the ActiveX Control having to be displayed on the form as that is drastically slowing down my program?
I have a open and file save dialog which I use to open and save file. There are also some labels in the application. During the time a file is open or saved, the file open /save dialog becomes blurred by the background labels. Is there any way to prevent this? The attached pic is given as an example to explain the dilemma.
We have developed one multi threaded application in vb.net and we are using Microsoft Access Jet engine 4.0 for database. And when i run the application it execute successfully but after some time it gave an error "Can not open any more table." We searched a lot and we found that we have to close all the connections and all the readers
I have a mainForm with a DataGridView control. This DataGridView is not bound to any datasource. All Rows and Columns were added. On another Form, I have a button. When I click it I want the DataGridView to clear all rows.
Does not work, in button click event: Form1.DatagridView1.rows.clear
Also does not work: A "Public Sub" on the first form, invoked by the button press - so the change is made within the same form.
bare with me here ok I posted on here a while back, like month to 2 months ago about creating an array of data (user inputed data). But was suggested to go the class route. After weeks of lengthly reading came up with a list collection class.
When I clear my form, I am trying to clear the Month Calendar of all selected dates. Using this code clears everything but the Selection Start Date, I would assume there would be a way to clear this, Refresh doesn't work, and I can't seem to find anything else.
Public Sub clearScheduleControls() Me.MonthCalendar1.RemoveAllBoldedDates() Me.MonthCalendar1.UpdateBoldedDates()
i have a few questions about seting up a form.when you creat a new for open the dataset drag and drop the tables to form it creates a top menu bar with pages plus sign and x and save.now when you run the app you need to press the plus sign to add data in the database..is there a way to make it that you dont need to press the plus sign?
I have an VB application that I developed in Visual Studio 2008. The back end is SQL. Application stores quite a bit of information and gets updated daily by users. It also connects to AD to get u/p, adds new accounts in AD and adds mailboxes. Users connect to it through Citrix. We noticed big spikes in memory usage. The executable itself is less than 5Mb; if I run it and it opens main form - memory usage jumps to about 19Mb, open a report - it jumps to 80 Mb. If I open the form that is linked to multiple tables - it jumps to 157 Mb. Once users start pulling new information in, update it and connect to AD or Exchange - it could jump to 250 Mb. Also noticed that if user with read only rights has application opened and idle - memory usage constantly changes with a pattern like 17Mb - 19 Mb - 15 Mb - 17 Mb and so on. This user wasn't even using computer at the time. In general - what could cause such jumps in memory usage? What is the best way to prevent it? On the server we have Windows Server 2003 SE
I have a ms access database with 10 tables, a combobox with the tables names and a datagridview.I want to get the datagridview to display the the specific table that is listed in my combobox during runtime.Basically i want to navigate to specific tables using combobox.