This question has been most likely been asked a number of times, but really hitting a brick wall regarding this.
The issue is that at the moment, I have to create a database using text files on VB.
So far I have managed to get the code working to add new customer and browse added records, but stuck on how to output/input back and fore to a text file, to store information, and after this input/output the text file to a DB ( Not worried about this at the moment)
Public Class Customer Dim CmrColl As New Collection 'Create the new collection. Think of this as an array of objects. Dim itemCount As Integer = 0 'A variable to help us scroll through the objects later.
so here is my scenario. I have two input files... both are plain text files. File1 has customer name, customer address and invoice number. File2 has customer name, customer address, invoice number AND a keyline. File1 will only contain some of the records in File2, and it will change daily. I need to be able to compare File1 against File2 and output one file (preferably an Excel spreadsheet) with the info from File1 and the keyline from File2, that matches the duplicated info. I know the basics to get it to work, but I'm not sure what would be the easiest way of doing this... File2 can have up to 100,000 records per day. I'd only need to run it once a day though.
I am creating a report and outputting the results to an excel file. Here is how it is suppose to work. I have a table called EMPID that has a list of employee id's. I loop through this table and for each EMPID, I run several queries. I would like to append the data that is returned to the spreadsheet so that the results for all EMPID's would be added to the spreadsheet. Right now, the way I have coded it, for each EMPID it overwrites the fields in the spreadsheet instead of adding/appending them to it.
Here is some code: If EmpidDS.Tables("EMPID_Table").Rows.Count <> 0 Then For Each dr As System.Data.DataRow In EmpidDS.Tables("EMPID_Table").Rows 'Set the variable EMPID to the current row EMPID EMPID = dr.Item("EMPID") 'Check that table is not empty [Code] .....
I work in an engineering design house and programming is not my actual profession. And I am relatively new to VB .net (previous i had worked in vb 6)
I am working on an in house application. I am coding a simple application in vb .net. This applications takes a few inputs from user and calculates a result. Now I want to implement a simple functionality that user should be able to save the input and results just like most of the windows programs can in a new file format. And user should be able to open the save file when desired.
I created a simple calculator. I just graduated with my Bachelors in Software engineerin in March of 2009. I am tryig to get a better understanding of VB.Net. I created a simple practice calculator and would like to know what code needs to be added in the code to clear the output when the user changes the input without adding a clear button as I know how to clear the input and output using a clear button, y working code is pasted below.
[code] Public Class Calculator 'Form click event handler Private Sub Add_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
In my programming class, we have been set a task in which a user inputs 8 numbers, and those 8 numbers will be split into groups of 4 (therefore having 4 lots of two digit numbers). These 2 digit numbers will then translate to a specific time, day, place and city.
For example, this table below is what we have been given for city. (there are separate tables for time, day, place with different 2 digit numbers)
(Excuse the formatting) City Code London 11 Paris 37
For example, if a use inputs 11995467 I would want that to output London (being the number 11), [a PLACE = 99], [a DAY = 54], [a TIME= 67]
Bearing in mind I am a newbie, and my knowledge of VB is minimal. How would I go about doing this. It's suggested we use MOD and integer division, but I don't see how it can work.
I'm trying to do a calculation where-in the output is different depending on what the input is. [code] I have these repeated using >=50 >=60 etc. but when I go to run the program I get this: [code] basically I need to know how to create a cut off point for the grading system. <= doesnt seem to work.
Applications in the .NET Framework can use the System.Console class to read characters from and write characters to the console. Data from the console is read from the standard input stream,data to the console is written to the standard output stream, and error data to the console iswritten to the standard error output stream. These streams are automatically associated withthe console when the application starts and are presented as the In, Out, and Error properties, respectively.I am working with redirects and I am solving small problems one at a time. So far so good, but I lost track of the big picture here. Can someone please clarify something for me.
I have a stored procedure with two input and one output parameters. I need to execute the stored procedure from VB 2008 code passing it two parameters and returning the output parameter. How might I go about doing this? I don't have how to do this. Newbie here.
We learned How to assemble an input/output control board that would connect to your serial port. We were able to use out statements (back in the old gwbasic) to send output signals to the parallel port to turn on/off different outputs. The board had connections where you could connect lights, relays, etc, and had connections where you could attach switches and sensors.
I have been looking for something simple that I can manipulate in my programs. I already have an ActiveHome X10 interface which includes an activex for receiving and sending x10 signals (home automation, turning lights on/off, etc.). I want something that I can straight out connect relays to, and sensors as well. I don't want something that connects to the serial port since that is already being used up, the parallel port would work fine, or even better usb.
I have 2 VB programs that I would like to communicate with each other, but I want them to be separate EXEs. Anyway, the easiest way I figured would be for me to call the one program from the other and then return a result. How do I get this result into another program?
Here is how I want it to work:
1. Start System Information Program (easy)
2. Call a video test program, and send a couple arguments (see below)
3. Receive arguments from the video test (I do not know how to do this, I do not know how to send from the video test or receive from the system information)
Every time I try and redirect input and output of command prompt I have a problem. The debugger itself crashes! Something must really be wrong. What is a good way to launch CMD and send commands to it, receive output.
I am using vb2008.net express, I test vs2005term it work, can any tell me what is the input variable and output variable of this terminal? how to catch the input and output variable to a textbox1 for sending and a textbox2 for receiving when I press send button? is that possible? I attach the example of my question this is a a good source, but it is not relate to my problem: [url]...
I've to make a program that reads an arithmetical sentence from a textbox, e.g 12.3*34+4*5-3 and then on another textbox identify and display what is the content of the first textbox, for example taking the last ex:
This program should only read this operators like (+,-,*,/).I'm have in mind 2 ways of doing it, one with regex and the other taking the first sentence, put it on an array, then trim it, and somehow get the values of the array and identify if it is a number or a decimal number and if it's an operator and then display it.
The difficult part or the part that i can't conceptualize is how to implement it with regex (it should be easier with a regex format than storing it on a array).I write a bit of code, I used an array to store and then to print the numbers and I used the split function to separate the math operator, but I dunno how to print the operators and the tags.
vb Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Sentencia As String = TextBox1.Text Dim i As Integer Dim arryTextBox() As String TextBox2.Clear() arryTextBox = Sentencia.Split("+", "-", "*", "/") For i = 0 To UBound(arryTextBox) Dim Array As String = arryTextBox(i)
Btw, I also have the code to validate the input on the textbox ::wink::
I've been trolling for a long time now and have decided to register as I finally have some time to start jumping into VB. The last time I coded VB, the current version was VB 4. I've been out of programming for a good while now and considered myself a beginner (tutorial example coder haha).
My question is: Where is a good place to start learning VB.NET?
I know it's an often asked and answered question - but let me give you a bit more information so more specialized replies might be given.
I'm in INFOSEC/COMSEC and would like to (eventually) develop a program that contains a DB of information that is read by the application and saves input information into a DB (encrypted) as well. The program will be a 800-53 C&A control assessment program; used for tracking system compliance for federal information systems. I would like to be able to develop such a tool to make my life easier at work instead of using Excel spreadsheets to track everything.
I would like to learn: - Input / Output methods and validation (for secure coding) - Read/Write DB Encryption (RSA or other 128-bit) for user input information - Ability to generate PDF reports from the primary keys and data sets from the above DB
My goal is to create a program that allows a user to install the program, setup a 'master' account that a serial/key has been generated for - that master account is then allowed to create new projects (progress saved in DB). A project asks the user certain questions pertaining to information systems and takes the input and saves it into the DB (encrypted). When the assessment is completed, I would like the program to be able to generate a PDF report from the DB (from a layout template I created).
When started my app connects to Access 07 DB and checks if Table has more than 1000 records.If so,it exports them to a CSV file and deletes them from the table.After some time,Table will again reach 1000+ record,and I will again need to export them.But,I do not want to create a new CSV file,but rather append to existing one.
I have text file to read. If i find a line "T001" then i must add specific text beside that line. With my code now it write the specific text at the end of the file not beside the line "T001" This is my code so far
Dim filename As String = strFileName Dim tfLines() As String = System.IO.File.ReadAllLines(filename) Dim objwriter As StreamWriter objwriter = File.AppendText(filename)
I have a file that contain data structure as below:
L,13206,11,02,06,000,3981.100 19,22,25,26,19 END
so how can i extract 1 and -18970.811,53728.643 and export it into a new output file with new structured as below: C 1 -18970.811 53728.643 For your information, the value for -18970.811,53728.643 will be placed after string K,1,P or K,2,P or any number between K and P...
One more thing is i want to append that new formatted data into old ready file that already contain old data... new formatted data will be append to the top of the old file..
This question is a little more in depth than the typical append and save. I'm needing to append multiple controls text to 1 file. Basically what I have is:User inputs name in TextBox1 User inputs Service Type from selected list in ComboBox1 User checks of any or all CheckedListBox fields that apply. Now, all together, there are actually between 4 to 6 different checkedlistboxes.What I am wanting to do is when the user clicks the Submit button (Button1), at the bottom, it will write a text file of TextBox1.Text,omboBox1.SelectedItem.ToString, and all the checkedlistbox items.Now there is a small thing I may have to start another question on. For every checked item in a checked list box, I would like to writ
my app will be parsing an array of data and generating text strings (of around 80 chars each), which I then want to append to a text file. What is the best (fastest) way to do the file appends? file size will be up to 40K lines.
I am providing 3-4 dropdowns on page load by If (IsPostBack <> True) Then ' Populate dropdown textfields from the database End If Say "ddlFiles" is one of the dropdowns containing filenames as "file1", "file2" and so on. Now when the user selects say "file2", I want to download file2.
My objective is to, instead of entering in the data manually into the text boxes, I want to read in a textfile. The Calculate button will contain the code to read in the file and assign it to the appropriate textboxes. Save the separate file in the \bin\Debug folder.
The text file just needs to have 3 integers on 3 separate lines.The code I posted works without and errors, but.I am having some trouble integrating the Stream Reader.
I want to append a text file with items from a listbox. I tried to search for a code to do that, but couldn't find anything(most likely I don't know what I am looking for). But I wrote this code and got it to work, but after looking at the code, it looks sloppy and I'm sure could have bugs I didn't catch....my question is, is there a better code than the one I made, or will my code work fine. I am eager to write code correctly, not just get the code to work.
Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click Dim save As New SaveFileDialog save.ShowDialog() Dim saveFile As String = save.FileName
How would i read a set of names out of a file and then append them to a list box?I am not guaranteed a pair will be on the same line, and not guaranteed that a line would contain a maximum of one pair(i.e., it might have three pairs or it might have one and a half pairs - a first name, last name, and another first name whose matching last name would be on the next line). A line may also be blank.All of this needs to be in a visual basic format.
I am trying to append a new line to a text file. Sometimes it posts to a new line (like I want it to) and sometimes it appends to the current line, consequently screwing up my read. I even put VbNewLine in the code.
Here is the snippet: Dim outputline2 As String outputline2 = equip & "," & value Dim myfile2 = File.AppendText("equiped.txt") myfile2.WriteLine(outputline2, vbNewLine) myfile2.Close() [URL]
Below is the code which I am using to append data to a text file. Dim FILE_NAME As String = "C:cebsample.txt" Dim objWriter As New System.IO.StreamWriter(FILE_NAME, True) Dim record As String Dim amount As Integer Dim amt As Decimal [Code] .... Now I would like to save that updated file with another name.