In my website I have a textbox that allow user to enter a group of numbers like this:
(118,38,137,15,156,14,157,36,152,49,142,57)
Now i want your help to show me the way to store these numbers in array to be like this:
[118 38 137 15 156 14 157 36 152 49 142 57]
I have a stored procedure in DBML and I try to pass the result to "sqlQryArray" as an array(1 dimensional array). But the bottom code causes error like below message. What else should be done?
Error 1 Value of type '1-dimensional array of aaaDatabase.stp_GetSomethingResult' cannot be converted to '1-dimensional array of String' because 'aaaDatabase.stp_GetSomethingResult' is not derived from 'String'.
The return result from stored procedure is a just list of first names of students(only one column)
Dim sqlQry = aaaLINQ.stp_GetSomething(bbb,ccc,ddd)
Dim sqlQryArray As String() = sqlQry.ToArray()
For example, I have string variable (MyString) as below.MyString = "First word || second order || third example || fourth item || fifth stuff"
There are separator "||" at MyString variable. I want MyString variable is spited based on separator "||"and stored it into new array variable.
Could you advise me the most efficient code to do this job in VB?
I seem to have a huge issue right now trying to grab different pieces of a string to place them in a different order in a list. Unfortunately i can't just find the placeholders for the strings and extract the data that way so i was using indexOf to find commas in the string provided. the problem i'm having is that i can assign the first comma and extract 0 - "," but i'm stuck on how to progress the indexof so it will move through the string submitting everything between the comma's.
Public Class Form1
Private Sub btnAccept_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAccept.Click
[Code].....
In a resource string, not one that you declare in the code, but rather in the resources itself, how do I store multiple pieces of data in it?
View 7 RepliesI've come up with the following and it's partly working.
Public serial1, serial2, serial3, serial4, serial5 As SerialPort
Public serialports() As Object = New Object() {serial1, serial2, serial3, serial4, serial5}
dComPort = "COM4"[code]....
The above code works fine! But im having trouble trying to now retreive whats stored in the array.In the above example, an entry will be stored in serialports(4), all other array elements will be blank.If I do this it works.
MsgBox(serialports(4).PortName) ' this retuns the value COM4
But I'd like to loop though all array elements and print out ALL the PortNames, The below code doesnt work, I get an error Object variable or With block variable not set.
For i = 0 To serialports.Length - 1
MsgBox(serialports(i).portname)
Next
I've been using the following sub in my control that I'm creating to let me modify the pixels in a bitmap faster:
Protected Sub LockForMemory()
idata = ime.LockBits(New Rectangle(0, 0, ime.Width, ime.Height), ImageLockMode.WriteOnly, ime.PixelFormat)
ipoint = idata.Scan0[code]....
This doesn't seem to work right, however.
This application should ask the user for a percentage amount by which each price should be increased then increase each price by that amount and then display the increased amounts. I can't seem to get it to calculate the amounts. Everything else seems fine. Any suggestions, ideas or recommendations? [Code]
View 1 RepliesI got a value which is store in the array and i need to compare it. Which
if my user = 1,2,3,4,5,6 then ignore
if my user = 2,3,4,5,6 then i need to add in a ,1 which become 2,3,4,5,6,1
Here is my coding
user = dr("user_access")
dr.Close()
Dim splitX As String() = user.Split(","c)
For Each item As String In splitX
[Code] .....
Is there other way to compare the array or there is another better way to check?
Im new to database programming and was wondering if you can save a select statement to an array:I tried this but obviously wont work, does anyone have any ideas?
Code:
Public Sub store_select_star_to_array()
Dim myCommand
[code]......
I have put together an array for data from two text boxes to be stored in. This works fine at the moment. I am now looking to build some form of array that will have some stored data in it already, so that someone can select the information they require from a listbox.
View 7 RepliesBasically, the user can type in a name and a job description into two different txt boxes and then click add. It then adds the name to the listbox and stores it in a string list (Public strList As New List(Of String)) it also stores the job description in a string list as well (Public strListDescription As New List(Of String))Then when you select an item in the list box it knows what data to bring up in the txt boxes using an array with these lists:
Code:
Private Sub lstMyCourt_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstMyCourt.SelectedIndexChanged
Dim i As Integer
[code].....
I am selecting a distinct user from IT_Cases_List and stored it in an arraystaff(). From this array, I will then call a Stored Procedure to count the no of cases attended by this user,(arraystaff(i)) and loop it until arraystaff.length-1
but the problem is that the count does not tally.
Sub getStaff(ByVal month As String)
If Not con.State = ConnectionState.Closed Then
con.Open()
[Code]....
ok, i've called only once getcases but i'm still having the same problem.
this is what i get when i run the program:
if i get Count(*) from the database, the total no of cases i should be getting is 132, whereas the total of cases i get from the program is 157 (7+7+20+20+49+49+5)
if i run the query from sql, this is what i should be getting
i notice that the Count number gets duplicated (7,7,20,20,49,49,5) instead of (7,20,49,5,10,27,13)
Write a function that will take one integer input parameter, create a sequence of numbers stored in an array from 0 to that number, and the numbers are a summation. For example, given 7
View 17 RepliesI have some data, stored in a byte array, compressed with LZSS compression. I've crawled the net for the last 2 days trying to find some code to decompress this data without success. Has anyone come across a suitable routine that can help?
View 2 RepliesHow can i pass and access the array variable in Stored Procedures
View 3 RepliesI have a data entry form, a listview form and a couple of classes. Data is entered in the form, and it is stored in an array. This is then displayed in a listview. I can insert and delete just fine, but I cannot figure out how to modify. This is what needs to happen: With a row selected in the listview, modify is clicked in the menu strip.
Whatever information is in the selected row, it needs to be transferred to the data entry form where changes to it may be made. I have attached what I have so far, and a sample data file is provided in the root directory. I think I need to temporarily store the selected item, put it into the data entry form, delete it, and when submit is clicked have it re-inserted.
Attached File(s)
In my desktop, I have folder containing some word document files. I want the filenames of the documents in that folder. So, I used:
Dim strFiles() As String = IO.Directory.GetFiles("X:Documents and SettingsXXXDesktopvvvvv", "*.doc")
All filenames are stored in that array. But it would also include the temp document that Word generates. I am somewhat confused on how to remove this from array. I only need full filenames of the actual documents, which excludes the temp document.
my code is :
[Code]...
The error is Value of type '1-dimensional array of string' cannot be converted to 'String'.
I's there a way that I can access the properties of all controls stored into my array of object using LINQ.
Public Sub DisAble(Byval ParamArray ctrlCollection() As Object)End Sub That is my sub routine where im trying to reset all controls that will stored into that object of array. But im trying to attain that using LINQ so I wont use any loops to access all of it.
I have been assigned to create a simple address book in VB 2005 and have got as far as I can with it. Contact entries are to be stored as an array of objects rather than to .txt file or access database (I know they will all be lost when shut down). I suspect this is probably pretty straightforward if you know anything about VB - unlike myself obviously.
Public Class Form1
Private objContact As New ArrayList
Private Sub BtnAddContact_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnAddContact.Click
Dim objcontact(100) As Contact
[Code] .....
I have tried to run below macro in excel 2010, but the error pop up and after press debug button, the line "expected_loss = application.worksheetfunction.average(final_loss)" was highlighted. May I know how to solve this problem?
Sub test ()
'Aim: to store data in array and calculate the average of the data in the array
Dim final_loss(1 to 70000) as double
[code].....
I have came up with code in my vb.net app that can extract particular tags, but what if I wanted to extract only certain lines of html code?
<td style="min-width: 100px; " align="right" class="aw-td body-td">4,400</td>
how to read a string in pieces.
Let's say the string is 800 characters long. I want to read 100 of them each time. How do I accomplish this?
I'm having a bit of trouble learning the uses of partial classes. I know they are used to split a class into several pieces for convenience but I don't understand how to put all of this into play. I'll show you what I mean here:
Lets say I have an interface named "ICar":
.NET
Public Interface ICar
Sub TurnOn()
[Code]....
OK, now that I have all of that, how do I put it to simple use in my partial class "OffRoader"? (You can add a "console.writeline" event to the methods if you want, in order to show me the uses of these partial classes.)
I am working on an inventory managment project for a lumber mill. I am currently writing a piece of software to be used on the sorting section of the mill. The problem I am having is when a stick of lumber needs to be cut down in lengt. My current setup has a combo box that is populated with lengths of lumber that we might have (2' - 60'), a "Add" button and a data control (homemade solution with lots of labels, and panels).
The user will scan a tag into the system, and the system pulls up the info from the db. If the piece need to be cut, the user will select the length of the cut, and click the add button. The system will then populate the first line of the data control with the info from the cut (previous piece info, and new length). It also populates a pieceObject struct. This happens for any additional cut that might happen.
The problem I am having is that everytime I press the "Add" button, the length variable will update every length in the piece array.
Here is a section of the code I am dealing with.
piece is a lumberPiece, and pieceAry is a array of 15 lumberPieces
Each time the add button is pressed, the current data is stored into the array, and then the pieceNum is incremented.
[code]...
I am struggling a bit with a string conversion. My platform is VB in Visual Studio 2010, windows form application. What I have is a Single float that occupies four characters of a string. Where Chr(0) is the LSB of the single and Chr(3) is the MSB of the single. This string is loaded by a built in function that communicates to an external microcontroller via tcp/ip that I do not wish to modify. I am having trouble figuring out a way to get these chars from a string to a single data type. I dont need to convert the data, just move it. But I keep getting type errors and not sure how to handle it in VB.
View 6 RepliesI am working on a project and the code for FORMS1.vb has become quite large, 20K lines.How can I break this down into more managable pieces. I have tried Modules but I get multiple reference errorsd when I move like all of the reporting code to a module. The report code has nothing to do with the forms other than being able to call that code from an object on the form.
View 3 RepliesAnyone care to explain why these two pieces of code exhibit different results?
VB.NET v4.0
Dim p As Integer = 16
Dim i As Integer = 10
Dim y As Integer = p / i
[Code]...
I am currently working on a program that edits txt files but it's for a game. There is a file that contains information that the client uses. This is what the file looks like:
|piece of code here|another piece|and another piece|
|piece of code here|another piece|and another piece|
|piece of code here|another piece|and another piece|
|piece of code here|another piece|and another piece|
|piece of code here|another piece|and another piece|
I want to make a program that reads this file and reads each piece of code separately and places them in different places like this:
[URL]