I want to have some output going into a list box. I've got the information coming from various places- CD number, name of CD, artist, year of release, I've got labels above my list box with these values and I'd like them to line up.
[Code]...
I'm having trouble lining up data from a file with their respectable columns in a list box. I am using print zones to space out data evenly, but when i run the program the output is still messy. So I need lining up columns properly together. As of now, the first 2 list box items line up with each other perfectly, the data i am looping through to add to list box is not lining up correctly. I have changed my zones several times, but still no luck.
A chunk of my code (some) :
Dim fmtstr1 As String = "{0,-5} {1,20} {2,7} {3,7} {4,7} {5,7} {6,7} {7,8} {8,12}"
Dim fmtstr2 As String = "{0,-5} {1,20} {2,7} {3,7} {4,7} {5,7} {6,7} {7,8} {8,12}"
Dim fmtstr3 As String = "{0,-5} {1,10} {2,7} {3,7} {4,7} {5,7} {6,7} {7,8} {8,12}"
[CODE]...
got a little problem i just can't get working, i've got a list box that i'm adding numbers to but i want the numbers in the list box to be formated as a currency, i haven't got the number as a txt so can't do it the usual way, txtPay.text = formatCurrency etc i'm adding the items to the list box like this, LstPay.items.Add(dblNet)
View 8 RepliesWorking on a class project where one heading in a lisbox has to be indented while the subsequent information has to be right-justified. Not sure how this is done.Have tried writing code like:
'To list cost of parts in listbox
''Formatted so value is in U.S. currency
lstTotal.Items.Add("Parts" & ControlChars.Tab & ControlChars.Tab & ControlChars.Tab & parts.ToString("C"))
But using ControlChars.Tab over and over again doesn't seem very efficient. The spacing in the listbox looks uneven and the code looks more cumbersome--less easy to read.
I am pulling data from one SQL Server database, formating the data and then inserting it into another SQL Server Database. I am looking for a faster way to do this than the one I am currently using. The data pull is about 37,000 rows, so formating it and inserting it one row at a time is very time consuming. I was hoping I could format it into a datatable and insert the datatable into second database essentially inserting all rows at the same time as if they wre within the same databse, but I have not found a way to do this.
Essentially the code (I have simplified it) that I am using...
Dim
cn1 As New SqlClient.SqlConnection
Dim cn2 As New SqlClient.SqlConnection
Dim cmd1 As New SqlClient.SqlCommand
Dim cmd2 As New SqlClient.SqlCommand
[Code] .....
I have a listview which is populated from a Table. My code is as under:'Transfer Data from Table to ListView
Dim i As Integer
For i = 0 To ds.Tables(0).Rows.Count - 1
Dim drow As DataRow = ds.Tables(0).Rows(i)
Dim lvi As ListViewItem = New ListViewItem(drow("Description").ToString)
lvi.SubItems.Add(drow("Quantity").ToString)
[Code]...
How I can format data of Listview for Price and Amount like $40.00. because the listview shows data as 40 only instead of $40.00 as it is displayed in Table.
I am returning a date from my database table:
objSQLDataReader("date")
Which gives me:
31/05/2011 16:00:50
How do I change this to:
31 May 2011
I am working on a vb6 to vb.net migration project using vs 3.5. I have a datagridview.in a particular cell of this grid, user has to enter only numeric data. but after user enter data, itshould become concainated with a $ symbol (eg: if user enter 34, the cell value should become $34). And if he/she presses the hyphen ("-") in the key board, the data (ie. $34) should become -$34 and if again presses the hyphen button in key board, the data should become $34.
View 3 RepliesI have a label that is filled with a field from a binding source how can I format this data to appear as nn.n%
View 1 RepliesI have an XML file that looks like this.
[Code]...
i will need to get every food that is associated with almond, with american cheese, apple etc.. i will be reading the data with vb.net
I'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 have a DGV and a TextBox into my form. The TextBox displays the "DGV.rows.count" for example as "3" but i want to show me "00003". How can i format this textbox to display data like "000XX"?
View 3 RepliesI have an APP that reads data from MS Access tables. It all works fine except that the numbers in Access table are formatted like 800001 so when the user puts "2" in the access table, it changes to 800002 and so on. I want to read the data AS THEY APPEAR in VB.Net but it reads them without the special format. So I get 1 or 2 etc.
I know how to format the data within VB but I don't want to hard code that as the format in MS Access might change. Is there anyway I can read the data format in MS Access ?
I am using vb.net 2003. In my program I access an Access database file via Jet 4.0 and OleDbDataAdapter.I have several tables constructed with text boxes that are filled with data using OleDbDataAdapter.Fill. This all works fine. When Integer data is displayed in the boxes it is shifted to the left as text. How do I format these textboxes when I am filling them with the Fill statement? I would like them numbers to be shifted to the right and have commas placed every third didgit.
View 3 RepliesOK, this is crazy - How do I format text in a text box, (or god forbid) a grid, so that if it is a number it will align right, and if it is Currency it will have a $ sign. Do I have to define a Data Template? Every Template example online seems to deal with drawing borders around ListBox items, or showing photos instead of Strings,. I found 20 links, and not one talked about Alignment of #s or Currency.I'm new to WPF, and can only say that ease of use has gone to hell with WPF. Some things that were straight forward in Winforms are (IMHO) arcane in WPF (and I come from Delphi, which makes both VS Winforms and WPF seem like Rubik's Cubes).
View 13 RepliesI am working on a vb6 to vb.net migration project using vs 3.5. I have a datagridview.in a particular cell of this grid, user has to enter only numeric data. but after user enter data, itshould become concainated with a $ symbol (eg: if user enter 34, the cell value should become $34). And if he/she presses the hyphen ("-") in the key board, the data (ie. $34) should become -$34 and if again presses the hyphen button in key board, the data should become $34.
View 3 RepliesI'm updating a program that was written in an older version of VB (by someone else) and I can't figure out to how replicate this data entry line in my Form.
Each textbox can be changed and there is a nice scroll bar at the bottom to move left and right as you enter each datapoint.
I tried using multiple tabs within a Panel and setting the Appearance to FlatButtons, but the text area under each tab gets covered when you select another tab.
I am filling up a datagridview with data from an sql server - view. I have in the vie 3 columns and each column should have for each cell values like TRUE or FALSE (or NULL) I need a script to put a picture in datagridview for true, one for false and nothing for NULL This should be done in VB.NET
View 10 RepliesI have a code that binds the data from the database to textboxes. The problem is I want to make one of the textboxes Payment use a dollar sign.I tried formatting it as shown in the code below but only the first record gets formatted, the rest do not. When I click the next button, the dollar sign disappeared.
Here is a portion of the code:
bs = New BindingSource(ds, ds.Tables(0).TableName)
Me.txtPayment.DataBindings.Add("Text", bs, "Payment")
Me.txtPayment.Text = Format(CType(txtPayment.Text, Decimal), ("c"))
I have tried everything else I know, FormatCurrency but no luck.Payment is the name of the column in the database, the data type in SQL Server is Small Money.
In my app I present to the user an option to customize the name of the file that gets produced. The format string the program reads is something like "yyyyMMdd-%1-%2-%3-%4" which the user can customize to his liking. In this case the format of the date is yyyyMMdd and the %1 is the trip number like 1000P, %2 is the origin code like PTTTT, %3 is the destination code like PHYUD, and %4 is a secondary stop code like YYYY123. I'm having problems taking the actual data and formatting into the custom string. I believe its the date format that I'm getting stuck on.
So far I have
sOut = txtFormatPattern.Text
sOut = sOut.Replace("%1", "1000P")
sOut = sOut.Replace("%2", "PTTTT")
sOut = sOut.Replace("%3", "PHYUD")
sOut = sOut.Replace("%4", "YYYY123")
sOut = myDate.ToString(sOut) 'date is July 01, 2007
The output is "20070701-#1000P-PTTTTP12YUD (YYYY123)"
The problem obviously here is my last conversion. The string contains key characters that denote a part of the date specifically in PHYUD. So my question is how can I give my user the flexibility to format the output as they wish and then convert that properly?
I have 3 rich textboxes on my form and I need to extract the data from box 1 and box 2 and put it into box 3 without losing the formatting (as you know richtext boxes can support colour and picture formatting that i currently have in box 1 and 2). I tried the following but it strips all the formatting from box 1 and box 2.
View 2 RepliesUsing VB 2008, I have a form which includes a richtextbox which is bound to a database field. When i bind the datafield to the richtextbox, I get an unformatted display unlike the control in VB6. How can I bind the data from the database to the richtextbox so that it displays formatted?
View 1 RepliesI am trying to combine some data into a RTB from a Database into a single RTB with formatting. Let me try and explain... In my Database I have some Fields that Contain RichText (formatted) and Some that are only Text (nvarchar) and I need to combine these into one RTB with formatting.
[Code]...
I have a rich text box in one of my applications (WPF). Now I want to store the data of the rich text box along with its formatting (e.g. bold, colored etc.) into a database (SQL Server). Currently I am storing the whole XAML of the text box in a database field. however, I am not sure whether this is the right approach.
View 2 RepliesI have some VB .NET software that interfaces to a load of old (but sound) COM objects. The VB provides a GUI for the COM objects, part of which consists of setting various options on the COM objects - several of which relate to string formatting.I have a simple pair of VB .NET functions that convert basic %f, %d, %g formats to/from .NET equivalents using a large select case covering specific common strings, but they don't cover all formats.[code]Before I start diving in and making it more versatile with some parsing, does anyone know of a class (eg VB or C# .NET) that provides a decent ready-made implementation? Or perhaps some regexp wizadry could be used?
View 2 RepliesI have a number of text boxs that gather data and put it in a combined string in a rich text box that displays all of the collected data. Some of the text boxes require data pasted from other sources however when that data is then copied from the rich text box to the clipboard through a routine, it loses its formatting. home to maintain the original formating?
[Code]...
I have a window form with a label. On the form I have a dataset, bindingsoure, and tableadaptor (all created by the IDE in response to binding the text property of the label) To fill the datatable, the IDE created this: Me.ClientsTableAdapter.Fill(Me.MyDataSet.Clients) Works fine. The bound field is a phone number, stored in the db as a 10 digit numeric string I need to format this with the standard ()-, and I have a function that will do just that. How can I apply the formatting so the phone number appears in the label properly?
[Code]...
This is what I'm sure will be the first of many noob-ish questions from yours truly... I'm studying as a mature student for a Computing Degree (encompassing web design, hardware, programming and systems analysis). The programming seems to be my weak spot this year. I enjoyed C++ last year, doing basic console applications, but progamming visually with VB in Visual Studio 2008 I'm struggling!
[Code].....
This is what I want to do as seen in C#(loop against a list and fill another list from its data using Linq)
[Code]...
I have added a list box and now i need help to display the data about my employees in the list box. How am i supposed to do that, do we have to put in codes or need to use that small arrow near the list box.
View 15 Replies