I'm having problem in my datagridview.I'm using vb 2008 and an access database. When I create a new record for my item the No column (primary key and autonumber in access) always shows a negative number.How can I make that a positive number and it should follow the numbering in the datagridview.
View 3 Replies
I am calling the function below from an Excel spreadsheet and the conversion from hex to decimal using the VAL function in the "manufacturer" variable below is coming back with a negative value. The VBA edition is 6.5.
Public Function decMEID(ByVal sKey As String) As String
Dim manufacturer As String
Dim serial As String
[code].....
i have a negative number and i want to change it to its positive
eg -14 to 14
I need to check a value and make sure that it is not a negative number using a try catch statement I keep getting an error saying that I have to use a method.
Try
TotalCurrentBalance < 0
Catch ex As Exception
End Try
I wouldn't put a if statement would I? I am thinking that would defeat the purpose.
Is there a built-in function in .NET (VB) to convert a negative number into a positive, and vice-versa?I usually end up just using:NegNum = PosNu - (PosNum * 2)PosNum = NegNum- (NegNum * 2)
View 6 RepliesI have written a code that when the click the calculation the button a inputbox pop up and you enter in the income and then you enter in the expense. [code]...
View 11 RepliesI asked a question earlier about comparing numbers using the "And" comparison operator in If Statements and now I have been toying around with getting my head wrapped around bitwise operators. So I have written a very basic code that will allow me to see the conversion of any decimal number in binary format.[code]Notice here that I am using SByte as the paramerter - which should only contain 8 bits right? However, the message box that appears has 16 bits assigned to negative numbers.
View 1 RepliesHow can I insert a negative number into a byte parameter?
Something like this:
Dim b As Byte = -111
My problem is with the following API.
Private Declare Function GetKeyState Lib "user32" (ByVal keyCode As Integer) As Integer In Windows XP, I could simply use the API like this: If GetKeyState(Keys.Left) < 0 Then 'Move Left If the key was pressed, it was a certain number below 0, the number itself alternated each time you pressed the key but it was always below 0.
My problem is that in Windows 7, when you press the Left key, the number isn't the same, in fact the number isn't even negative anymore. This problem tricked me at first into thinking the API didn't even work as when I ran the .exe of course my code did nothing since GetKeyState never returned a number below 0. I tested the value itself though and found that it never goes negative, the number for the key just decreases a little.
The weird thing is, while the .exe from the Debug folder proved my point that the GetKeyState number was different and thus the program didn't work, running the .exe from the Release folder actually worked, the controls were fine and the API returned numbers less than 0 for GetKeyState. But the .exe from the release folder was built with my old XP computer, as soon as I made a new build with my windows 7 computer the API stopped working again.
Why did Windows 7 change the number returned for when the key is down, is there a way to change it back without having to include some large package with my program? Why did the build from my XP computer work at first? Also it was only the one from the release folder, not the debug one, even though they were both from the XP computer.
I tested some more on windows 7 and found that every time I run the program, the number returned by GetKeyState is completely different. When the key is down the number is 1,000,000 units higher than up, but other than that the number is random each program start.
I got a Mysql sql database for my project. The id field is set as auto increment, which seems to function correctly. But on the form in my text field and datagrid i see a negative number, while in the database its a postitive number. I do not really plan to use the id field right now, but when i do it might cause some problems.
Anybody know why it would show as a negative number on the form(textbox/gridview) and as a positive in the actual database?
Is it possible in an datagridview to use different formatting for negative, positive and zerovalues?I want to show positive numbers in black, negative numbers in red, and zero-values hidden.
View 2 RepliesWhy when I add new item in my database table it will show negative increment?
how can i change it to positive increment or use only integer increment.
I get an error on the last line of sub where I am trying to assign a combobox to a column which is a textbox.error:Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index[code]....
View 3 RepliesI have temp2 value -52340.0 and hslColor.Luminosity is 240.0 When Dim temp1 As Double = (hslColor.Luminosity - temp2). It shoud give -ve number but I am getting always positive number. results should nbe -52100, but I am getting +52100. How to handle this?
View 4 RepliesI 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].....
I have a txtbox(for barcode).. if i input a item number in that txtbox and if that number will match in your database, the other information(shall we say, product type, item ID, etc..) will display in my other txtboxes..
View 5 RepliesI have an existing database that I want to add a number to that the user inputs. So lets say that in the database there is 4 carrots, and the user on the addinventoryform inputs 3 carrots and pushes a button. Now I want that number to be added to the database number so in the database there would now be seven carrots. I am using an oledb connection and cannot figure this out.
View 1 Repliesi want a button to perform a function of checking the last digit number in a field of a table in and add a digit to it and display it in a textbox.
View 1 RepliesHow do you get row number DataGridView cell? Specifically, if a user has selected a single cell, how can you get that row number? It needs to access a particular cell based on what the user has selected.
I know that the RemoveAt method can be used to remove at the Focus, but you cannot get the row number at focus apparently?
If using a datagridview to update a database and the datagridview is bound to a bindingsource which has its datasource as the table to be updated: where dshould you place the tableadapter.update(mydatarow)
View 5 RepliesI had the following code :
Dim row As Integer = 0
For row = 0 To pdgvDataGridView.RowCount - 1
pdgvDataGridView.Rows(row).Cells(0).Value = row + 1
Next
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.
Is it possible to number the rows in DataGridView ( does this property exist)?
When I load the data from the database to DataGridView I want to show thenumbers of row. like this
0
1
2
3
.
I should move in first position rows that begin with My_Number, but my Datagrid_comb is binding. So I have try this:
[Code]....
OS: 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 the following code. When I use:
For i = 3 To MaxColumnDataGridView
DataGridView.Columns(i).DefaultCellStyle.NullValue = 0
DataGridView.Columns(i).DefaultCellStyle.Format = "N5"
Next
The columns format can't be changed. I cannot change the number format whatever I do.
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 have an inconsistency in behaviour when I try to get the CurrentRow after a row has been selected.
If I select the first row in a DataGridView object using the mouse, the DataGridView1.SelectionChanged event fires, and DataGridView1.CurrentRow is the newly selected row (Row 0).
If I select the first row via code however ie. DataGridView1.CurrentCell = DataGridView.Rows(0).Cells(0) then the DataGridView1.SelectionChanged also fires, but CurrentRow is the old row, not the new row.
In fact CurrentRow doesn't get updated until AFTER the SelectionChanged event has fired if you force the row change in the code, but is updated BEFORE SelectionChanged if you do the row change via the mouse or keyboard.
how to check if its the first row if I've moved to the first row using CurrentCell ?
I'm using access as my database and vb .net 2008.My problem is i change a field into 2 ecimal places and when i debug my program why my data in the datagridview not a 2 decimalExample : in access TotalCost = 200.00in vb form datagridview TotalCost = 200
View 1 RepliesI have 1000 records in DatagridView. I want to Display only 500 records in datagridview. I will put a button and a TextBox, and Enter 500 in TextBox, It should show 500 Records. How to Do?
View 10 RepliesI have a DataGridView that is showing some weird numerical data. For example, my under lying datatable of the datagridview has 4.69, but the datagridview shows 4.6899999999999999995. What is weird is it doesn't do it for every cell in the column. For example, my underlying datatable has 2.66 and the datagridview cell shows 2.66, which is correct. I should note that the underlying datatable column that contains the numbers is of floating point data type which comes from the database column and the datagridview column is TextBox. Here is what the values look like in the database, underlying datatable and datagridview.
View 5 Replies
