I am trying to loop an array in a sql insert statement but i can't get it working. Below is a demo i'm trying to get it running. I think i am having problem with the declaration of variable in sql statement.
Public Class Form1
Dim arrayValue(5) As Integer
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click[code]......
Coming from PHP and more specifically many of the MVC frameworks out their, I've been use to using basic foreach and if constructs in PHP directly in the layout. Now that I'm learning ASP.NET I'm presented with more proprietary concepts like a ListView to control looping, etc...
So to give an example of what I want to do..
<div id="container">
<h1 class="header">Title</h1>
<% For Each item In ItemsCollection %>
[Code].....
Then there isn't a lot I have to handle in the Code Behind file... besides making ItemsCollection available.
Is This considered Bad Practice? Should I spend the time learning the proprietary controls for ASP.NET? Are there specific limitations of this approach?
I am working on a code that should capture the color of a pixel in a bitmap and then check if the 8 surrounding pixels have the same color. If the checked surrounding pixel HAS NOT the same color it will be ignored, otherwise if it HAS the same color, it should check for its own 8 surrounding pixels and so on.
To do that, I have created an array that starts with a single entry (the x,y coordinates of the initial pixel). So, when a pixel with the same color is found it is pushed to the end of the array. I used a for each loop supposing that VB would keep looping until the end of my array - and since it is growing, the last position of the array would be always pushed until I have not more pixels to be checked.
The problem is that VB is not respecting it, and is considering my array as if it had just 1 entry. Seems that it catch the size of the array when it enters the loop, and regardless the fact I have pushed new items to the array it doesnt keep looping it.
How can I force VB to update the end of array position while looping it? Although I think it wouldnt be necessary, here it goes the code I have so far...
Code:
I'm trying to do the following LINQ grouping, which works in the debugger (the results are populated in the GroupedOrders object. But VS 2008 gives me the following error at design time...
Name 'x' is not declared
Dim GroupedOrders = (From m In thisConsultant.orders _
Group m By Key = m.commCode Into Group _
[code]....
I have a set of nine double variables declared earlier in a program (i.e., phq91 through phq99) that I have placed within an array. The variables need to hold numeric data that correspond to item responses within combo boxes.
View 6 RepliesI have a class with properties in it . The properties in it are all named the same with the columns names in the database.The reason for that is that i want to loop through all the properties within the class and dynamically create an sql query with the parameters in it . Then dynamically create the parameters and add them into the oraclecommand , everything works well until one of the properties ( QTY ) is set to 0 . When it is set to 0 , during the properties loop ,it will check it as nothing and bypasses the QTY property , with that i am missing one of the columns.class with properties , Notice the property Qty it is Nullable(Of Integer) , it is because when inserting data into the database , sometimes i would want it to be null instead of default 0 .
Public Class HDB
Public Property BONum() As String
Public Property Owner() As String
Public Property Qty() As Nullable(Of Integer)
[code]....
I have an arr of sPNoListDefintion.[code]How can I cycle through the elements?Something like For Each i As integer In sPNoList.
View 10 Repliesif i have a text file that reads
gsf
hot
dmg
bp
comp
how can i pull it into an array and if the textbox = any of the lines then execute event something like this
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If Me.textbox1.text = (textfile contents) then
timer1.interval = 500
[code]....
im just not sure on how to initiate the calling of the text file into an array.or if i could call lines from a richtextbox and if textbox1.text = a line in the rtb then execute. I guess what ever would be simpler.
I'm working on a Connect 4 game. I created a rectangle with 42 holes punched out of it (drawn in Panels Paint event) and I have 42 circles (created with PowerPacks) placed in each punch out. Right now I'm just trying to get the game pieces to drop into place by looping through each column and coloring each punch out sequentially. Here is my
vb.net
Public Class Form1 Private Sub Panel1_Paint(ByVal sender As System.Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles Panel1.Paint e.Graphics.SmoothingMode = Drawing2D.SmoothingMode.HighQuality Dim dimension As Integer = 50 Dim
[code]....
The problem I'm having is with my array of OvalShapes. I declared it as object and I don't think that's right. The for loop under the click event is not producing anything.
I'm making a card game and I want to try and design my own card deck.
Dim X As Integer
Dim currentCard As Integer, currentCard2 As Integer
Dim RandomNumbers As New Random()
Dim NumberofCards As Integer
[code]....
I started a basic vb.net class for my fall semester of high school, and although I've learned a lot, my goal since the start of the semester has been to do this. I realize there are simpler way of assigning card values than writing 52 if then statements, but I'm planning on doing other things with the statements. As you can see, my main plan of action is to generate a random number for each card, loop through the array list to make sure the random number representing that card hasn't been assigned before, use the value to select the card, and then add the randomly selected number to the array list so it won't be used again (non-repeating random numbers).
1) I'm trying to represent all the numbers with Numberlist.Item(X) and that doesn't work because either a) x represents any one number or b) x always represents only 0, which means it only checks the first number.
2) I think I've read something about using this method for generating random numbers in a loop, that it doesn't work for some reason.
I am trying to create a multi dimension array that will search each row of the array and total up the number of 0's 1's, 2's, and 3's. I believe that I need to create some sort of looping structure that will search through each row of the array.I have created a listbox that will allow the user to pick which row of the array the program will search.This is what I have created so far, but I am only just learning and I am having trouble wrapping my head around how arrays work. So I'm not sure if I am on the right path or not.
Dim racescores(,) As Integer = {{0, 1, 0, 3, 2},
{1, 0, 2, 0, 0},
{0, 3, 0, 1, 0},
[code].....
I have a 1-dimensional array that is essentially is written to a csv file. My problem is that after I have loaded the entire array...I wish to write it to the csv file and I'm not sure how to set it up.[code]...
View 6 RepliesWrite the statements to declare a local one-dimensional array named intNumbers.The array should have 20 elements
B. Write the statement to store the value 5 in the second element contained in the
intNumbers array
C. Write the statement to declare a form-level one dimensional array named mstrProducts.
The array should have 10 elements.
D. Write the statement to store the string "Paper" in the third element contained in the mstrProducts array.
im having some trouble with my loop code. When the isnumeric code detects it not a number it throws the msgbox error message but moveson to the next array for the user to enter a value via inputbox. Is there a way for the program to send the inputbox asking for the value again before moving to the next array?
[Code]...
how to get an array of string from certain datagridviewcolumn,i try using this code,it doesn't work..
For Each row As DataGridViewRow In dgvPaketRow.Rows
If Not row.IsNewRow Then
Dim str() As String = New String() {row.Cells(0).Value}
Dim strRes = String.Join(", ", modCommon.str)
msgbox(strRes)
End If
I have declared and array
[Code]...
I have created a SWAP function that does the swapping if the index value is greater than the index+1 value, with a loop that will iterate through the array (assuming that you dont have to specify how many iterations are required) until the array is sorted.
In VB6 I could set up code to loop through say 10 option buttons to check their values. The code would be something likie this:[code]But in VB .NET it seems that if I use the Controls command as above I cannot use/check the Checked property as Control does not take that as a property of Control. It seems also that I may have to use the Find property of Control as in "Controls.Find" etc.How can I do this in VB .NET? I have a very control intensive application and I must be able to easily loop through controls and check their values without writing out 10 x the code required.
View 8 RepliesIs there a way of merging (importing or whatver is the correct terminology is) the data from an Array in to a DataTable woithout looping. I already know how to loop through the array to populate the DataTable with new DataRow but I'm looking for something much faster if it exists. I've got a 1 dimensional String array i.e. 'String()' that I need to populate a DataTable with new DataRows.
View 4 RepliesCan someone give me a site to a tutorial that will help me write a program that will generate a pattern using do while, if else statements,and do until statements. I have been using google but I can't find anything. I need to generate patterns a certain size 6 by 6 or similar such as something like a checkerboard but where the ^ symbols is there a suppose to be a blank space..
View 3 RepliesI save the client data into an array list. How to find part of data(currentIP) inside the array list(clientList) with fast method? [code]
View 1 Replieswhat's the difference between variable array and object array?
View 7 RepliesI have this function:
Public Sub DoStuff(ByVal type as System.Type, ByVal value as Object)
End Sub
The 'value' argument is always an array of the same type as 'type'. How can I loop through the values of the array?
I'd like to be able to do something like this:
DoStuff(GetType(Integer), New Integer(){1,2,3})
Public Sub DoStuff(ByVal type as System.Type, ByVal value as Object)
//Strongly types arr as Integer()
[Code].....
i have created control array , now i wann to loop around as well wann to find which control has triggered the respective event my code :
[Code]...
I am trying to figure out how to do this:
if (phrase = hello) then
"say hello"
if (phrase = how are you?) then
[CODE]...
So basically, I want it to work like a timeline. If I say hello, then it will respond and move onto the next if statement. Get it?
Here is the code I have now:
If phrase.Result.Text = "hello" Then
synth.Speak("Hello to you too")
If phrase.Result.Text.Contains("How are you") Then
[CODE]...
if i generate a label dynamically i can change the text as followed, variable is a string: Form.Controls(variable).text = "test" I now have a sub that will create some and will get some information out of arrays. I have a lot of them. I only want the function for tat specific array. I do not want a case or if. Thats why i was wondering if i can use a variable in the array variable. [Code] But instead of TestArray being hard-coded i want it to be replaced with Shelf. So whatever gets send into the sub will change the array that i'm using. Is that possible some how or is the way totally wrong?
View 1 RepliesI'm writing reports in Report Designer (VS 2008), and I've reached a point where I have to circumvent the restrictions on using aggregates in groups. I believe this can be done by utilising custom code, which is written in Visual Basic as far as I know (not sure what version though).
I have a dynamic number of "Pools", which each contain "Models". Each Model row needs to set the Pool Multiplier to the maximum of the current multiplier and proposed multiplier. The Pool row (parent group row) then needs to get the Pool Multiplier.[code]...
Is it possible to set the name of a variable to the value of an array? so I have the array[code]...
View 3 Replieshow to add a counter variable to this array? My code always stops when it gets to an empty array. I can't figure out how to make a counter variable to make it stop.
Private Sub btnTwo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTwo.Click
For Each i In PlayerArray
[Code].....
simply i am trying to add some value in array variable for datafiled.
dddd
Dim dkeyn(docc.GetElementsByTagName("pkey").Count) As String ' it have 4
Dim ir As Integer = 0
[Code]....
I have a variable (double) which has a constantly (infinitely) changing value. I would like to store all the values of this ONE variable into an array. My variable and array are:
Dim x as Double
Private y as Double() = New Double (499) {}
I tried doing this:
[code].....