I want to separate each text into their own Column in VB.net.How do I achieve this?
Private Sub MenuItem3_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem3.Click
Dim folder As String = Environment.GetFolderPath(Environment.SpecialFolder.Personal)
Using sw As StreamWriter = File.AppendText("\My Expenses.txt")
[code]....
I want to separate each text into their own Column in VB.net.How do I achieve this?
Each entree is seperated with "|" . My Code:
Private Sub MenuItem3_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem3.Click Dim folder As String = Environment.GetFolderPath(Environment. SpecialFolder.Personal)Using sw As StreamWriter = File.AppendText("My Expenses.txt")[code].....
I want to separate each text into their own Column in VB.net. How do I achieve this?
Screenshot:
Each entry is separated with "|" .
My Code:
Private Sub MenuItem3_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem3.Click
Dim folder As String = Environment.GetFolderPath(Environment.SpecialFolder.Personal)
Using sw As StreamWriter = File.AppendText("My Expenses.txt")
sw.WriteLine(DateTimePicker.Text + Space(1) & "|" & Subject.Text + Space(4) & "|" & Category.Text + Space(5) & "|" & Amount.Text + Space(4) & "|" & Peyment.Text)
sw.Close()
End Using
End Sub
How would i get this to work on a listview to count the total in the header colums called Cost.
This is a code for DataGridView how do i get it to work in listview?.
code
Dim index As Integer = 1 'column index
Dim total As Single = 0.0F
[Code].....
i got a text file where each line is build like this:
00:00 - string
time - a string
simple right?
but now i want to seperate them so a timer checks the klock and load each line when the time is correct. i�ve got this
Dim objReader As New System.IO.StreamReader(FILE_NAME)
Dim s As String
For Each s In objReader.ReadToEnd
[Code]....
i know that the file extist. but the problem is i get error saying "length cant be less the 0" in the "dim s1 = s.substring(0,i) ( the code is in timer_tick)
Let's say I paste this text in textbox1
"firstname" : john, "lastname" : smith, "country" : usa, "firstname" : billy, "lastname" : brown, "country" : canada, "firstname" : richard, "lastname" : wong, "country" : usa
How could I split up each "firstname, lastname, and country" up? And like add them to 3 listboxes?
I'm pretty much self taught visual basic, using a lot of forums and all, andwas wondering if this is possible. I normally google too but i really have no idea what query I would search (the term). Atm, I'm having troubles making a find replace replaceall thing, so I really can't see myself making something like find '"firstname" : ' and get the text after that till the coma.
I am currently trying to separate my text into groups of 5.For example.Original text is ABCDEFGHIJKI am trying to make the output to something like this ABCDE FGHIJ K
View 4 RepliesI'm having trouble parsing some text. Here's an example of the text:
201 BBQ 0.000 9.000 0.099 0.891 9.000 0.000 0.000 0.000
705 W 1 PC 0.000 135.000 0.295 39.825 0.000 0.000 135.000 0.000
2106 ONL 9.99 41.141 3.000 4.110 12.330 3.000 0.000 0.000 29.970
Here's the latest incarnation of the code I've been trying:
objInfo = System.Text.RegularExpressions.Regex.Split(
newLine,"(d{3,5})|([0-9]+[.]+[0-9]+)|(w*)")
I'm having trouble because I'm avoiding getting many blank spaces in the array after splitting. I'm trying to avoid using the optional | character but I get no results when I set it up without it!
I've spent much of the evening reviewing regular expressions and I've downloaded the following programs:
RegEx Designer.NET
Antix RegEx Tester
Expresso
I'm having trouble because the description contains a decimal point SOMETIMES and sometimes it doesn't. The description sometimes contains a whole number sometimes it doesn't.My friend recommended I use awk to divide it into columns. The thing is...I teach a Community Education class with Visual Basic .Net and I need to improve my RegEx skills.
Hi, I'm working on a program that reads text entered into a textbox and creates a list of items by separating entries by commas. Everything is working fine, except, because I am using an array to store the items in the list, I have a limited number of entries. This is only a problem because, as it is written currently, each comma counts as an individual entry. Therefore, users can enter ",,," for example, and it would use up 3 places in the array.
I'm looking for a way to check to make sure there is text after the comma before adding an entry. I've attempted to use the .substring command to check the character after, which works until it gets to the last character. Because there is no character after that, it will give an error.
Here is my code for extra clarity:
Public Class frmMain
Dim intCounter As Integer 'Stores the # of commas in the string
Dim Messages(49) As MessageProperties
[code]...
SMS Sending application in vb.net using GSM Modem of Mobile & AT Command where mobile numbers are dynamically coming from sql server database.
View 1 RepliesI m trying to connect sql server to mobile device but dont know were to start
View 2 RepliesI would like to create a mobile application for Windows Mobile, how can this be done? I have Visual Basic Express edition.
View 4 Repliesam facing overwriting file in window mobile 6 professional.bellow are my code.
when the system start loading:
PrivateSubForm1_Load(ByVal sende System.Object, ByVal System.EventArgs)HandlesMyBase.Load
[code].....
I have a vb.net application that uses ShowDialog() to open child screens.
Long story short, I had issues with focusing the control if I opened IE on top of my program without minimizing the program. Once I reactivated my program and closed a child window, IE would show again instead of my program. I fixed this by setting the owner of my form.
Now I have another issue. After setting the owner, the parent (text) name of my form is now being shown at the top of the application when a child screen is open instead of the parent name. How can I fix this to show only the child's text form name when a child screen is open?
My code was working fine when I tried with 3 columns. Now, when I mode columns (13) it throws the error.
View 4 Repliesive had to start a new thread since intentions has changed since the original one, and things got confussing..I have a listview called listview1 listview1 has 4 colums already added, wich i added via properties[code]But what i need to do is to go through every item in listbox2, find the username and add it to the username colum (1)
View 11 RepliesI have 2 dgv's on a form that are both alike and even use the same datasource, just one column is different betwenn the two.I manually added the columns and set the datasource and bindings. When I make a change to the properties in one of my dgv's it keeps auto generating the columns I do not need.
View 2 RepliesThis is my array I need a bunch of code that will calculate the column total and get displayed once user put in word all
out put
Total domestic: $541,000
Total international: $830,000
[code].....
I'm using LINQ to SQL to select some columns from one table. I want to get rid of the duplicate result also.
Dim customer = (From cus In db.Customers Select cus.CustomerId, cus.CustomerName).Distinct
Result:
1 David
2 James
1 David
3 Smith
2 James
5 Joe
Wanted result:
1 David
2 James
3 Smith
5 Joe
Can anyone show me how to get the wanted result?
I found this but to no avail:[URL]..I have generic fields and labels that I put inside already predefined table layouts. Some fields need to span rows/columns and I can't figure out how to do it within code (aka not in the designer).
View 1 Replieswant to know if anyone knows how to seperate sentences in a dialog box? what I mean is this.I have a rather long warning attached to my closing dialog box that really needs to be there. The problem is that it appears all in one long string and I would like it to in a seperate string.Are you sure you want to exit without saving changes? If you close this window, you will close the program and lose all unsaved data!this is all coming out in one long sentence..what I would like it to look like is this:Are you sure you want to exit without saving changes?If you exit this Window the program will close any unsaved data will be lost!
View 3 Repliesim trying to get a name entry from an input box to show up in two separate places on my project, ie first and last name, but i either get nothing or the same text for both labels.[code]
View 6 RepliesI'm trying to wrap my head around creating dll, and since I've been using a variation of the code below, i was wondering if someone could comment on if it would be possible to separate the code from the form and create a dll with it, I've been using this in my application successfully and since I'm familiar with it, I thought it would be a good project to learn on.
This is the code for the form docViewerForm.vb
HTML
Imports System.Data.SqlClient
Imports System.Threading
Imports System.IO
[CODE]................
I am looking for a starting point Is this formula that would use Excel.Range.Formula =SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10, 0))>0,1)) The goal is to insert this fourmula in as colums from A4 to AY4. The array will be variable.
View 8 RepliesI have a datagridview that has 4 colums(ID,Name,Amount) connecting to the database in vb.net and im supposed to do is that whenever the user enter records with the same Name the column Name and the column Id remains its data while the Amount value is either adding or subtracting depending the update situation. Is this possible to do this in datagridview?
View 5 RepliesWhat I am trying to figure out is a simple dice rolling program (I'm assuming it's simple anyway) that lets the user specify how many dice they want to roll and then after they click the roll button it separates the dice by what was rolled so they can see how many 1's was rolled, or how many 2's were rolled, so on and so forth for 6 sided dice.
Say the user wants to roll 6 dice, when the user clicks the roll button the results are 4,3,3,5,1,6. Obviously meaning they rolled two 4's two 3's one 5 and one 6. Now from that result I want to have separate labels that show how many of each number was rolled, so it would look something like this on the form (Except it would be horizontal instead of vertical, but it doesn't work on the forums)
1's: 1
2's: 0
3's: 2
4's: 1
5's: 1
6's: 1
That's just a basic example, of course if the user added more dice there would possibly be up to say 7 4's and 10 5's or whatever. There isn't really a limit to the results you can get.Now I found some code to do let the user specify how many dice to roll and have it roll that amount of dice, but I don't know how to separate the results like I want them above. Right now it just displays the results all in one line on a label.Here is the code that I am using
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim diceCount As Integer = TextBox1.Text
If diceCount = 0 Then MessageBox.Show("Please insert number of dice needed")[code]....
It works perfectly but how would I go about separating the results like how I was explaining? I'm sorta guessing I would use case statements or something of the sort but I'm not sure how to check the results of dices to be able to separate it.
I have a solution in VS 2010: a WCF Service Library project ("NotifyService") and two Windows Forms projects, one for a server ("NotifyServer")and one for a client ("NotifyClient"). My goal is to have a duplex WCF service that will notify any number of connected clients when the server pushes out a notification. The clients do not need to communicate to the server except to subscribe and unsubscribe from the server's updates. However I seem to be running into problems nailing down the InstanceContext.
Here's the code for the WCF service:
<ServiceContract(
CallbackContract:=GetType(INotifyCallback),
SessionMode:=SessionMode.Required)>
[Code].....
Since I'm setting everything up through code, there are no app.config files. The problem I'm having is that my Subscribe method is never called. When debugging, I get an error after stepping through that line (not an exception) that says "Unable to automatically step into the server. The debugger failed to stop in the server process." When I go back to my server form and click the button designed to raise an event on the callback clients, it steps into the NotifyService class but the _callbacks list is empty, meaning the Subscribe method either never ran, or it never ran on that instance.
I have fought with this for almost a week. This is nearly an identical copy, at least on the service-side, to what was described here, and I've compiled that and it works.
I have an Array of Column Titles and Column tpyes that i want to add to my DataGridView but dont
know how to 'Cast the string' to the required Column type?
Example (doesnt work but might give you an idea what i an after:[code...]
Adding different types of Colums to a DataGridView when the type starts as a string
View 1 RepliesI have a datagridview and I'd like to write it to a file in the same type of row and column format it's currently in.My first idea for doing this is to get the maximum number of characters in each column so i know how wide each column has to be formatted. Then loop through each row and write out each row while using the max characters in each column and the current cells content length to do the math to get the formatted columns to line up. Like the example below, except i'd have a lot more in it.
writer.WriteLine("{0,0}{1," & lb(2).Length + 50 - lb(1).Length & "}", lb(1), lb(2))
This takes label(1) and label(2) and writes them so no mater the length of either (to an extent) then will always be right hand aligned in two columns.