I want create a datatable .In this datatable 2 coloums are percentage and marks I want to show the maximum percentage record display on first and simultaneosly another racord ?Thats why i take a dataview but dataview could not sort the datatable
exam.
Dim view As DataView = dt.DefaultView
view.Sort = "clm_percentage DESC"
dgvStudInfo.DataSource = view
I want create a datatable .In this datatable 2 coloums are percentage and marks .I want to show the maximum percentage record display on first and simultaneosly another racord ?Thats why i take a dataview but dataview could not sort the datatable exam.
Dim view As DataView = dt.DefaultView
view.Sort = "clm_percentage DESC"
dgvStudInfo.DataSource = view
If want to do a DataView.Find on a DataTable that is already 'ORDERED' by the Column I am seaching, so a DataView.SORT should not be necessary, but it throws an Exception if I don't give a .sort command before the .find command. Is there any way to avoid this apparant duplication ? and speed up the search time. Its a very large table - 1 million rows. I am using VB 2010
View 6 RepliesI got a problem with dataview that get data from datatabel (Col1 : ID,Col2: Time) and I'm sorting by Time in desc ... when the values for example {40.21,80.21,70.25,25.2} the dataview sorting them as I need but when one of values goes above 100 for example {40.21,80.21,100.25,25.2} the dataview always sort the highest number is the buttom, I don't know why ..
This is a sample code
Dim dt As New DataTable
dt.Columns.Add("ID")
dt.Columns.Add("Time")
[CODE]...
I want display database value in datagridview 2 coloum ..how to may i bind the dataexmp:- Suppose in Database 100Dr,200Cr i want in datagrdview 1st coloum 100Dr & Second coloum 200Cr............
View 7 RepliesI am sorting a dataview by a date/time stamp. As of right now it is sorting it oldest to newest. How might I write it to write from newest to oldest?
[code]...
I have a page which lists all the files in a particular folder (all PDFs), using a data-table and gridview. I'm currently sorting this table by the filename (by using a dataview), which isn't that helpful, and I want the gridview of files sorted by the file created or file modified date (as recorded in Windows). If that's not possible, a second option would be to extract the date from the file name string (no problem doing that), and sort the dataview/datatable or gridview based on that.
[Code]...
I have a datagridveiw combo box with a few values in there. I am trying to capture what user clicked. I tried CellValueChanged, CellContentClicked etc. but nothing works.I want to store this value to a variable (important) and then shift the cursor to Column after user has selected value.
View 4 RepliesI'm using visual basic 2008 express I have 1 combobox which is populated from a coloum from my database, when I select a value from the combobox I wish to populate several textboxes with data from the row selected. I have created a dataset. How can I do this? Is there a tutorial I can read anywhere
View 2 RepliesSomewhile back I got into the habit of manually line numbering my routines (in access) - yes just like it was in the 80's ... :)Only because it's seriously helpful in error trapping where reference to specific line numbers pops up in my trapping routine. (as a comment I am surprised by the number of apparent learned folk who ask the question why one numbers lines !!)I am now Fed up with doing it manually
View 3 Repliesin richtextbox i can set the bullet like this
rtbMainBox.SelectionBullet = True
how about the numbering?
This question was there about 8 years ago, now I'm having the same problem with Urmel and still there couldn't be whenever I load data into my DataGrid (RowHeadersVisble=True), the RowHeaderCells are empty but the selected one that has an arrow. Is there a way to show the RowNumber instead of nothing or the arrow?
View 2 RepliesHow do I make my numbering in RecordNumber1 tool in CrystalReport1Starts from 1 to 10 and then repeat from 1 to 10 and so on to the last
View 1 Repliesnumbering rows in datagrid. I have a column that should number 1,2,3 so on when adding a new row. When I delete a row, those numbers should re-number still to 1,2,3. So when I delete row 2, the row that's been added as 3 should now number to 2. Then when I add new rows, these should re-number again, and so on..
My code:
'when adding a new row
Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click
[Code].....
My problem is with the for loop when deleting a row.
I have a listbox2 and it is bound to my ms access database. I want to number them using listbox1. Example
[Code]...
** the listbox1 must automatically number the items depending on how many items inside the listbox2. -I already know that i can make it by creating autonumber in ms access, for certain reasons i cant do that.
I want to calculate variance of a col in my datatable object. If i apply datatable.compute(Var(...)), i gives a negative result. Variance can't be negative. And it I just apply it to half of the data, it works fine. Does datatable.compute has a limited capacity?
View 7 RepliesI conected my access database with the form and I need the code to count how much entries are in the database and increase that number by one, and then to write that number in one textbox so that when I press save in the form the entry would have that numbar as id.
View 7 Repliesi am creating a tabbed text editor. i want to create a line numbering on a richtextbox but i cant figure it out. In the design time, The only control is the tabcontrol1. and in when the form loads, the tabpage and the richtextbox is created through
Private Sub AddTab(Optional ByVal file As String = Nothing)
NewRTB.AllowDrop = True
NewTab.AllowDrop = True
[code]....
I have two RichTextBox's; rtb1 and rtb2. I want to convert the contents of rtb1 to rtb2, but add a number at the start of each line.
So from:
[v]hello[/v]
[v]goodbye[/v]
To:
1. [v]hello[/v]
2. [v]goodbye[/v]
VB.NET
Private Sub btnProduce_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnProduce.Click
Dim List As String = rtb1.Text
If (chkPrefix.Checked = True) Then
List = Replace(List, "[v]", ". [v]")
End If
'Display new list
rtb2.Text = List
End Sub
i have made an invoice that is printed the total amount of things bought but still i have a problem of making it such that at each time i print i prin each invoice numbers itself as the following one.
View 2 Replieshow to open an excel file and number the rows. The xls file is just a simple 2 column file with 5000 or so part numbers in column B. I need to open it, add numbering to the rows in column A ranging 0 thru 9, then start over at zero again.
i.e.
0
1
2
[Code]....
I am using the vb 2005 to create an application and I created a database from the vb by adding a new Item (Database). I want to know how can I make the id which is a number, to take an auto number and not to have to enter it with my insert statement. I know in oracle I use a sequence and in access I use Auto Number as a type for the field, I want something like this here.
View 2 RepliesHow to delete repeated and numbering words from the text?
For example:
* in red: Words / numbers repeated
* my textbox:
" test1 test1 bb what how bb so and then yes so then so 1 3 1 4"
to get this result:
*in green: The number of times the word / number show in the text
so (3)
then (2)
1 (2)
Test1 (2)
bb (2)
what (1)
how (1)
When I add a new row to an access database, I would like the primary key to be automatically incremented and entered. I've got this to work using a sql database, but it doesn't work with access for some reason. The following code works if I give the code a value for "@key" which is my primary key column. If I leave it out I get the error "Number of query values and destination fields are not the same". I don't want to have to supply the primary key, I want it to generate automatically.
[Code]...
In the database the primary key is type "AutoNumber". Does anyone know what I'm doing wrong?
Following on from my last question, are the AssemblyMajorVersion, AssemblyMinorVersion,AssemblyRevisionNumber and GenerateRevisionNumber properties required in .vbproj files?
All of our components have these entries in the .vbproj files but they are completely out of sync with the AssemblyVersion and AssemblyFileVersion entries in the AssemblyInfo.vb files.
Are they a legacy from the upgrade from previous VS versions?
How can I improve this bit below to make the items in the TreeView to sort faster or something totally different to sort them easier?
[Code]...
I have a MyObject; myObjects as List(Of MyObject) and a delegate Comparison(Of MyObject) that uses a lot of comparison functions (ByA, ByB, ByC etc) Ã la:
Shared Function CompareMyObjectsByName(x As MyObject, y As MyObject) As Integer
Return x.Name.CompareTo(y.Name)
End Function
[Code].....
Sub Sort()
ReDim RollsCC(NumOfPlayers - 1)
For N As Integer = 0 To (NumOfPlayers - 1)[code]....
Here I am creating a temp single dimensional array, merging my 2d array into it, and then attempting to sort it by Rolls(N,1), which is a integer 1-6, Everything seems to be working right with the exception of this.
RollsCC.Sort(RollsCC, 0, 1)
How would one specify a numeral sort based on the first character in the string? im aware that I am switching Rolls(n,1) and Rolls(n,0) information during the sort.
Currently my ListView sorts items by image.index. So 0 is at the top, then 1, 2 and so on. Think of it as an IRC chat room nick list. Ops at top then the rest are sorted alphabetically
[Code]....
i am trying to add several rows to a dataview before bindng it to the datagridview. I have tried several variations of the below code but only the last row will actuall load into the grid. Probably doing something stupid.
My code is:
dvInspectDetail.AllowNew = True
Dim newRow1 As DataRowView = dvInspectDetail.AddNew
newRow1("IDetail") = mDetailNo.ToString
[Code].....