Formatting XML Data - Item Lists
Dec 29, 2009I 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
ADVERTISEMENT
Drop Downbox Only Lists One Item?
Nov 20, 2010I'm using Visual Studio for the first time and VB. I have programed for awhile, but mostly new to windows related softwares. I have an access database connected to my test application and I am trying to display a drop down box with a listing of the item names in my table and the value that is sent off to my database is the actual item id. I can figure out the database part in terms of adding and editing, but I haven't been able to figure out how to display the full list. If I click the next button the list that is generated it displays the next item, but I would rather just list all items in the drop down box and remove that toolbar all together.
View 1 RepliesWriting A Program Which Takes One Item From Each Of Two Lists?
Jun 11, 2011I'm writing a program which takes one item from each of two lists and combines the items in one of three ways selected by the user. The results of the process are provided in either a summary form or a detailed form, again selected by the user. As it's currently developing, this program will contain six subroutines covering each of the six combinations of user selections, which are stored in three Booleans. Selection of the appropriate subroutine is done through traditional "if then else" coding.If I understand OO and Visual Basic (Express 2008) correctly, I could make the subroutines into different variations of one method, which when invoked would automagically use the correct coding depending upon the settings of the Booleans / properties. Assuming this is correct, the problem is that I have no idea how to actually set up code like this.
View 4 RepliesLists() And Data Structures
Sep 1, 2009Can a list class in vb.net contain Data Structures ?
View 1 RepliesSorting 2 Lists Based On Only One Of The Lists?
Apr 1, 2011I have two lists. One list is a list of names, the other list is a list of how many times each name is found in the first list noted in the database
so...
Nick
John
Jim
Jack
is the firs tlist
10
13
13
2
is the second list. Nick had 10, john 13 and so on.I want to sort the second list from large to small, but have the index for the first list still linked to the correct amount of calls.i do it this way so I can
for x = 0 to num_of_names
string = lst_name(x) & "-" & lst_count(x)
next x
VS 2008 Bound - Source Data Of Drop Down Lists Be Separate Queries / Datatables?
Jun 2, 2009I've got a couple of drop down lists for languages. I bind them to a language list that comes from a query. Then the fields are also bound to the row in the DB they relate to. I have several panels with the language drop down - each "tied" to a different table in my DB. When I call up different records on the same panel the drop downs immediately "set to the position" of that rows language in the list. But when I call up another panel - tied to another database table - I see that language in the drop down.
[Code]...
Inheritance And Variety Of Data Structures Including Queues, Lists, Arrays, Or Stacks In A Windows Forms Application
Jun 27, 2012I'd like to give a homework assignment to a person learning VB.NET. I'd like it to use basic inheritance and a variety of data structures including queues, lists, arrays, or stacks in a windows forms application. I was thinking of a pizza-ordering application. This would allow them to utilize some basic inheritance and practice using .NET UI elements.
View 2 RepliesFormatting Data And Inserting Into Another SQL DB
Apr 8, 2009I 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] .....
Formatting Data In A List Box
Jul 15, 2011I 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]...
Formatting Of Data In Listview?
Aug 9, 2009I 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.
Asp.net - Formatting Data Returned Via Datareader?
Jun 6, 2011I 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
Datagridview Cell Data Formatting?
May 23, 2012I 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 RepliesFormatting Data From A Binding Souce?
Sep 16, 2009I 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 RepliesSql - Data Reader Formatting Output?
Jun 15, 2010I'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]....
Reciept Printing - Form Which Consist - Item Code , Item Name , Item Price , Quantity Of Item
May 25, 2012Regarding my college project. i'm working on a sales system . i have a form which consist of all the following information( item code , item name , item price , quantity of item ) which is display using a data grid . data input by user using text box and all this information will be stored in a database(sales database) i'm using ms access 2007. the grand total will be displayed in a text box . and amount paid will be input in a text box too , my major problem now is how to i create a reciept that will have all this information of the purcase. i have a reciept button . what the next step ? i dont have any idea how to get the reciept done.
Imports System.Data.OleDb
Public Class Form5
Dim con As New OleDbConnection
[CODE].......................
2008 - Textbox Formatting To Display Data
Jan 14, 2009I 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 RepliesDB/Reporting :: Data Formatting Lost In Translation?
Jun 19, 2009I 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 ?
Formatting Data In TextBox When Using OleDbDataAdapter.Fill?
May 24, 2010I 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 RepliesInterface And Graphics :: WPF Data Formatting Headache?
Mar 14, 2011OK, 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 RepliesVS 2008 Datagridview Cell Data Formatting?
May 24, 2012I 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 RepliesVS 2010 A Data Entry Formatting Challenge
Dec 12, 2011I'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.
Know If An Array Of Lists Contains Similar Items (similar Lists)?
May 20, 2010I know how to check whether an item exists in a list using (MyList.Contains), But I do not know how to check the whole list. For example (use one button and one richtextbox):
[Code]...
Formatting - Filling Up A Datagridview With Data From An Sql Server - View
Nov 2, 2011I 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 RepliesFormatting Currency (U.S) Not Working With Data From Sql Server Database?
Mar 25, 2012I 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.
Formatting Data Into Custom String Including Dates
Sep 13, 2010In 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?
Rich Textbox - Extract The Data From Box 1 And Box 2 And Put It Into Box 3 Without Losing The Formatting
Apr 23, 2010I 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 RepliesRichTextBox - Formatting Data From Access Database Field
Oct 29, 2010Using 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 RepliesRTF & TEXT - Combine Some Data Into A RTB From A Database Into A Single RTB With Formatting
Aug 10, 2011I 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]...
Saving Richtextbox Data Inside A Database Along With The Formatting?
Jun 21, 2010I 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 RepliesConverting C++ Printf Formatting To / From String Formatting
Sep 30, 2010I 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 Replies