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.
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
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.
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.
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.
How 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..?
How 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?
I'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?
I 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..
In 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:
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]
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?
I 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'.
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(,)
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
I 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:
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: