Keeping Original Index After Sorting?
May 8, 2009
I have been on a hiatus from VB for some time. I was coding in C++ and C# for quite some years and on my venture back to VB, decided to put my trusty VB 6.0 on the shelf and try out the new 'rave' VB.NET. I'd first like to say, I can't imagine how different it is from older versions. I'm using Visual Basic 2005 and I find myself sometimes pulling my hair out over things that were common practice before, yet have been totally revamped. But I'm getting by, barely, but getting by.
My problem is this: I am writing an application that loads the Title field of a DataGrid (after being loaded from a DataTable of course) into a ListBox then sorts them. The problem is, upon sorting, I lose the original index value that pertains to that entry in the DataGrid. In other words, if the first ListBox item is selected, it contains the index value of the first entry in the DataGrid, which stores the rest of the data to fill the labels and controls on the form. I have a semi-workaround for this by iterating through the DataGrid and comparing the Title field to the text of the selected item in the ListBox, but the downside to this is that you could never have the same named item or you would only get data for the last item entered. My question is... Is there a way to somehow retain or store the original index values of a ListBox before sorting? If so, this would make my code a lot smoother and allow for multiple entries of the same name in the Title field of my database.
P.S. If someone could go through how to access items from the DataTable itself, I could get rid of the DataGrid altogether, as I don't need it other than to access the DB data. I couldn't figure out how to get at it while it is in the DataTable, so I loaded it into a DataGrid control and made it invisinel.
View 6 Replies
ADVERTISEMENT
Jul 13, 2009
Public objword As New Word.Application
objword.Documents.Open(FileName:=ofilename)
^ Showing the declaration of the word document that i wish to edit.
Dim oDoc As Word.Document
objword.Visible = True
oDoc = objword.ActiveDocument
oDoc.Range.Text = codes(j, 1) & " " & codes(j, 2)
This gets the document and adds text into it, exactly what i want it to do. But it replaces the whole document. I just want it to add text at the start of the document. Not replace the whole document.
View 3 Replies
Oct 24, 2010
If I use a LINQ query over some type of collection, is there any way to know the initial index of an element of the result?
Purpose: I make a query to set as source of a DataGridView, and on a (button)cellclick event I want to a call a method that needs to reference the collection at the correct index.
View 13 Replies
May 30, 2012
I have a List(of String()). I have written a custom comparer (implements IComparer(of string)) to do an alphanumeric sort.Is there a way to sort the List using a given index to determine which position in the String() to sort by? In other words one time I might sort by Index = 0 and another time by Index = 3. The length of all String() in the list is the same.For reference this question is similar to Sort List<String[]> except I am using VB.net and that question is hardwired to Index=0.
EDIT from OP's comments:I started simple with the non custom comparer but I am getting an error: expression does not produce a value. Not sure what I am doing wrong.Here is the code:
Public Shared Function SortListOfStringArray(ByVal ListOfStringArray As List(Of String()), ByVal SortByIndex As Integer) As List(Of String())
Return ListOfStringArray.Sort(Function(x, y) x(SortByIndex).CompareTo(y(SortByIndex)))
End Function
View 1 Replies
Mar 12, 2012
I'm having my program sort an excel sheet by a few columns. However, it is only sorting by the first column not the rest that I specify.ere is my sort code below:
myRange.Sort(Key1:=myRange.Range("A:A"), Order1:=XlSortOrder.xlAscending, Key2:=myRange.Range("G:G"), Order2:=XlSortOrder.xlAscending, Header:=XlYesNoGuess.xlYes, Orientation:=XlSortOrientation.xlSortColumns)
[code]...
View 1 Replies
Aug 20, 2011
I have a WPF ObservableCollection which is bound to a ListBox and I have a Sort() method which when called will convert the ObservableCollection to a List(Of T), and undertakes a sort based on a date/time column within the collection.
The data is sorted, even when new items are added to the ObservableCollection, however the date/time isn't being correctly sorted. The data is sorting based on the date however it is very much random when it comes to the time portion. The following is an example of the outcomes I am experiencing:
[Code]...
Is there anything that I am doing incorrectly in this method that would cause the time portion not be included in the sort? Is there a better way of doing a sort?
View 1 Replies
Apr 23, 2012
i am having trouble putting a value in a textbox. Each time a ticket is sold i put the total price in a textbox, each time a ticket is sold for the same concert it increases by adding its self to the total price. It works at the first sale, but after that it breaks down. here is the code
Private Function DisplayMoneyTaken() As Integer
Dim totalMoney As Integer
'open the database connection
[Code].....
View 1 Replies
Oct 23, 2009
Getting error filling grid view from reading through data table:
Dim myDataTable As DataTable = myDataSet.Tables("SunTrust")
Dim myRow As DataRow
Dim i As Integer = 1
Try
[code]....
Error:Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index
View 7 Replies
Dec 9, 2009
I am using Sub to format datagridview but during Form_Load this error occur. There are rows in datasource and dg.row.count is > 0.
.Columns(0).Width = 50 <==== ERROR HERE
.Columns(1).Width = 150
.Columns(2).Width = 80
.Columns(0).HeaderText = "ID"
[code].....
View 1 Replies
Jan 22, 2009
What im trying to do is send vars to a flash file.The following is my code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim oTitle As New ArrayList
Dim oSub As New ArrayList
Dim oRate As New ArrayList
[code]....
What I'm expecting the output to display is something like "t1=value&s1=value&r1=rate&t2=value&s2=value&r2=rat&t3=value&s3=value&r3=rat" But... i keep getting this exception: index was out of range. must be non negative and less than the size of the collection. Parameter name: INDEX.
View 3 Replies
Aug 25, 2011
I have a datagridview, with 3 columns, each containing dropdown filters (in the column header). Of the 3 columns, 2 are working perfectly fine, but whenever I try to filter the 3rd column, it gives me this error: (Also all of the column's have the ColumnType property set to: DataGridViewAutoFilterTextBoxColumn) "Index was out of range. Must be non-negative and less than size of the collection. Parameter name: index." The error points to the part that begins with "If dgv1.Rows(e.RowIndex)..."
Private Sub dgvWPS_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dgv1.CellFormatting
If e.ColumnIndex = 1 Then
[code]....
View 3 Replies
Apr 13, 2010
i am trying to get the value into the cur_stock where item_id = datagrdiview.curentcell.value.I am lookin out for the solution since couple of days, but couldnt figure it out.Well, m trying to make this work on CellMouse click event
Below is my vb.net code:
Private Sub DataGridView_stockout_CellMouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles DataGridView_stockout.CellMouseClick
Dim i As Integer = Stock_checkDataSet1.Tables(0).Rows.Count - 1
[code]....
View 18 Replies
Apr 30, 2012
Trying to input a high setpoint, low setpoint, a % load, and number of compressors, then calculate the temp that all compressors are off. Then build a datagridview with the staging of compressors from all off to all on for each compressor up to 10 compressors.I am trying to insert headers from 1 to 10 compressors (Variable) with the text "Comp1", "Comp2", etc....Two rows with header. I am trying to use an array with index number to insert the text, but that is where my problem happens."Index was out of range".Here is my code
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim i As Integer, num1, num2, num3, num4, alloff As Single, stg As Single
TextBox1.Focus()[code].....
View 4 Replies
Mar 5, 2009
I've got the web browser with tabs in all working fine, but there's one bug, i can add tabs, delete em, etc.. but when i delete a tab then go to create a new tab, it gives me the error: InvalidArgument=Value of '6' is not valid for 'index'. Parameter name: index '6' is the number of tabs i had open.Here's the bit of code i use to create the tabs with the browser in it:
vbcode
Dim browse As New WebBrowser
browse.Name = "b1"
browse.Dock = DockStyle.Fill
[code]....
View 2 Replies
Jul 26, 2009
When the selected index changes I for a second time this code errors.
vb.net
lvReports.SelectedItems.Item(0).SubItems.Item(2).Text
with this error message
InvalidArgument=Value of '0' is not valid for 'index'. Parameter name: index
Why is this?It worked for the listviews.click event perfectly.
View 2 Replies
Nov 14, 2010
I am coding a program for a movie trivia game that randomly shows a movie quote and the the user selects a movie name from a combo box that matches. I used a array for the movie quotes and a comboBox for the movie names. I have coded a portion of the program but I am stuck on how to compare the array quote being shown to what movie the user selects from the comboBox. I have tried numerous different things but none seem to work right. The way I have it coded now it shows that every movie I pick that it is right even if it is wrong. I am going to show part of the code here and also attach the entire solution for anyone that needs it .
[Code]...
View 6 Replies
Apr 14, 2009
I am working in VB 2008 and I have set up a datagridview to display rows of data which can then be selected. When I select the first row I get the error: Index was out of range. Must be non-negative and less than the size of the collection. When I select any other row the program executes as it should. From what I have learned so far is that the DataGridView has an index of -1 and that it counts the header row as part of the index which is the -1.When I select the first row through either DataGridView1_RowHeaderMouseClick or DataGridView1_CellContentClick the index is 0 for the first record. If the index is 0 I think it would fire off, but I have no idea what is happening behind the scenes. I can check the index, so when it is 0 and the code attempts to access the row, that is when I get the message.On an index number of 1 and up the code executes fine.So, is there a way to re-index the DataGridView, or is there a work around/fix for this issue?
View 2 Replies
Apr 6, 2010
How can i get the Column Index and the Row Index when I click on the ListView?The ListView1.FocusedItem.GetSubItemAt(e.X, e.Y).Text function only gets the text of the first column, I can't find the option of getting the Index of the Column and Row upon clicking.
View 9 Replies
Dec 9, 2009
How can i get the combo box to keep the value that was partialy keyed in and completed with auto complete.Pressing enter doesn't select the value so when you tab out it keeps the entered auto completed value. The only way to keep the auto complete value is to click on the combo box with the mouse and then tab out of it. I would like some how of being able to tab out of the combo box and it keep the auto completed value that the user has entered so as to save time entering data so no mouse clicks are needed and the data grid view can be tabbed through and all data entered from keyboard.
View 3 Replies
Mar 31, 2009
I have a program that requires login and I have that part working, but I'd like to be able to tell which user has logged in. There's a database with the user info (ID and password) but I'm not sure how I can have the program record which user has logged in.
View 5 Replies
Jul 7, 2011
I have developed a very simple application that disables system keyboard commands (ctrl+alt+del, alt+tab, etc), hides the taskbar, hides the desktop, etc.Upon entering a password the user can 'unlock' these options.This is being used with a restaurant POS system so no accidents can happen. However there seems to be one minor issue:In a separate software package (the POS software), at specific times, any application that is running (my locking application) will get focus and end up on top of the POS software.I want my locking software to remain underneath all running applications. Anyway to keep my locking application from gaining focus? I was thinking of maybe adding some line of code to send my locking application into the background whenever it gets focus..
View 4 Replies
Aug 31, 2010
I have been working on a VB app to edit an excel document. I want to keep my excel workbook in scope for the whole app.
For example here is how my program looks now
private sub
open workbook
end sub
private sub
reference workbook
end sub
I want a way to just call my workbook at the top and have all of my subs recognize it. I guess like a global variable or something.
[URL]
View 5 Replies
Apr 23, 2010
using Vb net (2005) Wandering if it is possible to use AppSettings in this case: Keeping counts how many time my Win Form app. has run, could someone show me if this can be done
View 4 Replies
Apr 1, 2012
I want to create SETUP for vb.net window application. My application uses multiple dll.so I want to keep dll in separate folder and exe in separate folder. When I create setup, dll and exe are in same (Application Folder of setup), then it works, but when I create 2 different folder in Application Folder of setup, one for dll and one for exe, then it desn't work. Please suggest how can I ?when I create set up then all goes to applciaton folder. when i installed then all are installed in same folder.but I need all dll goes to sperate and exe goes to sperate folder.
View 1 Replies
Nov 9, 2011
Basically i'm coding a application that can be used as a crosshair.How do I keep this above the game which runs in fullscreen. I've tried
View 5 Replies
May 11, 2012
I have a MDIParent form that has a bunch of child forms. When I open a child form, I can actually move the form outside the bounds of the Parent. How can I prevent this? I've set each of the Child Forms "IsMdiContainer" property to "False". What am I missing?
View 1 Replies
May 26, 2011
I've been trying to find the answer to keeping an application from allowing "scaling" of controls and forms to the user's settings. I have set the autoscalemode to "none" on one form but it doesn't seem to work. I'm using Visual Studio 2008 Visual Basic. My users are on using either XP or Windows 7. I think we are all using Framework 3.5 but not really sure.
I knew this problem would eventually become an issue but ... Now the problem has become an issue. I have a user that has dual monitors and has the text setting on medium. Now the label controls overlap the input text fields.
View 1 Replies
May 24, 2011
I have two combo boxes, and four buttons. When the user clicks "Add" on the first combo box, it adds a new item to the combo box with "New" and then lets the user rename that item to something else. That "new" item has to have an array of "answers" that go along with that item in the list. What I'm having trouble figuring out is assigning "answers" to the second combobox for each item in the first combobox and changing the second combobox when selecting an item in the first combobox.
EXAMPLE:
Item 1 - Combobox1
- Item 1 - Combobox2
- Item 2 - Combobox2
[code]....
View 5 Replies
Apr 20, 2012
I am running a VB.NET program and having an error of "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index".My code looks like below.
If Status.InvokeRequired Then
Try
Status.Invoke(New delegateoneArg(AddressOf onChangeEvent), ws)[code].....
View 2 Replies
Jan 25, 2010
im wondering if it is possible at all to bisable a button after it being clicked because i have no idea on where to start on doing this. I only know how to get it to disable for the one session but when the program is run again it is enabled again. Is there any way to just keep it disabled because it nly ever needs to be clicked once.
View 20 Replies
