Is it possible to do the following rounding scheme?
36 = 40
37 = 40
38 = 40
[Code]...
I guess what I'm asking is if there's a way to find the value of the number in the ones column and tens column.
search a dataset table and search a column within that table for a value than if the value is true in the column find out which row number it was on
View 7 RepliesHow to create a function to find the largest value(subitem) within a listview column
View 11 RepliesHow do I find Line 40 and column 89 in my code. I get the following error message.Error 1 Handles clause requires a WithEvents variable defined in the containing type or one of its base types. Line 40 column 89.
View 1 RepliesHow do I find Line 40 and column 89 in my code. I get the following error message. Error 1 Handles clause requires a WithEvents variable defined in the containing type or one of its base types. Line 40 column 89.
View 2 Repliesi'm trying to get my program to look up a string and find a match in an access database in column "PhoneNumber" and return the value from column "FullName" on the same row to a different string
so it would go like this: (i really don't know much about accessing databases)
Dim PhoneNumber As String
Dim FullName As String
PhoneNumber = TextBox1.Text
FullName =
I wrote a function to format numbers like this: 123456100,12 -> 123.456.100,12 (I have a function too, which converts numbers from this strings).Now, I have a dgv and a column with these numbers (or rather strings). The sort mode is set to automatic. If I sort the column, it doesn't work, because the values are not really numbers, but strings. But I get the same result (the sorting doesn't work), if I use the formatnumber function (this returns strings too).
I could use the programmatic sort mode and before sorting I format the strings to numbers, then sort the column, and then format the numbers like above. But this is a bit slow (the dgv has appr. 800 rows), and in this case, I haven't an arrow next to the column header text.is it possible to sort the column like a normal number-column with automatic sortmode?
How i can make random number with tens with function Random. If i make Random.Next(0, 500) then it gives me any number from 0 to 500. But how i can make that it gives me not any but tens. Something like: 10, 50, 480, 370 Only tens not any number?
View 4 RepliesHow to add a checkbox column at first column of datagridview including column header?After adding, how to code to "check all" or "uncheck all"?
View 27 RepliesI have been trying to find the last filled column row in a sheet using this.
clast = xlapp.ActiveSheet.Cells.Find("*", SearchOrder:=XlSearchOrder.xlByColumns, SearchDirection:=XlSearchDirection.xlPrevious).Column
rlast = xlapp.ActiveSheet.Cells.Find("*", SearchOrder:=XlSearchOrder.xlByColumns, SearchDirection:=XlSearchDirection.xlPrevious).Row
I'm doing a notepad project, just because, and in Ms's notepad there is an option for a statusstrip. I'm just having probems getting the line number and I know it's not called column number, more like selection start. When I do the selection start, it works, just not how I want it to like so:
[CODE...]
but when I use that, it acts funny. I have it in my textbox's.keydown event. So if I were to use the arrow keys to navigate around text then it gets thrown off very easily. How would I do this?
I have two text files, the first text file has two columns separated by a space (" ") and the second text file only has one column.
The column 1 in text file 1 and text file 2 match albeit in different order, what I'm trying to achieve is for every field in column 1 text file 2 I want to search for column 1 in text file 1 and display the matching column 2 field in column 2 text file 2.
Dim*OpenTextFile*As*String*= IO.Path.Combine("C:Test1.txt")
Dim*OpenTextFile2*As*String*= IO.Path.Combine("C:Test2.txt")
Dim*SaveTextFile*As*String*= IO.Path.Combine("C:Test2.txt")
[code]....
I have this sort of problem whenever the datatable has an empty cell,it shows cannot find column 6 or depending on the number of the datatable column cell.
View 2 RepliesI want to find the max value inside of a column. I tried to create an array where I store all the values from the column but it doesn't really work as I don't know the length of my array.
View 1 RepliesI have a text file lines like this[code]...
I want to split the line accrding to T,C,F,Sand H and load the value in unbound datagridview.[code]...
I need to find rows in resultsets that have every column without null.these resultsets got variable number of columns.currently, the only way that I can think of is creating a view on each resultset and filter this way:
select field1, field2, field3, field4, ...
from "huge query"
where field1 is not null and
field2 is not null and
[code]....
and then in a storeproc/function or .net code(c# / vb.net) loop through all rows / columns and flag or remove every row that got any null?
I have a Dynamic DataTable Created at runtime. The Setup is like so
Id | Name | Age
-----------------
3 | Mike | 21
6 | John | 43
8 | Sara | 34
What I am trying to do is come up with a linq statement I could use to find and update specific rows.
Such as a statement to change AGE to '33' WHERE ID = '3'
My code So far is:
-[VB.NET]-
Dim MyRow As DataRow = From column In MyTable.Rows Where column("Id") = 3
MyRow(0)("Age") = 33
But this is not updating my DataTable entry.
I have this code that searches a document for a word. When it's found I want it to print what's on column 3 in the same row as the word it found. Can this be done?
View 3 RepliesOS: windows 7 64-bit /Programming Language: Visual Basic.net on Visual Studio 2010 express edition.I have dataset with 4 tables each one of them is a datasource to a datagridview I want to add a serial number column to the datagridview so I made this
DataGridView1.Columns.Add("serial", "SER.")
For x As Integer = 0 To (ds.Tables("workers").Rows.Count - 1)
DataGridView1("serial", x).Value = (x + 1)
Next
It was working fine untill I added a relationship to the dataset the relationships codes were
Dim relation_WC As New DataRelation("relation_WC", ds.Tables("workers").Columns("id"), ds.Tables("cources_jun").Columns("workerid"))
Dim relation_WV As New DataRelation("relation_WV", ds.Tables("workers").Columns("id"), ds.Tables("vacations_jun").Columns("workerid"))
[code]....
I breaked point the debuging and I found that the serial number column I added is fine and has it's values, but when I reach the line relations.add(the_relation) the serial number column loses it's values and turn into an empty column with no
numbers in it....why this is happening?
Note: I added another relations but the only relations that clear the serial number column are the relations that has a datatable that is a datasource to the datagridview that has the serial number column.
I have 4 Columns in a ListView. The first one is called Serial No. Every time I populate it, the serial number increases automatically. After populating the ListView couple of times, I select any row(s) and remove it. When I remove one or more row(s) from the listview, serial numbers stays same. I want the serial numbers to be fixed automatically when I remove any number of row(s). How can I do that ??? Here is my code -
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Str(4) As String
Dim newItm As ListViewItem[code]....
I'm using vb.net and a DGV to open a access DB. On load im filtering out everything except what was created on the current date. [code]...
View 1 RepliesI 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.
I had the following code :
Dim row As Integer = 0 For row = 0 To pdgvDataGridView.RowCount - 1 pdgvDataGridView.Rows(row).Cells(0).Value = row + 1Next
it's to add auto number into first column of each row. The codes running well, but after the codes completed, the first column of each row remain empty.
I am using VB.NET to query via SQL an Excel spreadsheet using ADO. The general way is like this: SELECT [firstname], [secondname] FROM [Sheet1$] Which works perfectly
However, one of the headings is called 3, so I want to do: SELECT [firstname], [secondname], [3] FROM [Sheet1$] However, this does not work. I know I can use * to get all columns, but later on I want to use (using dataReader): dr("3") which won't work
I have a text and numeric data in a column of excel. data is 1,2,3,A,B,C,D,10,11,12. I want to do sort these by SQL. and i want get data in below order 1,2,3,10,11,12,A,B,C,D.
View 1 RepliesI'm making my own ID field (highest number + 1) and using it when I insert a row into my tableadapter, and I've tried two ways...
Ordering my dataset by ID descending and picking the first row does nothing for me.
I've tried building a datatable and ordering it descending and choosing the first row. This works great until you get to 10... Then it counts 1, 10, 2, 3, 4...
How can I make a textbox, label, etc be the next ascending number in my column Highest Number + 1?
Hi, Is there any way to check which row of the value(any of the Column) is empty and get the row number??
View 4 RepliesAdd persistence to multible DataGridView in terms of Hide/Show column and column width
View 1 RepliesVB GridView control will not allow code in the vb code file to access a data column that has its visible property set to false. When it is set to true, the data column can be accessed with no problem. Any suggestions as to how to correct this? I have looked through the documentation, text books, and I have not found anything that gave me any clue as to what the problem could be. I thought that the property was just applied to the column, not that it would remove the column from being accessible.
[Code]...
I have a datagridview and the user wishes to key some text in a text box and press a find button.The text to be looked for could exist in any columns in the grid (I want to exclude hidden columns).The search is to start at the row the user is currently at. If it gets to the bottom of the grid and still not found the the search would start from the first row of data.
If a match is found then the row with a matching value is to be highlighted.I've looked at using the position and find properties of my binding source but I think this will only let me find on one column and only from the top?Do I need to programmatically loop through the rows in the datagridview and search for the text or may there be a better method?