SqlServer Table1 has data as follows
Sno-------date
1------01/01/2010
8------01/01/2010
1------02/01/2010
[Code]....
1) I want to display the SMALLEST Date into textbox1 which is 01/01/2010
2) I want to display the BIGGEST Date into textbox2 which is 18/01/2010
3) I want to display the BIGGEST SNO against date 18/01/2010 into textbox3 which is 9
4) I want to display total records against date 18/01/2010 into textbox4 which is 3
SqlServer Table1 has data as follows
Sno-------date
1------01/01/2010
8------01/01/2010
1------02/01/2010
5------02/01/2010
2------18/01/2010
9------18/01/2010
3------18/01/2010
1------03/01/2010
6------03/01/2010
My questions are:
1) I want to display the SMALLEST Date into textbox1 which is 01/01/2010
2) I want to display the BIGGEST Date into textbox2 which is 18/01/2010
3) I want to display the BIGGEST SNO against date 18/01/2010 into textbox3 which is 9
4) I want to display total records against date 18/01/2010 into textbox4 which is 3
i am working on this exercise where i have to find suburbs with minimum and maximum percentage POS (public open space).i manage to get the minimum and maximum but i need a way to allow for two or more suburbs with same minimum or maximum..for example three subrubs ( suburb A, suburb B, and suburb C) all has same POS of 2%, then i need to list the three in the list box as minimum with subrub name(from my code i can get only one) with the maximum values as well( allow two or more suburbs with same maximum in a similar way)..below is the code.. i have removed some codes to make it read easy whi are not relevant.. i got POS percentage correct and i wanna start from there..
For intSuburb = 1 To pFClass1.FeatureCount(Nothing)
'SOME CODE HERE(this bit is long and is not relevant)..............
dblPOSPercent = CDbl(Format$(((dblSumPOSArea / dblSuburbArea) * 100), "###.#0"))[code]......
I'm attempting to invoke with parameters:[code]Value of '415' is not valid for 'Value'. 'Value' should be between 'minimum' and 'maximum'.Parameter name: Value..What does this mean? Is there a way around it?
View 2 RepliesI've had a look around, once again and can't find how to set the minimum and maximum dates allowed to be selected on a calendar in ASP.net with VB.
I'm using Visual Studio 2010 and it's just a regular Calendar control at the moment...
At the moment I've seen things like:
Calendar1.DateMin = DateTime.Now
But Visual Basic doesn't seem to like that (maybe it's a C# thing?).
I'm trying to check whether values ar between a maximum and a minimum limit. I do that 21 times, and it works 20 times. In case of the 21. time VB tells me that 15 is less than 8. Here the relevant lines of
[Code]...
I have a list box on my form with 2 value - "2010" & "2011". When I change the value in the listbox it should set the minimum and maximum value of 2 datetimepickers. Each time I try to change the value I get an error - for example if I change the listbox from 2011 to 2010 I get the error:
"Value of '31/03/2011 00:00:00' is not valid for 'MaxDate'. 'MaxDate' must be greater than or equal to MinDate. Parameter name: MaxDate"
If ListBox1.SelectedIndex = "0" Then
DateTimePicker1.MaxDate = #3/31/2011#
DateTimePicker1.MinDate = #4/1/2010#
DateTimePicker2.MaxDate = #3/31/2011#
DateTimePicker2.MinDate = #4/1/2010#
End If
If ListBox1.SelectedIndex = "1" Then
DateTimePicker1.MaxDate = #3/31/2012#
DateTimePicker1.MinDate = #4/1/2011#
DateTimePicker2.MaxDate = #3/31/2012#
DateTimePicker2.MinDate = #4/1/2011#
End If
I want to set minValue and maxValue of text boxes to define a range of acceptable values for validation purposes.In VB 6 this is straight forward and can be done under text box properties, however in visual studio vb .net 2010 this is not the case or it may be the case that i am missing something.
View 4 RepliesWhat I need to do is find a string that can be any value, and is placed between ">" and "</" with a minimun length of 5 and a maximum length of 7 and contains exactly 2 dots.
So if I have a text file like this:
<a href="www.site.com">a site</a>
text<br />
More test<br />
[Code]....
I want it to find only the 5.0.77. And no, the number isn't always between h2 tags, and the number isn't even always the same. The only thing that is static about it is that is is between ">" and "</" and that it is between 5 and 7 characters and contains 2 dots.
what the maximum and minimum values are for a Framework 4.0 System.Numerics.BigInteger
2 ^ x
or is it a
( 2 ^ x ) - 1 value?
I am working on this exercise where i have to find suburbs with minimum and maximum percentage POS (public open space).
I manage to get the minimum and maximum but i need a way to allow for two or more suburbs with same minimum or maximum.. for examplethree subrubs ( suburb A, suburb B, and suburb C) all has same POS of 2%, then i need to list the three in the list box as minimum with subrub name(from my code i can get only one) with the maximum values as well( allow two or more suburbs with same maximum in a similar way)..
Below is the code.. i have removed some codes to make it read easy whi are not relevant.. i got POS percentage correct and i wanna start from there..
CODE:
Im trying to programme a form to calculate rainfall total,average,maximum, and minimum.how do I create the input box that opens to input the info I cant seem to find it in the tool box. Am i Missing something, and how do I set a array to calculate?
View 2 RepliesI want to resize picturebox with mouse to maximum and minimum size as Skype when video calling...I`m using vb 2010...
View 3 RepliesIm trying to write a program that will do:
1.The average of the four numbers. This answer will be placed into a text box reserved for that value. This text box cannot be changed by the user.
2.The maximum and minimum values. These will be denoted by changing the color of the largest number green and the smallest number red.
3.The range of the numbers. The range is defined as the difference between the largest and smallest numbers. The range will be placed into its own text box, labeled as such. This text box cannot be changed by the user."
Im using visual studio 2008 and it has to be written in VB
Calculate maximum or minimum of "x" numbers
View 2 RepliesI have been very stumped by this one. I have a fairly large (~1500 x ~1000) DataTable of positive and negative integers only that I acquired from a .csv file. For my program, I need to find the maximum value of the entire table, not just in a single row or column. Optimally, the code would be short and sweet, but that's not always the case ;).
The name of my DataTable is BeamMap and I am trying to return a value of MaxValue (already declared as an integer). I can post the code I have for creating the DataTable upon request.
Extra Credit: (not really)
Is there a way to quickly find the location (ie., row,column) of said maximum value? So far, all of the examples I've seen check cell by cell for a predetermined value, which is rather inefficient for the number of data points that I have.
I'm using Visual Studio and table adapters using an Access DB as the backend. I need the minimum 4 digit value. I want to get next available 4 or 5 digit number. And this will change depending upon the users request. Currently I use a table adabpter query. But how would I write a query. I suppose I could do a long iterative loop through all values until I see a 4 digit.But I'm trying to think of something more efficient.
Function GetNextAvailableNumber(NumofDigits) as Long
'SQL Code Here ----
'Query Number Table
[code]....
How would i set a minimum number of characters in textbox1 for a button to work. and if the person does not enter the minimum number of characters, a messagebox pops up sayin something like "need at least 5 characters!"
View 4 RepliesI need to use a trackbar as a scrollbar, but the problem is that the min value is at the bottom i need it to be 0 at the top and maxvalue at the bottom..
View 11 RepliesI'm using a NumericUpDown control with a Minimum set to 10 (using for font size setting). When it is changed, it is bound to an Application setting and saved. On Form Load, I am attempting to set the value of the NumericUpDown control to the value stored in that setting (14 for example). No matter what though, it doesn't use the setting's value, it uses the value of the "Minimum" property of the NumericUpDown control.
View 10 RepliesI created a new User Control. I want to set a minimum Font for it. I put the code in the Font_Changed Event. Here it is.
Private Sub LoginControl_FontChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.FontChanged
Dim myFont As Font
[Code].....
It keeps telling me that myFont.Size is ReadOnly. How do I get around that?
I have run into a snag in my loop program. I was able to figure out the maxium sum and average of the sum. But am not able to figure out how to:
1) List the minimum value
2) List the sum of the numers divisible by 5.
These are the numbers.text displayed:
5
15
6
[Code].....
I got a progressbar in my game (Hpbar) and a lots of time the value go under the Minimum Value and it crash... Any way to make it go back to minimum value 0
View 6 RepliesI was unable to get these instructions to work:When pasting in the code below, I get an message that says "Statement is not valid in a namespace".I am using .NET 3.5 for my program, and the code came from:aspx
Protected Overrides Function OnInitialize( _
ByVal commandLineArgs _
[code].....
I want to utilize the maximum paper area (A4 size sheet). Therefore I must get the minimum margins that specific printer can handle. I have more printers attached to th pc, so I can not hardcode these values. I have tried to set margins to zero, but that results in printing outside the page at right side and bottom:
PrintDocument1.DefaultPageSettings.Margins.Left = 0
PrintDocument1.DefaultPageSettings.Margins.Top = 0
PrintDocument1.DefaultPageSettings.Margins.Right = 0
PrintDocument1.DefaultPageSettings.Margins.Bottom = 0
So my question is: is it possible to read the selected printers minimum margins without have to open a PageSetupDialog, and therefore make it possible to utilize maximum printing area with code only?
I'm using a vertical trackbar. I got it all set: minimum and maximum values, tickfrequency etc... and so on... everything works great. The only problem is that I would like to have the minimum value of the trackbar on the top. In horizontal trackabar you can choose the RightToLeft property to put the minimum value to the left or to the right, but how do I make it to put the minimum value on the top if I have it in vertical orientation? There has to be a way to somehow "flip" it... but how?
Here is a link to video on youtube, which show my problem. I want it to be the other way round - from top to bottom: [URL]
I am working on Visual Basic Express and I am supposed to calculate the change from a transaction.
View 1 Repliesi am having a problem in building up a VBcode for getting the minimum distance between a set of coordinate points. what actually i an trying is to find the minimum distance between one set of coordinate points(A(x1,y1),Bx2,y2),C(x3,y3),D(x4,y4),E(x5,y5)) with respect to another set of CO-ord points (i(x1,y1),j(x2,y2),k(x3,y3),l(x4,y4),m(x5,y5))..
ublic Function DoSearch(ByVal SearchCritera As Bracket, ByVal ListToSearchFrom As System.Collections.Generic.List(Of TRacksDefinitions.Racks.Bracket)) As System.Collections.Generic.List(Of TRacksDefinitions.Search.SearchBracket) Implements TRacksDefinitions.Search.ISearch.DoSearch
[code]....
the above is code which i have created till now and the next step is calculating the mindistance criteria..search criteria . rear points is the one we get frm solidworks and b.rearpoints is the one present in database we compare both of them find the one which is very similar to the one in database..
I would like to know how you make the minimum value of a vertical trackbar, be on the top?
[ATTACH]This is how it should look[/ATTACH]
I'm returning a list of database records;
Dim rsPublicChilds As System.Data.Linq.ISingleResult(Of spGetPublicObjectsResult) = Nothing
rsPublicChilds = dc.spGetPublicObject(slintLoginID, lintLanguageID, lintObjectID, lintObjectTypeID, lstrSEOURL, lstrValid)
I get an enumerable list of rsPublicChildObjects that I then convert to an array;
Dim larr_PublicChild As IEnumerable(Of spGetPublicObjectsResult) = rsPublicChilds.toArray()
That then gives me easy access to an array of the objects, so I can then do;
larr_publicchild(0).colMyValue
etc.etc
I'd like to get the minimum value of colMyValue (or any other property of the object that's been created for me) but I can't quite see how to get there.