What type of collection should I use to store data from a table (in a book) that has multi-dimensional Keys to get a single value result?
What is the best way to store and retrieve these values in a program?
I have this code to set array values and store them in a variable,
Dim productName As String()
Dim productPrice As String()
Dim productCategory As String()
[CODE]...
How do you get the variable values to output like this?
<input type="text" value="Chang Beverages $19.00" id="Chang" /><br />
<input type="text" value="Ipoh Coffee Beverages $46.00" id="Ipoh Coffee" /><br />
<input type="text" value="Gula Malacca Condiments $19.45" id="Gula Malacca" /><br />
Basically, our users enter values onto a spreadsheet and I have been asked make the spreadsheet output to a CSV file preferably each one completed appears as a single line in the CSV.Upon examining the spreadsheet, I cannot figure out the best way of acheiving this, or if it is easily acheivable in the first place.I have attached an example of the spreadsheet data, to give it some context the spreadsheet records times that carers have visited a client, which can happen many times a day over many days per week, there is also a yes/no for each day on the sleepin.
View 5 RepliesIn my VB.net code i have:
cmd.CommandText = "SELECT * FROM [strfg].[dbo].[Myfunc] (@MyParam)"
Dim myparam As New SqlParameter("@MyParam", a)
cmd.Parameters.Add(myparam)
The function (runnig on SQL server) returns a table with four columns, one row.How do I call this function from Visual Basic? cmd.ExecuteScalar() is obviously not correct. In c++ I use a recordset. What is the equivalent in vb? Does anyone have a short example?
I am designing a test launch tool that I want the user to be able to select a product type from a list and then choose a station type from another list. Depending on what they choose will determine what is run (what is passed out).
The data will look like the following :
Product Station Test to load Config file to use
10-9890-1 mfgtest1 Progamming.xml config5.conf
10-9890-1 mfgtest2 Configuration.xml config92.conf
[Code].....
I want to execute an SQL statement and put the result in to a data table.
Sub getvehicletypes()
Dim dt As New DataTable
Dim intLine As Integer = 0
[Code].....
Once Ive got it in a dataset I need to work out how to search the dataset for a code and return the corresponding description and vice versa
I need to pupulate a Grid, but i like to do like Microsoft SQL Server Management Studio, when you make a Select to a table with bounch of rows, it start show the result but in the botton still retriving data.So you can start looking the data, not like you get the data and after you get the last row you can asing to the Grid.
View 6 RepliesIve got a jagged multi dimensional array, how to work out the length of a single row of the array so;
My array is ;
CODE:
And i wish how to find the length of this;
CODE:
I'm writing an app to print a list of beers that are currently on tap at the restaurant where I work part-time. We have 29 taps and dozens of different beers. I have 2 tables in a database (one with the "master list" of all the beers and an "on tap" one with one entry per tap). Each database entry includes fields for name, brewer, location, style and ABV. So far I've made a GUI with 29 combo boxes (one for each tap) and 2 buttons (one that opens a dialog box to modify the "master list" and one to print the list). The idea was to make it as simple as possible since the people who use it aren't great with computers and are often in a hurry.
Each combo box drops down the whole master list of beers and I'd like for the selected beer to be written to the corresponding index in the "on tap" table. My idea is to then extract the data from the "on tap" table and print it. I haven't done any coding yet, really, just drag-and-drop.It's frustrating since I know how I'd do the back end in C or C++, but not in VB. The reverse is true for the GUI.
I have created 4 table and data set. I would like to print information from 3 table on a single report. I already created a rdl. report form.
View 2 RepliesI have a data table.
And I only want to have a single row in this table. I then write the changes to an xml file. The user will edit the row in this table save the values in the settings.properties. And then when ready write the changes to the config file.
However, I am thinking is there a better way. As I have to keep removing the row that was currently added. Then create a new one.
' Add the data to the datatable and write the changes to the config.xml file
Private Sub btnWriteConfig_Click(ByVal sender As Object, ByVal e As EventArgs)
' Only create a single row. All changes must be made to this row only.
[Code].....
How to store string data to mysql table.[code]...
View 1 RepliesHow to store text data to mysql table. My string data is : dim strPath as string strpath="D:My projectFirstMonoHighr.rst" I can do it. but stored string data is with this"". D:My project FirstMono Highr.rst How to solve this problem..?
View 2 RepliesHow do I create a multi dimensional array in visual basic. For example I have a soccer team with players. Each player has an id, first name, last name, address, phone number. How would I represent this using a multi dimensional array?
View 1 RepliesI need some advice to accomplish this, i have a datagridview with this data:
Column1 Column2
item1 3
item2 1
item1 2
item1 5
item2 3
item3 1
item1 3
I need an array with distinct values of column1 and the sum of the values in the second dimension of the array: ar(item1,13), ar(item2,4),ar(item3,1).
I don't know how many items i will have, so i don't know the correct dimension of the array...
Is it possable to remove a row from a multi-dimensional array?
View 5 RepliesI'm writing an application in VB.NET and face the following issue. I'm trying to create an interface that will allow the user to select their availability given a range of times and the days of the week. I want to create checkbox controls in a tabular form with two indices that I can use to refer to a certain time range and a day of the week.[code]I followed the article found here which creates and exposes a control array,however it is not multi-dimensional. Does anyone know of a similar way to dynamically generate controls and store them in a multi-dimensional array in VB.NET?
View 2 RepliesI was looking for a function I need in internet but I didn't find it... I need to sort a multidimensional array(matrix).. for example
Original matrix
1,b,3
2,c,5
3,a,1
I need a function, lets call it magic() xD with 2 arguments, the matrix and which col to sort first...so..the result of magic(originalmatrix,1) could be..
3,a,1
1,b,3
2,c,5
How can I make it ?
is it possible to sort Multi-dimensional Arrays? If the answer is yes could someone help me giving some hints on how to start?
View 6 RepliesIn my football sim I am trying to save all the info from a game. There are two defined dimensions to this array. The first is the number of weeks(17 always) and then the number of games per week (Number of teams /2). The plays themselves are unknown in quantity so I decided to use List of to store them. With this type of multi-dimensional array that is also a List of I am having trouble with the Get and Set properties. I have a member variable declared as:
[Code]...
I have a string, which can easily be splitted by seperators into an array.The output has to be splitted again an move into a multi-dimensional array (2nd index)[code]
View 2 Replieshow to execute this SQL Statement
Scenario:
Given Tables T_Data, T_AllDesc, T_System1, T_System2
Given Fields:
T_Data= f_id, f_Desc, f_CreationDate, f_CreationTime, f_System1, f_System2
[Code].....
What would be the best way to load and save a multi-dimensional array (of bytes). I've looked through streamreader tutorials but it always seems to instructions on how to save strings. I also know there's a very easy way to save a one-dimensional array, but it doesn't work on multi-dimensional ones. What should I be reading up on?
View 5 RepliesI am attempting something along the line of below mentioned code. Though it works in single dimension array. How to make it work with 2-d array?
Dim arrayord(,) As String = {ds.Tables(0).Rows(3).ItemArray, ds.Tables(0).Rows(23).ItemArray}
But it throws the following error.Error 8 Value of type '1-dimensional array of 1-dimensional array of Object' cannot be converted to '2-dimensional array of String' because '1-dimensional array of Object' is not derived from 'String'.
ok so im having issues with this
Select Case a(b, 3)
Case "d"
c = 0
[Code]....
OK so a(b, 3) has either the letter d,e or f in it but when I try and read the multi dimensional array I don't think it picks anything up
I am having issues assinging values to a multi-dimensional array.
I am trying to build a 2 col, unlimited row array and populate with data from a data reader.
Dim tblArry(,) As String = {}
If reader.HasRows Then
While reader.Read()
[Code].....
When I use a Jagged Array I can get this to work. The Reader portion is workig just fine, but the coding is just not clean for this problem.
I have a very simple 2D array, it holds a list of song titles, their genre, and their runtime. frmMain loads the array from a text file and allows me to manipulate it and boil it down to a desired (implicitly sized) playlist. i want to THEN pass that playlist array to a second form, frmPlaylist The problem i'm running into....When frmPLaylist calls the Property from frmMain I receive an error that VB cannot convert the string value to a two dimensional array. Simplified...frmPlaylist is all locked and ready to receive a 2D array, but frmMain seems to only be sending a single string variable. on frmMain
Public ReadOnly Property PlaylistOut() As String
Get
Return mstrTimedPlaylist(,)
[code].....
I think I need a two dimensional byte array I currently have something like this:
Dim MbyteData(196608) As Byte
' Open the file that is to be loaded into a byte array
Dim oFile As System.IO.FileInfo
oFile = New System.IO.FileInfo(sFilePath)
[code]....
I now need to load several files at once (say four) so I need four arrays of 196608 bytes and I want to reference them by a number - 0 to 3, assuming the array is zero based. If I use Dim MbyteData(196608, 3) as byte or Dim MbyteData(3, 196608) as byte the syntax seems to be correct but I hit an error ("Number of indices is less than the number of dimensions of the indexed array") when I try to add the extra dimension to the stream read with something like oFileStream.Read(MbyteData(index), 0, MiByteCount).
I am new here and really excited to see the huge resources on this forum for vb.net. I have just started my learning of vb8 and need to create some basic applications for my personal use.I need to develop an application that can extract data from a html table and store that data into Access database. I have learned to create web browser on Visual Studio 2008. Below is the link from which I need to extract data and store into a database
View 3 RepliesI have a multi-dimensional array storeHand(20,6) which stores 6 ints. The int at point 0 in each array represents a rank. So the array ends up looking like this:
(7, 0, 0, 3, 5, 7)
(6, 2, 3, 0, 6, 5)
(5, 0, 0, 0, 13, 4)
(8, 0, 0, 0, 0, 3)
(2, 0, 0, 0, 0, 1)
I want to re-order the array so that the higher the integer value at position 0 is, the higher it's position will be in the sortedHand(20,6) array. So as above, I'd want sortedHand(20, 6) to look like this at the end:
[Code]...