Is there an easy way in Visual Basic to record values to a CSV (comma separated value) file? I would also consider recording values to an xls or xlsx if it is easier. Anyone have any experience with this? Basically, during a loop, I'd like to take the values of 3 different variables and put them on one line of a csv, then make a new line in the csv and repeat with the next segment of the loop.
View 3 RepliesI want to output some of the data in my VB program to a .PRN file (no commas). I'd like to have the program create a header with the data, parameter info, etc... How does one begin something like this?
View 5 RepliesIs there a way to write in the code to dynamically update the COM port if the USB/Serial adapter is plugged into a different port?
2nd: How do I have visual basic output the LAT/LONG coords that I have have show up in a form box to a text file every time it updates from the serial GPS?
I downloaded some sample code which includes a database query within the markup code. It makes a query to the database and displays the results of the web form and I would like to divert the output to a text file and I am not sure how to do this?Can this be done from here or would it just be easier to code it in the source and make a new connection to the database?
Sample code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringIP %>"
DeleteCommand="DELETE FROM [ip-to-country] WHERE [ID] = ?" InsertCommand="INSERT INTO [ip-to-country] ([ID], [BeginingIP], [EndingIP], [TwoCountryCode], [ThreeCountryCode], [CountryName]) VALUES (?, ?, ?, ?, ?, ?)"
[code]....
Is it possible to output a graph drawn in vb.net and plotted with data to a pdf file format? or any microsoft office format?
View 3 RepliesI 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 am trying to get the data from the Text Box Output box and Date and Time box of a form to be stored in an Access data base.
View 5 RepliesI'm using the following function to generate a list of users connected to a selected database. How would I change this to a single line for multiple identical results?For example: "sa (3) - MYCOMPUTER" rather than listing "sa - MYCOMPUTER" three times?
Function ConnectedUsers(ByVal SelectedDatabase As String, ByVal SelectedInstance As String)
Dim myCommand As SqlCommand
Dim dr As SqlDataReader
[code]....
I am pulling different information from the same file at two different times: 1) The first time, I pull information that is inserted into a combobox. I need to use the combobox as a filter for when I pull the information a second time. 2) I pull different information from the same file, and it is outputted into a datagridview table. I already have a filter in place when the information is pulled the second time, and I was wondering if I could add to that filter or if I have to make another filter? The filter (or filters) will be used to filter the information in the datagridview before it is outputted in a chart.
This is the code for binding the combobox to the information
Dim cnRange As String = "provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source='" & strFileName & "';" & _
"Extended Properties=""Excel 8.0; IMEX=1; HDR=No;"""
[code].....
i am trying to find examples of getting data back from a stored procedure that has no parameters sent to it nor has any returned output parameter. Though it does display data.How can i get that from my code im using below?
Dim myCommandSQL As New SqlCommand
Dim myReaderSQL As SqlDataReader = Nothing
Dim intX As Integer = 0[code]....
The @return_value i just put there to see what would happen but i got nothing returned.
This isnt the first time i have posted about a graph, last time i was posting about which way i should do it, now that i have created the graph (by drawing individual lines) i was wondering what the easiest way to actually get data from a SQL database and output it as a line on a graph. here is a picture of what the graph looks like (bottom of the page) [URL]
[Code]...
i'm working on an e-voting system for my thesis... but i'm having problem on how to output the data in all the rows in the database in a check box. so it means that the number of checkbox is equals to the row of the table. i manage to output only one data from the first row but i don't know how can i output all the succeeding rows.
this is my code so far
Private Sub LoadCandidates()
SqlString = "SELECT * FROM candidate"
'Function for searching by candidate ID number
[Code].....
So I got this program to generate me some data and I want to show that data to a label.
If I don't do a display I can generate about 20,000 data per second, but if I do, I get about ~9,000 data per second.
PS. Since the generating logic in is a thread, I have a function that does the displaying to the label.
Searching for data in Access then showing output with VB 2008
View 6 RepliesThis is my current output in a textfile that is created during the program. (Its different from my previous post)
!CH1 = S11,CH2 = S12,
-66.979,-60.518,
-61.403,-60.546,
[code]...
What I am trying to do: There are three powershell scripts with different time delays as shown below.I am trying to run them asynchronously in .NET and I followed this article to implement Asyncrhonous programming. Where I am stuck:The I am not able to retrieve output after the events are invoked.The scripts are being called but then the program ends and it shows "Press any key to continue" in console windows.I don't what I am missing here.
Info: JobRequest is a class that I use to pass around information keep track of jobs.
Sub Main()
OurAsyncFunctionCalling("psDelayScript2.ps1", "-arg1 4 -arg2 5", 1)
OurAsyncFunctionCalling("psDelayScript1.ps1", "-arg1 2 -arg2 3", 2)[code]......
1.Ihave to produce an application that enables the user to enter an integer rate of pay and an integer nr. of hours. On clicking a button the application should display rhe pay due. Amend the application:rate of pay to be entered as a real number;Employees are taxed at emergency rate of 40%. Amend to display GrossPay and NetPay.
2.Ensure that the operator cannot accidentally enter data in output areas!!!
The application is to be amended so thet the employees are paid overtime at time and a half for working more than 8 hours in any one session and all data enter by user should be checked to ensure that it is in a valid format and that the values are acceptable. [code]
Ok I can successfully connect to my Access database but I am still learning on how to output that data. Here is the run down.I am designing a page where the user inputs the customer ID and then gets a list of incidents for that customer. Then I would like the user to be able to add a survey about the incident.Problem I am running into is the ability to display this data. I have tried various method. Eventually I want to be able to display the data into a listbox and have them select it and take the survey but I am not near that far yet. Here is what I have on the connection and my attempt which doesn't work to output the data:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sql As String = "SELECT [Title], [Description] FROM [Incidents] WHERE ([CustomerID] =
[code].....
I have two checkedlistboxes (chkLB_Sentinel and chkLB_Scourge) binded to my database.I have a listbox (LBPlayers) with 10 players in it (0 To 9) which I fill using the items checked in the checkedlistboxes and the display member is Nickname.Whenever I want a msgbox to popup containing the first player which is 0, I'm recieving the msgbox "System.Data.DataRowView"
I have this simple code:
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As New SqlClient.SqlConnection
con.ConnectionString = My.Settings.MyConnectionString
[code]....
The problem is if I write the msgbox without .toString I get an error "cannot convert to prompt" so I'm obliged to put .toString Why am I getting this kind of error even if I have the DisplayMember binded and how can I fix it ?
I am new to programming and I am developing a simple application to convert a text which is made using SSML to a audio file,for a personal task. When I use the function
SetOutputToWaveFile or SetOutputWToWaveStream, the file can be created and played using media player, but there is an error in the file. When I use the function setOutputToAudioStream, The audio file can be created, But it can't be played with any media player.[code]...
I'm making a GUI for a console application. I want it to save the file to /data/file.zip to anywhere the .exe is. Process.Start(Form2.TextBox1.Text, "get /folder/file.zip C:patht.zip") So if my application is in C:appmyapp.exe the output file would be in C:appdatafile.zip etc.
View 4 Repliesi have this program i need to make, where it runs a bat file. i got that far, so when i click the button it opens the bat. but 3 problems i encountered i have been trying to resolve for a few days now, the problem is that i need to get the output of the .bat and display it in a textbox, i got that, but it only displays the first and least line... then i need to run the .bat in the background. so you don't see the window.then i also need to be able to hit a second button to close it. the bat is a constant update, lets just say it reads a number then 5 seconds later adds 1 to that number and displays it again. and does this over and over till you close it. that would be a simple description of this
Process p = new Process();
p.StartInfo.UseShellExecute = false;
p.StartInfo.RedirectStandardOutput = true;
p.StartInfo.FileName = "C:\Users/jwoow/Desktop/Server/run.bat";
p.Start();
[Code]...
What i have realized is that when you use My.settings, a XML File is put with your EXE when your project is Published.
What you can also do is just Open that File and Change the Variable "Register" From "False" to "True"
How can i do what Most Registration files do, and make the XML File go away and Create a Unwritable file, where the values cannot be changed.
I'm coding a program & the program runs a .bat file with this content :
@ECHO OFF
SET BINDIR=%~dp0
CD /D "%BINDIR%"
[code].....
I am attempting to output data from a list box with the possibility of multiple choices selected(frmPrint) and output the data froma another list box frmMain. The code posted does nothing. I can get this form to output everuthing but multiple items selected by the user. I am a student and I have been working on this problem for a long time with no luck.
Private Sub btnAddBooks_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddBooks.Click
Dim intCount As Integer = 0 ' Counter
Dim mainForm As New frmMain ' Form instance
Dim strInput As String ' Input
[code]....
So, I run a select statement in SQL and then it has something like " where clientName = 'John Doe' " I can generate a datagrid or dataset off the SQL statement, but it will only be good fro one client...... I would like to be able to populate a dataset/grid using the select satement and then having something like a combo box of names the USER can choose. Then the user selects the name and the datagrid is populated with that clients info or w/e........
[Code]....
Background: I'm writing a application that will allow users to enters items on a form using textboxes, radio buttons and checkboxes. I then take each input item and write it to it's own arraylist. After the user is all done entering data the information in the arraylists will write out to a single .txt file.
View 6 RepliesI am executing pdf2text in vb6 but not getting output file my code is
Call Shell("pdf2text -f example.pdf abn.txt")
it does not show any error but not giving any output
I'm having VB write a batch file to send to a remote system via psexec.exe later on in the script. When it goes to execute the batch file, it fails due to these junk characters showing up in the beginning of the first line. I'm creating the file like so:My.Computer.FileSystem.WriteAllText("C:Program FilesBobBob's Programadd_user.bat", "net localgroup """ & Group & """ /add DOMAIN" & UserID, True) Where Group is the local group I'm adding to and UserID is the domain login for the user.
View 7 RepliesI have a data source that creates a continuous stream of 24-bit samples. I can collect a set of samples and build a .WAV file, and play the file through my speakers. What I want to do is eliminate the middleman, and send the stream of samples directly to the sound card. The data source can run for hours or days. I want to hear it in real time, rather than collect it all and listen to it after the fact. The idea is that I can tune the process that creates the data better if I can hear what it's doing.
View 9 Replies