When put in ComboBox a number,and click on button Find, I want the DataGridView to show all the numbers that are smaller than the one I put in Combobox
View 5 RepliesSQL statements:
SQL = "SHOW TABLES;"
Try
conn.Open()
The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.
A datagridview is sorting numerical values (when clicking the datagridview column header text) in the wrong order based on the initial digit:
[Code]....
How do you refresh a datagridview in code to show to show new data in the DB?
View 3 RepliesI'm taking VB at the college right now and we are studying Select Case Statements. What I need to do is type in a number in a text box and make it equal into a label so when i press my button the numbers I type in the text box appear in their letter forms. Here is my code so far:
lblNumber.Text = ""
Dim intA As Integer = CInt(txtBox.Text)
Select Case intA
[Code]....
I got it to work with the smaller numbers, I just don't know how I would make it so that if I type in a big number it would show all the numbers instead of just one.
For this assigment i need to show the numbers from 1 to 10 then 10 to 1 then the even numbers from 2 to 20 then the even numbers from 20 to 2 My problem is that it works fine till it gets to the even numbers. It won't exit the 2nd loop so it gets stucked in the 10-9-8-7... It all has to be in one button.
[Code]...
i have this code:
For i As Integer = 0 To 9
For ii As Integer = 0 To 9
For iii As Integer = 0 To 9
[Code]...
it must find all numbers that are faculty between 0 to 999
What do I use for the format number function to show a - for negative numbers instead of ()?
View 2 RepliesI need to format a Label to show numbers in a certain way. I had asked this before about textboxes so I looked into that first but it didn't do what I wanted.
[Code]...
Write a program that asks a quiz show contestant to select one of the numbers 1,2, or 3 and then calls a Sub procedure that asks the question having that number and requests the answer. The Sub procedure should then call another Sub procedure to tell the contestant if the answer is correct. Use the following questions:1. Who was the only living artist to have his work displayed in the Grand Gallery of the Louvre?2. Who said, "Computers are useless. They can only give you answers."?3. By what name is Pablo Blasio better known?This is what I have so far (with errors):
[Code]...
I have a problem which is that Class Big integer Doing a miscalculation
For example: -
5 / 2 = 2.5
With Class
5 / 2 = 2
I want to do to show the numbers after the decimal point (.5)
Is it possible to use variables instead of the numbers in Label1.show() command?
For example: Label(counter).show()?
I want to know the codes to show numbers one by one continuously from 1 to 20 on clicking a button, and it should keep on doing it till a Button is clicked.I know how to get a Random number to for it but I don't know how to do for numbers in normal order .
View 11 RepliesIm trying to do a lab that will obtain 10 numbers from the user using an InputBox() function, store them internally in a one-dimensional array, and then compute the average of the numbers and sort them in reverse numerical order. The program should control that 10 numbers (no more, no less) are entered, and that the numbers are fully validated as integers.
If the user enters non-numeric data, then an appropriate error message should be shown, and that number should be allowed to be re-entered as a valid number. Then all the numbers should be shown as a list in a 'message box'. So far I can get everything but the message box to show the list of numbers entered.
[Code]...
I have three Buttons labled "Single" "Double" and "Triple" and four textboxes, one for each button and one to display the results. Here is how it works. Each time I click on one of the buttons, it increments itself by that number...for example if I click on Button with the word "Triple" on it I will get the result '3' in the adjoining textbox. If I click it again the number will change to '6'. This holds true for all the buttons. I have this part of the program working well. there a way to have the addition of all these numbers appear in the fourth textbox WITHOUT having to use another button. In other words I want the fourth textbox to constantly update as I'm pushing buttons.
View 2 Replieswith the code to my form on week numbers. below is what i have on my form code at the monent. and where the text in green is
View 11 RepliesBasically what I am making is a form with just one button and 2 text boxes. The purpose of it is that when I click the button 2 random PRIME numbers between 100-999 will show up in the boxes. With my code I have now, the numbers that show up in the boxes aren't always Prime.
My current Code is.......
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Randomize()
Dim p, q, i, j As Integer
[Code] .....
I have just found that if a DataGridView image column's size (height & width - in pixels) is smaller than the image's original size (in my case all images are exactly 180 x 180 pixels) at the time the cell is populated then the image is automatically being converted to a lower resolution I assume to fit the image completely within the size of the cell). How can I stop the automatic scaling of the image?
The image below show the same file displayed twice, both at 60x60 pixels ('Thumbnail' column) and a blowup of the image (PictureBox populated via the CellMouseEnter event) to it's right. You'll notice the resolution of the first blowup is far less the the second. so, what made the difference in the resolution of the blowups is? In the second blowup's case I'd first stretched the image column's width to ~180 pixels and set the row height to match (via the ColumnWidthChanged event) then populated the DataGridView then stretched the image column to 60 pixels (its minimum).
I have a datagridview named Partcotdatagridview. In this datagridview, I have two columns. The first column has a combo box with some names in the data source such as John, David, Alex. The second column is designated for amounts. Each person will have different entries in the datagrid I will select a name and enter an amount for that person. I would like to display the total for each person in 3 different labels in a different form.
View 20 RepliesI have a datagridview with a column called "Total Price". This is set to a string value type because I need to always show 2 decimals. For example:
4,3
must be in the datagridviewcolumn:
4,30
So I use string.format for this. However, now I have a problem with sorting because the column is a string value type and numbers get sorted like this:
50
4000
40
300
30
20
10000
1
How to override the sort method or something that is called when a user clicks on the column header and the most effective way to sort it programmatically?
I have a DataGridView1 where I have 6 columns and 0 rows (they are added additionaly in the application) and also have a TextBox1. How can I calculate all data from the second column to the TextBox1? For example, I'll run the application and add rows, where the text in the second column will be: (4, 8, 9, 1)... it means 4 rows...
So how can I make the value of those numbers (22) show in the TextBox1, so that it will calculate the numbers and show the sum in the TextBox1?
I can not column 4 of my Datagridview1 to display numbers as ###,###,### with not decimal places it seems stuck in Scientific notation mode, even though I have set it several different ways in the menus.How do I set it in the program like I set the column width.
DataGridView1.Columns(2).Width = 80This is in VB ExpressGary
I'm making an app with several forms and wanted to add a label to each form that, when double clicked, would resize the form to 10 x 10 pixels.
ControlBox, MaximizeBox, MinimizeBox, properties are set to false so there is no title bar. No text or icon. MinimumSize is set to 0,0.
I made a new project that consists of one form with one label to make sure there was nothing in my code causing the problem but still every time I double click the label the form is resized to 27 pixels high by 112 wide.
The exe can call functions and forms in the dll's that are part of the solution BUT is there anyway
for the dll's to access forms, dataset's etc in the main exe project?
It doesnt appear that it works that way.
I forgot to add this is a VS2005 application.
How about a Nibble etc.
View 3 RepliesDoes anyone know if it's possible to have a tab page, on a tab control, with a smaller area than other tab pages on the tab control.
For example, if the small tab was in focus, the contents of the tab behind would be visible.
I have tried the tab page size properties, this doesn't work.
i made a webpage with a drop down list...so when i click on the drop down list and click on the item there, a box will pop out i dont want the browser box to be the standard maximize internet explorer browser size or standard minimize internet explorer browser size...i want it to be in a A9 or A10 paper size the moment I select an item and it pops out...
View 5 Repliesi have a DatagridView, with a Colum " KG".Into the Colum, i place numbers.Now i wants a total of all numbers, place into a TextBox, using a code.
View 15 RepliesI have a large file (2.7GB). I need to split it into smaller files. How to split a large file into smaller files using VB.NET 2003? Cannot use LINQ and the resources (cpu and memory) on operating environment are very limited (it is a shared hosting environment).
View 1 RepliesI am trying to take a png file (around 2000 x 2400) and split it into 8 smaller images of 500 x 1250 each (2 rows of 4), each of which is saved as a png file. I then which to display these smaller png files in a picture box so that they look as if they were one image.
My problem is that when I display the png files in the picture box, lines that look like grid lines show up in the picture box at the points where the png files sit next to each other.
When I view the smaller png files in Paint it appears as if the left column (x=0)and top row (y=0) of each file is set to clear (or transparent). What shows up in the picture box is the background colour of the picture box.
This clear/transparent row and column are not added on to size of the smaller png files. They are still 500 x 1250.Not every file is affected. If the smaller files are created from the original bitmap in the following order[code]...