I have a BindingList of transactions that I am binding to a DataGridView. The client now wants each row to have a sequential number. (1,2,3, etc).There could be hundreds of transactions. So is there an efficient way to assign a sequential number to each item in the bindingList?I know I could For/Next through and manually assign an incrementing index. But I am concerned about the performance when we process lots of transations.
View 1 Replies
had a sequential text file loading into a list box this afternoon, opened the programme a few minutes ago and its not working! The text file was loading first name and surname onto the same line, but now it will only put the first name into it.
Private Sub frmSelection_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Datafile() As String = IO.File.ReadAllLines("Datafile.txt")
Dim query = From line In Datafile
[code].....
What I am trying to do is connect a sequential text file up to a list view. It displays alright but i have a button which is to add certain details to the sequential text file, but instead of adding it in comma separated variable format, i.e. John,Murphy, etc... horizontally it adds the information vertically downwards, i.e. John
View 5 RepliesI am trying to copy the values to another sheet but not in any sequence eg.A1,B2,C4,D7 ........and so on. I am trying this slick way of doing it by the code below ( found on the web) without success so far but I got a feeling I am close to the solution. I am new to any kind of Programming. This is my first attempt. (so a chuckle or two is ok after seeing my "difficult" problem)
(This is an excel VBA Prblem)
Sub justdoit()
Dim s As Variant
[code].....
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
Is this possible? Using VB.NET.
Can I do it in the footer maybe? Would that be the best way? Bind the footer to a datatable and throw some blank rows in there?
I have a gridview in asp.net/vb and it is bound to a list - so there's no standard sorting available. I've found this jQuery plugin for sorting tables: [URL]. The plugin requires <thead> and <tbody>. The problem is, that my gridview only renders the <tbody>.
I've already tried
DataList.UseAccessibleHeader = True
DataList.HeaderRow.TableSection = TableRowSection.TableHeader
But this changes nothing.
My gridview markup:
<asp:GridView runat="server" CssClass="grid" ID="DataList" AutoGenerateColumns="False" AllowSorting="True" ClientIDMode ="Static">
<Columns>
<asp:BoundField HeaderText="SomeHeaderText" DataField="SomeDataField" />
<asp:BoundField HeaderText="SomeHeaderText" DataField="SomeDataField" DataFormatString="{0:dd.MM.yyyy}" />
[Code] .....
On my form I have 3 textboxes. They get their data from a database query. The trick is the database may return 1 result or up to 3. If the query returns only 1 result, I want the first textbox populated, 2 results, 1st and 2nd textbox populated, etc... I also want to be able to track CurrentItemChanged Event for updating purposes. My initial thought was to use a list object as the binding source but how would I cycle through the list if it returns more than one so that I can assign the values to the 2nd and 3rd textboxes or if data is entered in to a blank textbox I want the currentitemchanged
View 6 RepliesFor
Each
Item As
DataRowView In
lbOrdersNeedToBeVoided.Items
[code]....
I have a datagridview that is bound to a list object of a custom type via a BindingSource. From everything I've read, I should be able to click the column headers and the rows sort, This doesn't happen for me. Sortmode is set to automatic and the column headers aren't set to be used for selection so it should work.
I know that I could sort progamatticly but that seems a little bit of a waste given that I should just be able to do it by default.
I have a gridview that is bound to a datasource on a Windows Form (VB.NET). The grid displays a list of "certifications", and each "certification" can be associated with many languages. So in the grid, I'd like to display "languages" as a column, and display a comma delimited list of the language names for each "certification".
In the "certification" class, one of the properties is a list of "language" objects, and each "language" has an ID (guid), name (string), and value (integer).
So in the datasource, I have the list of "languages", but I can't figure out how to display them in a column on the grid. The gridview won't let me add the language list property as a column.
So is the ONLY way to add a new property on the "certification" class, which returns a string that contains the comma delimited list, and show THAT on the grid? Or is there a way to display that list of "languages"?
I am using a DataGridView bound to a BindingSource which is itself bound to a List of objects. This all works well until I remove objects from the list. If I am scrolled down to the bottom of the DataGridView and then remove a bunch of items from the list it is bound to it generates a DataError exception because the length changed and the rows I am looking at no longer exist... I changed my code to handle that error, but now instead of popping up a message it SLOWLY erases the data in each of the newly invalid rows at the end of the table (I think each time it does one it generates a new DataError, which is why it is so slow).
How do I prevent this? I want to be able to dynamically (and programmatically) add and remove items from the table without the possibility of this error... I assumed this would be handled automatically as part of the data binding process but I guess not.
I am trying to get an index of a List(Of Details) Details being a class i use instead of an annon method. Is it because i am using array.findindex when it's not an array but a list(Of???
Dim index As Integer = Array.FindIndex(Details, Details.FirstOrDefault(Function(nd) nd.Name = "name"))
Error1Data type(s) of the type parameter(s) in method 'Public Shared Function FindIndex(Of T)(array() As T, match As System.Predicate(Of T)) As Integer' cannot be inferred from these arguments. Specifying the data type(s) explicitly might correct this error.
I have dropdown list with name : list I want the first index to be the defualt value of dropdown list .
how could do I do this ?
I want to allow blanks in BOUND textboxes that are bound to int and money columns.
It's not letting me - apparently it knows to force digits...
Is there anyone who can tell me the code for the below? Receive a lower bound and an upper bound of a range. Also receive a number of random numbers to generate. You must validate
1) the numbers are integers
2) the lower bound is less than or equal to the upper bound
3) the number to generate is positive (i.e., > 0).
Generate this many numbers in the specified range and keep track of how many of each are generated in an array of counters. Once all the numbers have been generated, display in a List Box the number, the raw count data, and the percentage of how many times the number was generated displayed with two decimal places of precision.
I have a small requirement and that is as follows:
I am populating a ListBox using stored procedures and the ListBox is populated as follows:
lstItems.DisplayMember = "emp_name"
lstItems.ValueMember = "login_id"
lstItems.DataSource = accessFunction.getEmployees
The ListBox gets populated correctly. After it is populated, i have a CommandButton and on the click event of the button, i want to remove selected items from the ListBox. So in the click event of the CommandButton, i have written the following code:
lstItems.Items.Remove(lstItems.SelectedItem)
After selecting an item from the ListBox and when i click the CommandButton, i get an error as "Items collection cannot be modified when the DataSource property is set".
how i can delete items from the ListBox.
Within Control Panel -> Regional and Language Options, there is a Formats tab, with a drop down of all possible language formats. I wish to retrieve this list using VB.NET. Could anyone point in the direction of which Windows API call to use?
View 2 RepliesI have a DataGridView that is bound to a DataSet I created from a database table named Contacts. The Contacts table contains a field called StatusId. StatusId is a foreign key to a table called Status. The Status table contains StatusId and StatusName.
[Code]...
I have a main form with datagridview containing a list of contacts:
VB
Public Class Form1
Private Db As New DataClasses1DataContext
Private Sub Form1_Load
[Code]....
After saving, I get the correct message ("Saved"), and the DataGridView in the first form gets updated in real time.
But... when I take look at the data (or close and reopen the forms) the data in the database (SQL server) have not changed! What happens!
i'm developing .NET app. and using some vb6 common controlsin design mode I can create image list and attach it to toolbar control but when I'm programatically adding toolbar buttons
Toolbar.Buttons.Add(, "tbsave", "Save", MSComctlLib.ButtonStyleConstants.tbrDefault, toolbarImages.ListImages(1).Picture)
I have an ASP.Net form where I use a DropDownList control to display data retrieved from a table. However setting the SelectedValue of the DropDownList to a value not existing in the dropdown list does not trigger an exception.
[Code]....
I want it so every time I click an ITEM in the Listbox it displays ALL the data into the textbox. I know there's an easy way using table adapters and binding the listbox, but I'd prefer to do it this way for my project.
So this is what I got.
Lst.DataSource = ds
Lst.DisplayMember = "tblStudent.FirstName"
Lst.ValueMember = "tblStudent.StudentID"
[code]....
It only adds the first rows details to the text box when I click the second record the first rows details are still there.
Does anyone know how to get my class name and method name dropdown lists again? It's the dropdown lists that are usually above the code. It's just a setting but i can't seem to find it. I don't want to reset my setting btw. I shouldn't have to.
View 2 RepliesThere is something strange going on with my datagridview.
I've a data adapter that fills the underlying data table from a database. Then I assign this datatable as datasource to the datagridview Then I add a row to the datagridview and immediately I need to update the table in my database (as soon as user leaves the newly created row).
At this moment I have more rows (+2, not +1) in my datagridview than in the underlying datatable (the new row doesn't exists yet in it so the data adapter .Update method doesn't write anything to the database).
When DataGridView's .RowLeave event fires the undelying datatable is not yet updated. I've a question - is this behavior normal?
My teacher as asked me to allow a user to input three pieces of information about a DVD (the ID, the title and the running time) and for the program to add that data to a sequential file. My textbook fails to explain it and I am at a loss as to where my book from last semester is located at the moment.
1. What is a sequential file?
2. How do I display information from it into a messge box?
I need help and wondering if you can help me to get my first project...it's a hobby and wondering if you can get me code for this so i can see how it does it* Evaluate( ) Prints the evaluation of the hand to the evaluation Label.
o If IsFlush( ), prints "flush; "
o calls SetPipArray( )
o Uses a For Loop to go through pipArray. For each element, uses a Select Case statement to
[code]....
First... does the array subscript have to be sequential? (0,1,2,3,4) Or could I pull the system date and use that? i.e. dim Beer() could have Beer(33939) for today, and then not record anything for three weeks and the next entry would be Beer(33960), etc.Along the same lines, and pointless if the answer above is yes...I'm writing a prog to handle inventory for a bar. The bar has 230 different beers at the moment. Could I create a 2-dimensional array using a product number, date for the subscript?
i.e. - for received data... recBeer(a,b)recBeer(229,33939) = 48(Meaning 48 bottles of beer #229 arrived on date 33939)SO... a is the product, b is the date. Any searches for (229,*) would provide me with the complete history of that product being received. any searches for (*,33939) would tell me all of what was received on that date.Will that work?(And yes, I'm stuck with a flat file to make this work. Much rather have a db involved.)
i am coding an application where I want to populate an array with the contents of a sequential file that is already populated as salary.txt in the debug folder. Basically, I want to copy the contents of that file to an array so that I may use a code to go with the intSubscript of the array. Right now it functions as just an array for this purpose, but I want to populate the array with the sequential file first. All attempts to do this, with stream writer etc and readline, I am just getting the first item in the file. I have tried to loop it and still only the first is accessable. Driving me batty, turning to the masses for guidence.[code]
View 1 RepliesI have a working piece of code that checks that 4 out of 5 random numbers are in sequence. The numbers correspond to 5 dice rolls. I'm trying to learn VB and I think the code can be improved since it's so cumbersome. The sub checks to see if any of the numbers are duplicated and reassigns one of the duplicates to an arbitrary "11" which is outside of the 1-6 range of a single dice roll. Then the values are inserted in an array and sorted and the sequence check takes place. score of 30 is assigned if 4 of 5 of the (sorted) numbers are in order. If not in order, a score of 0 is set.
Code follows:
Private Sub OtherScores4()
'Check if any of the rolls are duplicated and reset one of the die to arbitrary "11".
If Dice1 = Dice2 Then
Dice1 = 11
End If
If Dice1 = Dice3 Then
Dice1 = 11
[Code] .....
