I have a data table that has thousands of entries. The table has employee production information: YearMonth, Employee ID, Pages worked and Jobtypes (e,k,o and r). I need to calculate a sum of each jobtype and a sum of pages worked for each jobtype, for each individual employee. I am pulling this data from an Access database and so unfortunately I am unable to use LINQ.[code]...
View 4 Replies
I am currently attempting to write a program that will take a SQL query saved as a .sql or .txt and execute it against a specified database, and output the results to file. I have seen some sample code of executing a SQL query line by line,
and writing individual results to file.
The query that needs to be run is only reading information from multiple tables, but is pretty lengthy to do line by line. Is it possible to execute or read the whole query from the .sql file, or a text file, and run it against a specified database, and
have the results of the query output to file in vb.net?
I'm trying to loop through Labels that are named Label1 through Label16 and output integers from Array into the Text property of the labels. I think everything works except I can't figure out how to assign MyLabel the value of the current Label # in the loop. [code]
View 3 RepliesI am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(make the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
Private Sub DisplayRoleUser()
Dim conn As SqlConnection
Dim cmd As SqlCommand
[Code].....
I have this little application that runs a SQL query works great, now I want to have a Start Button run the and display results then System.Threading.Thread.Sleep(300 * 1000) for 5 min then run again and display results and loop till I buttonstop_click. unsure if the sleep is the best method.
[Code]...
I am converting an old script from ASP to ASP.NET and would like some advice. The original ASP script used Response.Write to output information about what happened during execution. I have rewritten the entire thing in ASP.NET but it is new to me as an old-school C programmer. The job requirements include using the VB flavor of ASP.NET, btw.
I originally put up a TextBox and edited the text property to dump my final report. Now they want different colors for different message importance and I find that the TextBox can only do one color for all lines. I fell back to the old standby R.W but I get a message that it's not declared and from looking around I see that it's an issue because I'm calling it from the code behind and that is 'out of scope' from the HTML elements of the page itself.
My question is what is the best way to output information to the web page with different lines being different colors from a page's code-behind?
How can I display only the most current results from a text file? I have a button the user can click that needs to display only the most current results from the text file.
View 9 RepliesI have been taking a class in Visual Basic and am currently working on my final project which I am having some trouble with. I am using Visual Basic 2010 express The project is to create an application that will store data in a text file, specifically, Last Name, First Name, Customer Number, Address, City, State, ZIP Code, Telephone Number, Account Balance, and Date of Last Payment. I have gotten everything done except the ability to search the file by Last Name or Customer Number. I have no idea how to go about this? I was thinking of ways to use indexof or Readline to be able to search the data, but I'm not familiar enough with the code to come up with a good solution. Below is a picture of how my form looks..As you can see, I'm currently using 2 separate forms to get the data from the user. Here is the code for Form1 which is the "Customer Accounts" form in the picture.
Imports System.IO
Public Class Form1
Public customerFile As StreamWriter ' Object variable
Public customerFile1 As StreamReader ' Object variable
Public strFile As String
[Code]...
There isn't enough room to post the code for my secondary form, but you get the idea. I would like to be able to enter a search term in the textbox on the bottom right of the form, and either search the data as its displayed in the listbox, or search the actual file? I was thinking that the results would be displayed in a messagebox?
I currently have a system that saves student data to a text file. I can search for individual students and have their information output to screen. How can I make my system output every student in the text file to screen?
View 3 RepliesIf I want the my output to be written to a text file do I just need to add:
Respone.clear() , Respone.ContentType = "text", Response.OutputStream.Write(bytes, 0, bytes.length) , Respone.flush()
[Code].....
I am writing my own script for a simple calculator that determines if a number is prime, and its prime factors.[code]The loopcount = compare - 2 means I want the loop to be 2 less than the square root of the answer so that when do a descending calculation (loopcount = loopcount - 1) it doesn't see if 1 or 0 is a factor of the answer. for the calculations after that, I want, every time n1 = n2 (a whole number factor of the answer), I want to report those results to a text file (n2 and n3) in this format "(n2, n3)" then go to the next line. and continue to execute the loop until the loopcount is zero. Currently, when I run the code, the application closes when I click the prime button (button that runs this code) and I don't know why. This is my first semester in school, and have never coded before, so I am a definite laymen with code, but I really really want to learn it (hence why for fun im just creating algorithms for different things).
View 2 RepliesI want to search a sql server database from VB.Net and output the results in a Listview. I don't want to use code that involes queries in it, but the queries are to be used in the data set designer, i.e the query builder.Here's what I got so far.
I created a query in the builder called SearchStudent
SELECT FirstName, Surname, Email, PredictedGrade, Notes
FROM tblStudent
WHERE (FirstName LIKE @FirstName) OR
(Surname LIKE @Surname)
Here's the code to search the database and fill the dataset
[Code]...
Normal
0
false
[Code]....
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.
[Code].....
I want to have an output like this in my text file
"30092010_1425","2010/10/30"
This is my code
oWrite.WriteLine("{0,10:ddMMyy_hhmm}{0,10:yyyy/MM/dd}", """" + Now())
Is 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 am having a perl script through which i achieve is split or output from text file for each single ID , the output text file will contain data of that ID and the anme of the file will be ID.txt so if i am having one main file containing 100 or 200 ID's and for each ID's may be 10000 or more lines i would like to have 100 or 200 files containing data for each single ID which i am able to achieve from perl but is it possible from vb.net
open(TH,"myfile.txt")|| die print "not open1";
open(THG,">error.txt")|| die print "not open2";
open(INFO,">myfileAll.txt")|| die print "not open3";
$gt='0';
$flag=0;
[Code]...
need an example of a console application that would allow you to input data to and retrieve data from a text file on disk.
View 2 RepliesI 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]....
I need some help sending the contents of a listbox to an output text file. Is there any code is visual basic that will allow me to do this.
View 13 RepliesI've this txt file (almost 60 MiB)
[Code]...
Every line starts with 56000 then the first key, the the second key and the rest of the line. I tried to use SORT, that's included with Windows. It does a pretty nice job, but i need to have my own function in case SORT is not available. The output should write 560001002001 at first.
I 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.
My application crashes when trying to save a word document as text. The error at SaveAs is "Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))" I am opening and manipulating a Word 2003 Document (using Word 2007) and then trying to save it as a text file.
[Code]...
I'm studying VB 2010 at uni and struggling with this assignment, I'm stressing now with one week to go before its time to hand it in and still not knowing how to do it (even though i've read the whole textbook!)
I have copied the instructions and the files I have been given.
1 List all of the data from Teams.txt in a Listbox. Include suitable headings.
2 List all of the data from Results.txt in the Listbox (use the same Listbox as in 1 above). Include suitable headings. Note that you cannot assume that the file contains only results for the first 3 weeks of the season. Your program should be able to process a results file with more or fewer results.
3 List all of the data from Results.txt in the Listbox. However, in this case the actual team names should be output (your program will need to get this data from Teams.txt. The data should be formatted so that it is aligned correctly. Include suitable headings.
I want to load a csv file (A comma delimited text file) into a datatable. I found the OdbcDataAdapter Class which looks perfect, but it says it is supported only in version 1.1 of the .NET Framework.
Is there a better way to import a csv file into a datatable? the first line has the column headers.
I am using Visual Studio 2008, using version 3.5 of the .NET framework
I'm using Vb .net 2008
I could use some advice/examples to acheive the following:
I have 1 form, 4 text boxes, (textbox1 ,2, 3, 4)
Textbox1 and Text box 3 and single line text boxes.. Textbox2 is multiline.. (a description field which can be as long or short as the user desires..)
Textbox 4 is a large multi-line textbox that will contain the output of Textbox1,2,3.
I need to find out how to output the contents typed into Textbox1,2 and 3 into Textbox4 while maintaining formatting..
For example, contents of Textbox1 should always be the first text displayed in textbox4, immediately under that should be the contents of Textbox2, and under that, Textbox3
I want to ensure that the text is displayed in that order even if the user enters information into Textbox3 first.. and still displayed in the proper order if Textbox2 has 1 line of text or 20 lines of text.
How could I do this? How can I make the text from one box always be inserted before or After text from another specific textbox when its displayed in the destination Textbox.. (think of Textbox4 like a "preview window" of sorts.. which will later be outputted to an actual txt file.
I'm trying to read a text file with multiple lines and then display it in a textbox. The problem is that my program only reads one line.
Imports System.IO
Imports Microsoft.VisualBasic.FileIO
Public Class Form1
[code]....
I am looking to create a VB 2008 Express programme which converts a data stream from a picoscope muscle sensor into a power output board which controls a mechanism.In simple terms when the Muscle sensor reaches a value of 0.8 V or higher I want the programme to send a text file to the power output control programme, and likewise when the sensor is below 0.2 V I want the power to be zero.
So 0.8 V > = send text file (0O=100%)
0.2 V < = send text file (0O=0%)
so when muscles being senced move the device turns on and off.I think I am successfully getting the data stream from the Picoscope which is plugged in the usb. I am using codes and examples that the programming guide for the device provided.here is a quick snap shot of the code (ps2000 is the driver used for the device)
ps2000_open_unit()
ps2000_set_channel(ps2000_handle, 0, 0, 0, 1)
ps2000_run_streaming(ps2000_handle, 250, 1000, 0)[code].....
how to get the data to be displayed or how to tell the programme to do something with the data.The device also came with an example of how it can record data to an excel sheet if anyone needs the code to gain a better understanding.
I've got some code to try and loop through LINQ results, but it doesn't seem to be working.
HERE'S THE CODE
Public Sub ProcessRequest(ByVal context As System.Web.HttpContext) Implements System.Web.IHttpHandler.ProcessRequest
''# the page contenttype is plain text'
[Code]....
I can't think of a better way to do this, what i have is this function:
vb.net
Function functionDealWithHiddenFields(ByVal HTML As String, ByVal numHiddenFields As Integer)
[Code].....
which usually contains: 4 so when i loop out the names, it loops the 4 results, 4 times, instead of just showing me the names 4 times so i can then store them
I have been having an issue with returning records from a SQLServer database where the date the record was created is between 2 user specified dates. When I populate the DataGridView with the results, they are incorrect and do not follow any recognisable pattern.
For example, if I specify the dates 05/05/2010 and 12/05/2010 I get the attached data in the DataGridView.
Code:
Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
'Clear the DataGridView
[Code].....
