Recordset Returns 3 Times The Number Of Rows
Dec 15, 2010
I'm trying to run a simple select statement using an ADO recordset. But the resulting recordset returns 3 times the number of rows. For example the query should return 20 rows but is repeating 2 more times and returning 60 rows. When I run the query in Oracle it returns 20 rows.
Here's the code.
sSql = "Select * from Sector"
cnnOracle.Open("DRIVER={Microsoft ODBC for Oracle};SERVER=REPDATA.world;UID=auser;PWD=auser;")
[Code]....
View 9 Replies
ADVERTISEMENT
Jan 2, 2009
In my vb 2005, form one combobox and a datagrid view datagridview filled via dataset and sqldataadapter - declared class objects when an item in the combobox selected, some subitems corresponding to the combobox selecteditem is displayed in the gridview.ie., when a new item selected clear the grid and fill the grid from the new record set.[code]
View 1 Replies
Nov 21, 2010
i am trying to make a coin toss program where you toss a coin a certain number of times then repeat it a certain number of times.
the problem i have is "heads(counter2)" the word "heads" has a blue error line under it how do i sort the error out and also is all the code right
Public Class Form1
Dim tosses, repeat, heads As Integer
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code]....
View 1 Replies
Aug 31, 2011
This is my first time using the Entity Framework and I'm getting some confusing results. I know a particular table contains 3 distinct rows when I run this SQL query:
SELECT * FROM mytable WHERE service_month = 201012
When I run this query against the framework however, I get 3 rows, but they are all copies of the first row (VB syntax).
Dim temp = _context.mytable.Where(Function(x) x.service_month = 201012)
Did I set up something incorrectly? This is how I'd do it with LINQ to SQL.
View 1 Replies
Sep 17, 2011
I have this program generating a firstname and lastname from a file. When I run this program I enter information in three textboxes. The first two are the salary low and high(salary1.text, salary2.text) and the last one is the number of "copies"(copies.text) that I want.. When I put a number such as 10 in the text box it outputs some of the same names. The firstname file has around 100 records and the lastname file has about 1000 records Why is it generating the same name The problem is even worse if I do something like 1000 copies.. it outputs the same thing 8 times and then does something different another 8 times
Public Class Form1
Dim sex As String
Function randomfirstname()
Dim infile As IO.StreamReader
[code]....
View 1 Replies
Apr 12, 2012
I have the following function:
Public Function CheckHasRoom(people_id As String, semester As String, year As String)
' Don't let folks already registered for a room register for another.
Dim RoomSelected As String
[Code]....
But it is bugging out at hasroom.Any() saying, "Input string was not in a correct format." Any thoughts on why? This is returning a collection of rows just like where I use this same code elsewhere without issue?
View 3 Replies
Jul 27, 2010
when populating a data grid i keep getting a redundant row in the bottom. is there a way to lock grid rows to the number of rows in the data table?
View 1 Replies
Jan 18, 2012
I am currently using DevExpress 10.2 within Visual Studio 2010. In a previous question I was trying to print the current user view of a DevExpress GridControl with the user's choice of expanded or collapsed master rows and/or group sections. I was told this was not possible at this time. I have now decided to use the following code:
[Code]...
View 1 Replies
Jul 19, 2010
I have created a strongly typed dataset in the VS 2005 Dataset Designer. There are two tables that relates to each other in a one to many relationship: Claim and ClaimDetail. The designer automatically creates a function GetClaimDetailRows which returns all ClaimDetailRows for a ClaimRow. Why is this Array's length always 0? Because ClaimDetail contains more than 40 Million rows, i did'nt fill it before i call GetClaimDetailRows but had configured it's selectcommand that it takes a parameter idData to fill only the related records. But that seems not to work because the ClaimDetail-Datatable is empty.
The automatically generated function in the ClaimRow-Class which returns all related ClaimDetailRows:
Public Function GetClaimDetailRows() As ClaimDetailRow()
If (Me.Table.ChildRelations("Claim_ClaimDetail") Is Nothing) Then
Return New ClaimDetailRow(-1) {}
Else
Return CType(MyBase.GetChildRows(Me.Table.ChildRelations("Claim_ClaimDetail")),ClaimDetailRow())
End If
End Function
When debugging I see that it jumps into the else block but returns 0 rows. Do I have to fill the Claimdetail-Datatable first(ClearBeforeFill=True) for each Claim? But then I don't need to use this function anymore. I now fill the Datatable(ClearBeforeFill=True)before i call the Child-function and it works. But I don't understand why it could not throw an exception(optionally) when I try to acess a child-relation without having that datatable being filled(at least with 0 rows). Instead of that it returns 0 rows what can be correct or incorrect and is difficult to detect.
View 1 Replies
Mar 7, 2012
The following VB line, where _DSversionInfo is a DataSet, returns no rows:
_DSversionInfo.Tables("VersionInfo").Select("FileID=88")
But inspection shows that the table contains rows with FileID's of 92, 93, 94, 90, 88, 89, 215, 216. The table columns are all of type string.
Further investigation showed that using the ID of 88, 215 and 216 will only return rows if the number is quoted.
i.e. _DSversionInfo.Tables("VersionInfo").Select("FileID='88'")
All other rows work regardless of whether the number is quoted or not. I understand that the numbers should be quoted just not why some work and others don't?
View 2 Replies
Oct 24, 2011
I am using the OLEDB adapter (Oracle OLEDB) with Oracle 10.2.0.3.0. My code generates the SQL for the query, then when I execute it into an OLEDBDataReader, the HasRows is False. However, if I output the contents of the query string, copy, and paste into SQL+ (logged in as the same user from the same client machine), it returns 993 rows. What gives?? Here's a segment of my code:
[Code]...
View 2 Replies
May 12, 2010
I have a postgresql database, one table. This table has a date column too.And I have this code:
[code]...
The problem is, that the pgreader returns no rows (the parameters are right and the database contains the data too).firstday and lastday are f.e. '2005.05. 01.', the ConvertDate function converts the date to '2005-05-01' (the dates are storen in this form in the database)And when the commandtext="select * from arfolyamok where datum between '2005-05-01' and '2005-05-31'", then it works, the pgreader has the rows.Why? What make I wrong?
View 3 Replies
Oct 25, 2011
I have a vb.net app that I can read a .xls file into a dataset or loop through as oledbdatareader and it gives the same result.Some of the rows have all nulls when I loop through them but if I open the same file in Microsoft Excel I can see that row fine.[code]From the info above the first two SKU values would come through fine but when I get to the 3rd row it would show a null.Is it possible that it kind of inherits the first rows type and since the 3rd row isn't all numeric if nulls it? [code]
View 1 Replies
Jan 8, 2012
how do i count the number of rows that are affected when I updated a table, and display the number of affected rows in a message box ??
here is my code for updating the table ...
For Each row As DataGridViewRow In DataGridView1.Rows
req = row.Cells(Column1.Name).Value
If row.Cells("Column1").Value = True Then
[Code].....
View 1 Replies
Jul 16, 2009
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim timeN As DateTime
Dim timeF As Date = #7/11/2009 12:43:20 PM#
Dim timeR As TimeSpan
timeN = DateAndTime.Now
timeR = ?????
End Sub
End Class
TimeN is system time. TimeF is a fixed date and time. All I need is the number of seconds between fixed and system(now) for timeR (and counting).
View 5 Replies
Aug 26, 2010
I am using VB Express 2008 and want to return the titlebar text of a window This is what I have:
Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As String) As Long
Private Const WM_GETTEXT = &HD
Private Const WM_GETTEXTLENGTH = &HE
[code]....
This should simply return the window name I.e. "Calculator"But debugging it i get an "OverflowException" on:
strtmp = Space(length - 1)
If I look in the length variable it has "8975925931411505153" in it Why is it so big, and why is it not just "10" for the number of characters in calculator?
View 3 Replies
Nov 16, 2009
i am using a combo-box to add different grades to a column in a datagrid and i am using a loop to check if the sum the total number of sum i have made when ever i select a a grade from the combo-box.This is because i want to only add six grade and not more than six but the code i am using is giving me problems This is my code.This code is adding the total grade for me bur i want to check with a loop that will only allow the adition of only six different grade but when i run my program and begin to select the grades it just give me a message form my message box 'This is calculating the grades of an applicant
Private Sub cmbgrade_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbgrade.TextChanged
If Me.cmbgrade.Text = "A" Then
Me.txttotalaggregate.Text = (CInt(Me.txttotalaggregate.Text) + 1).ToString
End If
[code]....
View 1 Replies
Apr 10, 2011
This text book i have is not very good at all. the exercise's at the end of each chapter ask u to code projects without first covering the basic of what u will need do to code them. (Programming in Visual Basic 2008 Julia Case Bradley + Aninta C. Millspaugh)
Design and code a project to calculate the amount due and provide a summaray of rentals. All movies rent for $1.00 and all customers receive a %10 discount. The form should contain input for the member number and the number of movies rented. INside a groupbox display the rental amount, the 10 percent discount, and the amount due. inside a second groupbox, display the number of customers served and the total rental income.(afterdiscount).Include buttons for Calculate, clear, print and exit. The clear button clears the information for the current rental but does not clear the sumarry information. A print button allows the user to print the form. Do not allow bad input data to cancel the program; instead display a message to the user.[code]...
View 1 Replies
May 31, 2010
I have an SQL database with a single table with several colunmns. I want to count how many times a certain number appears in one of the columns. E.g. I have the following:
A B C
8 4 6
0 9 3
1 4 6
4 7 1
I want to count the number of times 4 is used in column B. I have looked at using the following, but not sure if this is even the right approach:
Dim db as New MainTblDataSet
Dim BCount = Aggregate B In db.MainTbl Into Count(B.B = num)
where num=the number I am counting the instances of (4 in this case).
The hope is that BCount will equal 2, but it returns 0 every time.
View 3 Replies
Nov 16, 2011
Basicly my instructor said that we have to make a program that will count how many times we enter a number into an inputbox, he also said we had to use a while loop. [code]
View 4 Replies
Oct 29, 2009
On the ping method, how do you increase the number of times it pings? I'd like it to ping 80 times at once.
View 4 Replies
Feb 10, 2009
Is there a way to loop words for a number of times (like i want to loop a word for only 10 times....How would I go by doing that?)
Quote:
Originally Posted by EXample Like I want to have a textbox and If i put 10 in the textbox It would loop the word ten times or is I put 20 in the textbox it would loop 20 times ..and ..etc...and ...etc...
View 11 Replies
Feb 16, 2009
I need a random number of 6 (1 ,6), and to loop it 3 times. I tried this but it gives me error for - if myRandom.next(1,6) Then:
Dim myRandom As Random()
For i As Integer = 1, 3
If myRandom.next(1, 6) Then
End If
Next
Also I need to know the code for putting a picture into a picture box.
View 4 Replies
Jul 16, 2009
I built a simple vb.net winforms project that pings IP addresses and logs the results. It works fine on most machines I've tried it on. I log the status result of the ping System.Net.NetworkInformation.IPStatus) by using the IPStatus.tostring method.
Normally this returns a text result such as "Success" or "TimedOut"Yesterday, on one machine it returned "65" ...which is not one of the enum values. I have a feeling it might be a combination of values. I ran some test code:
Dim status As System.Net.NetworkInformation.IPStatus
status = Net.NetworkInformation.IPStatus.Success
MsgBox(status.ToString)
Which returns "Success"And this: status = Net.NetworkInformation.IPStatus.BadDestination Or Net.NetworkInformation.IPStatus.BadHeader MsgBox(status.ToString)
Which returns "11050" I suspect the "65" I saw was the result of some combination of enum values. Is there any way I can change the code in my second example to show the text names of both values? That is... any way I can see ALL values in this variable?
View 5 Replies
Dec 23, 2011
My code gets a list of words from a txt file and chooses the words randomly. However, the same word can appear more than once and i need to know how to stop this from happeningHere is the code:
Dim aryName As String() = Nothing
aryName = File.ReadAllLines(Application.StartupPath & "Randomfnames.txt")
Dim randomWords As New List(Of String)
[code].....
View 3 Replies
Dec 13, 2011
I know it sounds strange but let me it explain. It has a purpose, but really all I'm looking for is the item with the most duplicates.I know it's possible and I've had a few ideas already, though none were successful or practical.What I'm doing here that requires this is creating an intuitive search for clients in a database. You type in a single field and click search. Behind scenes each keyword broken down from the single input field is searched through the table of clients, hitting each column and returning matches. the results are large in numbers, but truly it's the client that appears the same number of times as there are keywords.
View 1 Replies
Jun 21, 2012
i made a tool which detects arrow keys .When i click up it shows the word up in text box when i click down arrow it shows down word vice versia.
My problem is i want to count the number of times i clickd an arrow and want to save it in text doc with time and date
View 7 Replies
Nov 11, 2009
How can I count the amount of times a character appears in a string?
The assignment is to create a program with 2 text boxes, label, and a button. We then need to type a phrase into the first text box, and a character in the second. Then click the button and then the label will display the output of how many times the character in the second text box appears in the first.
I have all the above setup except for how to display the amount of times the character appears in the first text box, here's a picture:
View 8 Replies
Apr 3, 2011
Okay, so basically I'm trying to have my application randomly select items from a (multiselect) listbox. I want the user to enter the amount of items they would like randomly selected and it should all happen at the same time. I have the random shuffle down but it only selects one song each time you click the button. How can I loop this code as many times as the user specifies in the textbox?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
Dim shuffle As New Random
Main.songlist.SelectedIndex = shuffle.Next(0, Main.songlist.Items.Count - 1)
[code].....
View 1 Replies
Mar 16, 2010
input = "my mother is a great lady" output = A -3, B - 0, C - 0, D - 1, E - 2
I wanted to count the number of times letter A - E is in the input string.
View 7 Replies
