What I need to do is open a csv file which contains 4 fields and many rows, then I want to do different operations determined on the value in the fields.
for example :
My CSV will be in the following format.
ID,Name,Number,Status
Heres what I have so far
Private Sub OpenFileDialog1_FileOk(ByVal sender As System.Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles OpenFileDialog1.FileOk
[Code].....
I have a csv file. I need to open it, delete whole row on basis of a column value, Update few of the column values and save the file as .dat file. I am using VB.net 2010
View 1 RepliesI'm trying to insert a couple of fields into a csv config file and then update all other rows in the file at the same index by copying the previous 2 entries. I'm reading through each row and converting the row into a list(of String) because it seems to be the most flexible way. Ine initial insert works fine, but the code below doesn't. The actual insert code is:
[Code]...
pcIndex is the list index value from elsewhere in the code at the insertion of the 1st of a pair of values into one row. I need to update that index point and pcIndex +1 in all other rows. However it's not doing anything. Tried using lstSteps.Insert, InsertRange, etc. Am I using this right? Is there a better way? It seems to be over-writing the entry rather than inserting a new column and moving the others up, so it appears the list capacity value isn't updating - so I'm left with the initial row with 4 more entries than the others sticking out of the file.
Assuming this schema:
Table1 (Col1 int, Col2 str, Col3 str, ...)
Table2 (Col1 int, Col2 str, Col3 str, ...)
[Code]....
I need to select all records from Table2 where there are NO records in Table1 having matches of both Col2 & Col3. For instance, Table 2 records where Table1.Col2 <> Table2.Col2 AND Table1.Col3 <> Table2.Col3.
In the previous reply, you showed how to open a CSV in Excel. How does one determine the number of rows and columns that were imported?
View 1 RepliesI have read the file I/O tutorial and I learned alot. My problem is I need to send several different txt fields at one time and each into there own file. This was simple in vb6 using something like below, I have no idea how to do this with .net. Also on start up I will need to read this information back into text fields.
Code:
Private Sub Command1_Click()
'Save command1 name to file
Open App.Path & "subD.cab" For Output As #1
[code]....
I'm currently refactoring an old Visual Basic DLL (VB.Net), which stores all of its data in one module called Globaldefinitions as public fields. There are about 200 fields, referenced thousands of times all around the code:
Public Module Globaldefinitons
Public a As Short
...
Public zz10 As Double
[Code]...
I need to change the module into a class with non-shared fields. This means, each and every of these thousands of references needs to reference the instance of that class:
globalDefinitionsInstance.a = 5
How do I go about this efficiently?
Regular expressions operating on the source fall flat. Refactoring tools like Re-Sharper or CodeRush don't seem to offer this functionality. Visual Studio 2010 cannot do it automatically either.
Class Foo
ReadOnly name As String
Public Sub New(name As String, dependentUpon As Foo)
Me.name = name
[code]....
The output of New Bar() is:
Dependent created. Dependent upon nothing.
Independent created. Dependent upon nothing.
It seems fields are initialized in the same order as they appear in the source code, which (a) leads to an unexpected result, and (b) seems a little puzzling, given that one is normally not permitted to read from uninitialized variables in .NET, yet that seems to be working fine above.I would've expected VB.NET to be smart enough to initialize referenced fields first, and only then those that reference it; i.e. I'd have liked to see this output instead:
Independent created. Dependent upon nothing.
Dependent created. Dependent upon Independent.
how to get VB.NET to behave like that instead, without simply having to swap the declaration order of dependent and independent inside class Bar?
I'm trying to create a table in Word using data from a table in Access. There are four fields in the access table that I need. 3 fields are text which I can populate the Word without any issues. However the fourth field is a memo with >255 characters.I'm struggling to come up with the proper code to allow me to populate the Word field with the memo data that has more than 255 characters. The code I have so far is listed below. But when it hits the memo field, it crashes on the line I marked with **. I know it's not text, but I've tried many different field types, but nothing has worked so far.[code]...
View 1 RepliesMy intent is to have the code - on a button.click event - check the Username and Password fields and return an error depending on which is wrong. Or if both are wrong, return a different error message. I've set the username as parts and the password as parts (still learning how to use external authentication). [Code]
View 2 RepliesI have several sqldatasources for my gridview. All of the columns are autogenerated. However they all have some consistent fields and I'd like to make those fields template fields so I can modify the edit template for them such as adding a drop down menu. Is this possible?
View 1 RepliesWhy would a .sln solution file open and appear empty in Microsoft Visual Basic 2010 Express - i.e. no windows showing projects and code files etc.When I inspect the file in a text editor, it contains references to vbproj files (which are present) which indicate that it should not appear as empty.No error messages are reported when the file is opened.
View 2 RepliesI 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
[code]....
how to use open file dialogs to open a file to a text box?
View 6 RepliesI've noticed that when you click on a web page in Windows Explorer, or open a file in general, and the default application to open it is internet explorer, ie opens and opens the file. However, when I tried this on my Web Browser it opened, but ignored the file and went on its usual routine. How can I get my Web Browser to open and open the file that was clicked on in explorer?
View 1 RepliesI saved a file with the extension .doc. I use the RichText to write and save the text. I did not set any encoding type when I saved it. When I tried to open the file in the Richtextbox again, I got all the formatting characters in the RTF file. How do I correct this? How do I open and re-open a .doc file in the Rich Text box control without the formatting showing up in the box with the document contents?
View 4 Repliesim having a slight problem with my open file dialogue box, i need to be able to open the dialgue box, and click the file and open in my pdf reader, or at least load it to my other form ive created. what ive go so far:
[Code]....
I had this code working to import one column in a table as a starter point, but now that i'm trying to import all the columns in the table, i'm running into problems.
When I run the app, I get this Microsoft . NET Framework error:
Syntax error in INSERT INTO statement
I've tried just about every combination I can think of for the sql statement and still the same error message.
Imports System.IO
Imports System.Data.OleDb
Public Class Update2
[Code]....
I need to create a PDF drawing of our products with dimensions filled in, based on template files. After the user selects the proper template file for the desired product, a window should pop up that prompts the user for the necessary dimensions, such as width, length, etc. Then the program would fill in all the fields on the template form with the proper values. Some fields would just be filled with the exact values that the user enters in, but other fields may require a calculated value based on the entered values. ie. Overall width = nominal width + 6. So somehow I need to figure out how to make the template hold the equations. Can anyone offer me some guidance on how to make this work the way I described? Can iTextSharp determine if a PDF file has fields in it? Can it loop through all the fields & get the field names?
View 18 RepliesI have to read in certain fields from one XML file and compare that to another similar XML file to see if something changed. Is it an API, or a method?
View 8 Repliesi want to take a comma delimited text file and then select all unique records based on one of the fields in the text file. should i read the text file into a data table or just use a data reader?
View 7 RepliesI created a database in SQL server compact 3.5 I have a few fields in that.Later when I tried to delete one column and added so more, change was not saved. I did it all using server explorer of VB.Net. when I make the change, at that moment I can see the newly added columns but when I make dataset for this table
View 1 RepliesIn my combobox I have a list of sub folders (so all folders in my Jobs folder), each sub folder has a text file called summary.txt - would it be possible to display fields from the summary.txt in various textboxes if a folder is selected from the combobox? I use the following coding to display folder list in my combobox
[Code]...
I like to open a file. The open option should be shown in a separate window. My code works fine but the open window is not displaying to open a file. Here is the code:
private void OpenMyFile()
{
string path = GetPath() + ViewState["fileopen"];
[Code]....
When writing to an Access file with one of the fields indexed (NO dupes allowed), I am getting the following message in the Immediate Window "A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll", when I enter a dupe.
I have put in a TRY, CATCH to catch the error and display a msgbox with the error. Is this message in the IMMEDIATE WINDOW just a warning message (generated by access), or is there something wrong with my actual program? My program does not actually crash, it seems to be working great.
so i have a file that i need to read in vb.net. Each line is 32 chars long and each line consists of multiple fields. Meaning from char 1 to 9 it idicates ID then char 10 indicates an identifier,11-14 indicates a value field. I've looked at Readblock and it's not the tool for the job. Is there a way to break up each line into its respective fields other than just reading the whole line and breaking it up as a string?
View 3 RepliesI have a form that validates a users info, address, phone, etc. I want to have the form submit the data only if all of the fields are valid, but haven't had any luck. Right now the fields are able to validate but the form submits the data to the text file regardless of whether the fields are valid or invalid.
Here is my code
Imports System.Text.RegularExpressions
Imports System.IO
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
[Code] .....
How to create an if then statement to only submit the form when the data is valid. I was thinking I might have to set up a separate function but I'm not sure how to set it up really.
experience on how to create an engine using C# (VB.NET is okay too) that is generic enough to handle most cases of MS Word text fields I need to fill with data I'm getting from a database? In short, I'm about to embark on this little Office automation excursion and I'm hoping a little bit of feedback here.
View 2 RepliesI need to save a datatable to a binary file , in binary format , in order to make the process fast because the datatable may contain up ten millions rows. So , XML is not favorable because it makes the file large sized , and the process will be slow.
I managed to save the datatable to a binary file , and it works fine , but the problem when I try to add new rows to the existing binary file (using a datatable with the same schema , but different rows data) , it copies the schema of the datatable to the binary file, making it very large.
[Code]...
I need to import a big fixed width text data file into SQL server. Before importing, how to determine how many fields and records in the file?
View 11 Replies
