The below code will fill User Records in "users".
Dim users= From p In oDbUser.USERs Where p.STATE= "MI" And p.STATUS = 1
how can i use a foreaach loop in the result and take each indidual row items ?
How can i write this query with LINQ to a FoxPro database?SELECT count(*) FROM Table group by item1I wrote it as below, but it doesn't work
Dim Query
Dim dt As New DataTable
Dim da = New Odbc.OdbcDataAdapter("SELECT * FROM table1",connection)
[code].....
in my prev question i was suggested with LINQ solution. It was great and simple. I tried to solve next similar but a bit diff problem with similar approach but i failed.
how can i make the below code better
For Each Item As ListViewItem In RoomsListView.Items
For Each Item1 As Room In myBookedRooms
If Item1.UIN = Item.SubItems(1).Text Then
[Code]....
I have an array of approximately 1000 classes. All of these classes must have one of their properties changed to the same value. I need this to be as optimized and fast as possible.
Would LINQ be faster than a for-loop? Any other ideas for faster execution?
Is that possible to get current Enumerator (...or iterator? Don't know which tern is the correct one) in a LINQ query ? For example, I try to create a XML output (via LINQ to XML) of all currently loaded assemblies. [code] is it possible to somehow get current "index" (counter?) from LINQ's Selects? I would like to use it in XML. [code]
View 1 Repliesthe purpose of the program is to display the monthly payments on the loan.My homework is to use do while loops instead of for loop.Here is the code for the for loop.
Option Explicit On
Option Strict On
Option Infer Off
[code].....
Now I'm having some trouble displaying the output using the do while loop, and I'm pretty sure it's a loop problem on my code. However, I cannot seemed to find out what's wrong. I looked at the examples of do while loop in my textbook, but I couldn't find anything useful to my problems of my program.This is the output for the do while loop.
Here's the do while loop code
Option Explicit On
Option Strict On
Option Infer Off
[code].....
When I use a For loop in a For loop the Contains Statement dosen't work! Even my custom one! I even tested mine and it works 100% And neither that or the String.Contains function work inside of For Loops And, I know both of them use loops to search through a string.
My function(It will atleast search once):
Function RealContains(ByVal load As String, ByVal needle As String) As Boolean
load = load.ToLower
[CODE].....................
I am using one datagrid to load a resultset of query.
My query is "SELECT S.RACK,R,RNAME,SUM(B.QTY),SUM(B.VALE) FROM STOCK S,READYRACK R,BILLDET B WHERE S.SCODE = B.SCODE AND FLAG ='09' AND R.RACK = S.RACK AND B.BDT BETWEEN '01-NOV-09' AND '30-NOV-09' GROUP BY S.RACK,R.RNAME "
USING ORACLE 8i. I am using more than one table.
connstr = "DATA SOURCE =RASI;USER= BILL;PWD=AIRINDIA;"
conn = New OracleConnection(connstr)
conn.ConnectionString = connstr
conn.Open()
[Code] .....
When running my code, it didn't return any result.
I need to know how to display the result of a select query in a datagrid or GridView with VB.NET?
Consider SELECT * FROM some_table. I don't know what columns the table has. Is there a way to just output the result to a table, with a dataset for example?
Could anybody tell me which event is good to start the thread to load resultset?
Example :
Dim Table As DataTable
Sub LoadItem
Dim BL As New BLItem
BL.LoadResultSet()
[Code]...
I have numeric data that I am getting from a database. They are all numeric, but they are a mix of int, money and real
View 2 Repliesi have a resultset in datatable?
View 4 RepliesI tried Firebird with .NET Provider yesterday. Firebird was sure to beat SQL Compact Edition. I was amazed from it's features and precision. But I felt sad when I wasn't able to find updatable RecordSet/ResultSet features and functions in the .NET provider. FBResultSet doesn't contains anything, no rows addition, creation, modification, nothing. Anybody knows if this feature exists in Ado .Net provider of Firebird because there's no documentation.I would like to receive help because I am waiting to integrate Firebird in my freeware application.Also, if there's are replacement functions for implementing updatable RecordSet, ResultSet.
View 1 RepliesI have a 5 by 5 matrix I want to populate and I would like to simplify this into for loops. As I understand, I would need 2 for loops to complete this task?
Dim x(4, 4) As Char
x(0, 0) = Mid(key, 1, 1)
x(0, 1) = Mid(key, 2, 1)
x(0, 2) = Mid(key, 3, 1)
[code]....
EDIT:I have a ItemList : Dim ItemList As New List(Of String)I wanna append each element from itemlist to a new list for 10 times each, then to start over again.How can I make a loop for each element while there are still elements in the list (10 times each)?I tried this but it's not working.
Private crt As Integer = 0
Private limit As Integer = 0
Private Function getline() As String
Dim line As String = ""
[code]....
but I didn't know where to add the 10 times limit and also the current item number(crt)
I'm writing a super small interpreter in vb.net because i need to execute a simple (invented) language so the app understand it and do what ever it needs to do.Everything went well until i reached the control structures and the loops.So my question its, in a code that its executed line by line using a simple for each how can i match the "WHILE ;" AND "ENDWHILE;" and execute the code within it?
The first thing that came to my mind its kind of flag the line of the reader and read the content from that line until find "ENDWHILE;" and the store that to execute late, so keep isolating the code in parts until I've all parts and then execute it.But i'm not so sure how to code it or if my reasoning its correct.PD: I'm using regexs.
I did For each Loop in my combobox, but I noticed that it loops twice. When it reaches the last item, it loops back to the first item. I code it typically: For each itm As Object in combobox.Items
[Code]....
have a problem where I have an application that allows someone to enter two integers. The app then displays all the odd numbers between both integers and all of the even numbers between both integers. There are two text boxes and two labels: even and odd. How would I code a For..Next loop for this type of app. The part where I get confused is what do I determine and how do I
View 18 RepliesI would like to simplify a do loop.
View 1 RepliesThis is for .net frameworke 3.5 and visual studio 2008 in VB.Net.Two things we would like to do: 1) loop repeating node blocks 2) loop (through repeating node blocks) within repeating node block loop
First thing:
How do you loop through an xml that has repeating node block (<STRUS name="1000A") and extract the following node? For example you want to extract the IdentificationCode in the node that has <SVALU name="ZRT" and is from pos="9".So, the following example has the IdentificationCodes (TGJ23, PGA12, TPX12)
<?xml version="1.0" encoding="UTF-8"?>
<DocSplitterReport xmlns:xsi="http://www.w3.org/2001/X .......
<STRUS name="ROOT" lineStart="-1" lineEnd="-1">
<STRUS name="TAC" lineStart="1" lineEnd="194">
<SVALUs>
[Code]...
Is it possible to merge two For Loops into one? I need this because I am using two for loops (1 to 100,000) to work with the data in a collection. The problem with this code is that it takes more than two hours two finish:
[Code]...
Is there a more efficient way of doing this code?
For Each row As DataRow In dt.Rows
Dim ts1 As String = row(0).ToString
For index As Integer = 1 To 9[code]....
Im somewhat new to VB, my first time writing a mildly long program... have a program that will create an unknown number of textboxes, then later I will need it to manipulate those textboxes. I set it up so it names them txt1, txt2, txt3 etc..How can I write a loop that will refer to each of these textboxes by name so I can do what I need with them, ie for example in
For i =1 to x
txti.text = i
next
this would make no sense...how do i write the names correctly so the computer can understate and loop them as txt1, txt2,...?
Basically I have 4 empty textboxes. I need to calculate the total and averages of the numbers entered in them. So far, I've declared 4 variables and made it equal to the text that was input by the user. I'm stuck with the calculations tough. The user doesn't have to use all 4 boxes. So if he/she only entered 2 numbers, the total is divided by 2, not by 4 for the average. I think I'm supposed to use a for... next loop because the maximum iterations I should do is 4, but I'm not sure how to the code even if it is supposed to use a for loop. Otherwise, the rest of my project seems to work fine.
View 5 Repliesim new to this site and also a beginner on visual basic During form load, the number items required in the Adult ticket and Child ticket CBO's must be populated with code using a single For Loop.The Items Collection in Design mode must not be used to populate these CBO's1. Movie ticket prices, taxes, and fees are as follows:a. Adult Matinee - $9.25
[Code]...
I have visual studio 2008, and we have been given specific tasks to carry our for our course, we have been asked to implement euclid's algorithm by using a while loop, doing so without the visual part of visual basic whatever that means an example of a question they gave was 1)HCF(88,26)=2 how I would go about doing this, as I am thoroughly confused, and deadlines are fast approaching.
View 3 RepliesTrying to figure out how to calculate factorials via loops. Cant seem to figure out where to start when using loops.
View 9 RepliesI'm new in programming especially in vb.net and I have a problem displaying the following using for-next loops:
1
2 3
4 5 6
7 8 9 10
11 12 13 14 15
16 17 18 19 20 21
...and so on...
Initially I wrote this code
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim row As Integer
Dim col As Integer
Dim txtNumber As Integer = CInt(TextBox1.Text)
[Code] ......
The output is this
1
2 3
3 4 5
4 5 6 7
5 6 7 8 9
... and so on...
The Code has two options. Option one starts with 1 dollar and doubles everyday for 10 days. If this is correct the value should be $1024 but instead it shows double that ($2046)
The second option starts with $100 and adds $100 per day for 10 days. The number should come out to an even $1000 but instead shows $6500
Public Class Form1
Private Sub compareButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles compareButton.Click
[Code]....
I have a matrix for example (10 x 10) which represents 10 nodes. The matrix called MyMat(9,9) The rows of this matrix represent the source node (From Node) and the columns represents target node (To Node). It has 14 links which are randomly distributed. The non zero values represent the connections between nodes.
[Code]...