I am trying to figure out a way of combining the below Dim statements into one line and maybe also combining Return dblResult into there. currently it is three lines and I have been told that it is possible but kind of lost of how to do it
[Code]...
I have been working on a web based report from an existing client/server apps mssql database. I have a working query, that pulls this information together from many tables, and can provide the query and a result set if necessary.
The results currently are similar to this.
ID | Name1 | Date1 | Veh | PO | Stops
_________________________________________
1 | Bob 1 | 12/1 | Car | 1234 | 4
2 | Sam | 12/3 | Car2 | 2245 | 3
2 | Joe | 12/4 | Van1 | 5568 | 2
[Code]....
how to count the lines in textbox1.text (with multiplelines). I don't need to count each character. I only need to count each line from top to bottom in textbox1.text (multiplelines) and I will use Label1 to display the numbers.
example:
1-pauljaones
2-tommyperrry
3-marktoms
4-Jonessmith
5-paulwhite
Obviously this is 5 lines and that's what I need to count.
How do I combine multiple files into the one file with a new extension. No need to be compressed. So I avoid Zip or similar solutions. (Actually don't want to add third party solutions into my application.)
View 13 RepliesI have three arraylists (datasets and subsets) that I need to combine into one arrraylist so I can databind it to a repeater control and then present data to the user. As far as I know, you can only bind the repeater with one datasource (please correct me if this is wrong) that's why I'm combining these arraylists.Each arraylist has an ID from the database which I can use as a datakey to keep the data aligned. How do I combine these lists?
View 4 RepliesI am used to creating a data set with data from one table, for instance:
[Code].....
Now I am needing to add a second table. For instance, my second table "EQUIPMENT" has a field called "DESCRIPTION" that I would like to add to my dataset. The "WORKORDER" table has a field called "EQNUM" which is what the "EQUIPMENT" table uses as the primary key. how to combine these into one dataset?
I am using Microsoft Access database. Since Access Database Table cannot have more than 255 columns, I am using vertical database partition technique where I have splitted informations into 5 different tables. Each table has 100 columns, and first column is primary key. Now I need to read data from these five tables so that I can export it into Excel file.
[Code]...
I am trying to understand transformation matrices (not just their implementation in VB, but in general) and I've put about 3 full days into this so far. I believe I have the data in my matrices correct. Applying any single matrix to an array of points does a correct transformation.I am wondering if I understand how to combine multiple matrices into a single one.I understand you just have to multiply them together.I took this to mean you just have to multiply each element with its corresponding element in the second to make a third matrix?[code]
View 5 Replieswriting a script to allow the user form to browse to a directory and combine multiple files to one text file. In DOS it would be copy *.* to Text.txt.
I am using Visual Basic 2008 express...
I can use the OpenFileDialog to browse and open a single file but I am unable to use the multiselect option to open multiple files.
all files are parsed in the same place.
I have attached what I have managed so far which included converting the opened file to .txt
My project contains a DataGridView with a SQL Database Table called Shows. This is a list of TV Shows and I want to apply several filters to it. So I have several different columns to apply the filter to.
1. Completed (bit)
2. Hide (bit)
3. Seen (bit)
4. Genre (nvarchar)
Currently I am using RadioButtons to switch between the queries, but I want to be able to have several filters applied at the same time with CheckBoxes.
[Code]...
I've programmed a vb.net application. This is a matching applcation generates 3 lisboxes. I have written these to a csv files. [code]...
View 3 RepliesHow can I combine multiple *.txt files in a specific directory into one txt file in another directory using VB.NET? (And to delete blank lines at the end of the new file)
I know how to do it in vbscript:
Const ForReading = 1
Const ForWriting = 2
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objOutputFile = objFSO.CreateTextFile("C:logsimportoutput.txt")
[Code] .....
I've made a rudimentary program that combines multiple files into one single file. Currently if I combine two .csv files together the output comes out correctly for what I need, which is a coma delimited file. When I try to combine two .csv files into a .xls file it doesn't format correctly (I get all the data separated by commas, but thrown into one column in the .xls file). For this reason I believe I need to add a delimiter.I'll post my code below.
[Code]...
I want to combine multiple lists of items into a single list, retaining the overall order requirements. i.e.:
1: A C E
2: D E
3: B A D
result: B A C D E
above, starting with list 1, we have ACE, we then know that D must come before E, and from list 3, we know that B must come before A, and D must come after B and A.If there are conflicting orderings, the first ordering should be used. i.e.
1: A C E
2: B D E
3: F D B
result: A C F B D E 3 conflicts with 2 (B D vs D B), therefore requirements for 2 will be used.
If ordering requirements mean an item must come before or after another, it doesn't matter if it comes immediately before or after, or at the start or end of the list, as long as overall ordering is maintained.
This is being developed using VB.Net, so a LINQy solution (or any .Net solution) would be nice - otherwise pointers for an approach would be good.
Edit: Edited to make example 2 make sense (a last minute change had made it invalid)
I want to draw string in multiple lines and and I want to know how many lines given string will take. I am using following method.
[Code]...
I would like to know how I can have an enumeration that has multiple values and can be passed to a function.
Example:
Public
Enum
ActionEnum
NoAction = 0
[code]....
I have multiple datasets that I would like to combine into one. There is a common ID field that can be associated to each row. Calling Merge on the dataset will add additional rows to the dataset, but I would like to combine the additional columns. There are too many fields to do this in one query and therefore would make it unmanageable. Each individual query would be able to handle ordering to ensure the data is placed in the correct row.
For Example lets say I have two queries resulting in two datasets:
SELECT ID, colA, colB
SELECT colC, colD
The resulting dataset would look like
ID colA colB colC colD
1 a b c d
2 e f g h
So I built myself a simple program to work out the kinks of drawing in my programs. I have a button that I press that when the textbox.text reads 1 it then draws a line of a specific height, color and position, the problem is when I click that button again it will crash informing me that...
"Specified Visual is already a child of another Visual or the root of a CompositionTarget."
[code..]
I know where the problem lies, its with the Canvas1.children.add(line), cause its telling me the line variable is already been used or in use on the canvas, I'm just unsure of how to turn that into a solution that will allow me to click the button a hundred times or more without being forced to MANUALLY make a hundred or more individual variables to store the line.
I have a string STR="CYHZ 262338Z 2700/2724 27012G22KT P6SM BKN040 TEMPO 2700/2710 5SM -SHSN BKN015 BECMG 2702/2704 28015G25KT FM271000 28018G28KT P6SM BKN040 BECMG 2722/2724 27012KT RMK NXT FCST BY 270300Z"
I want to put the new line characher before these words in the string(TEMPO, BECMG, FM, RMK) so that the output string look like this
[Code]...
So i am working on something for school. And we have to make a program that has 2 buttons, 2 text boxes used for input and a label used for output. One button is New Customer wich displays this in the output label (named totalLabel)
Public Class Form1
Private Sub newButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles newButton.Click
[Code].....
I'm creating a button on my project that when clicked it will enter the information in the comment "" area and store it into the clipboard to be pasted.
My issue is whenever I try to put the multiple lines in the comment field I get a syntax issue.[code]....
Is there any SHORCUT for multi lines commenting in vb.net .. Altouhgh i know there is an option in toolbar for multilines comments but i want to know a keyboard shorcut for it...
View 5 RepliesI have tried multiple variations of the following code, but I still get the same result. I am trying to have the last line "Issue Description: ...." to appear on a new line. I have tried vbCrLf, vbCr, and & Environment.NewLine & _ None of which work.
Just a note: The other emails are properly formatted. Also, if I add put 2 vbCr (s) at the end of the 'Issue Title' line then it looks normal.This one in particular seems to be a thorn in my side.
The result:
The code:
Dim mail As New MailMessage()
Dim strbody As String
strbody = Nothing
[code]....
Tab control that has multiple lines of text
View 2 Repliesi've got my basic AutoTyper ready (well and one with autoupdating etc in it) but it's only a singular line. [Code] What I want to do it to type multiple lines, I know I'll have to enable multiline on the TextBox. I want it to type one line per time interval using 1 timer. I don't know how but I know it would have to count the lines but from then on I'm stuck. I will need to make it type line 1, then on the next loop line 2 and go on until it's reached the amount of lines from the count then repeat from line 1. [Code]
View 6 RepliesHow would I make it so that if someone presses a button, the richtextbox will have more then 1 line of text
RichTextBox1.Text = "Something like this, but 2+ lines"
I know how to write one line to a text file and read one line from a .txt file. How do you write multiple lines to one .txt file?
View 1 RepliesI want to draw three straight lines on a form. if the following code is correct:
Private Sub Form1_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles Me.Paint
Dim Line1 As System.Drawing.Graphics
[CODE]........
Can I use only one variable (Line1) to draw three straight lines?
I'm new to Visual basic (which will be obvious from my question) and am writing program that does various calculations, then displays the results in a list box. the results, however, are all concatenated, end don't each appear on a new line. I tried adding a carriage return/line feed at the end buit the compiler rejected it.
I can't find any examples of creating a list box, and adding multiple entries (one for each time a loop is performed), nor of how to use columns to make the resulting display cosmetically pleasing.
In previous versions of VB, you could click on a label to gain the focus, and then type multiple of lines of text. In VB 2008, clicking on the control does not open up the control for editing. You can use the text property, but can only enter a continuous string of characters. How do you insert blank lines between paragraphs?
View 3 Replies