Return The Greater Of 3 Values

Dec 14, 2009

Need to return the greater of 3 values. Each value is based on user input and system calculations. Requirement = the greater of (Req1, Req2, Req3) Have tried a number of "If" "Else" and Ifs within Ifs "<" and ">" combinations without consistant results. This may seem simple to some but I am relatively new to VB. My search on MSDN was not fruitful.

View 11 Replies


ADVERTISEMENT

Filter BindingSource By Greater And Less Than Values

Apr 11, 2012

I thought I had this sussed until I then wanted to filter between two values or greater than or less than two values. I have searched and searched all over the web for this and I just go round in circles. This is so frustrating why is this so difficult to find something so basic (anyway that is my rant). I have something like this but am totally confused and do not understand what I am doing now: how I get this working in plain English.

Me.BindingSource.Filter = String.Format("DeliveryDate >= #{0:MMM/dd/yyyy}# And DeliveryDate <= #{1:MMM/dd/yyyy}#", dtpStartDelDate.Value.Date, dtpEndDelDate.Value.Date) _
& String.Format("JobID >= {0} AND JobID <= {1}", txtStartJobID.Text, txtEndJobID.Text)

If I run this with just the date range filter it works fine it is when I add the second filter for the Job ID range I get the following error; {"Syntax error: Missing operand after 'JobID' operator."}

So I it is this line I have the problem with:

String.Format("JobID >= {0} AND JobID <= {1}", txtStartJobID.Text, txtEndJobID.Text)

View 10 Replies

Coding A Textbox To Only Accept Values Greater Than 0

Jun 24, 2009

just a quick question. I'm trying to code a textbox that will enable a button, only when the value in the textbox is no less than 1. I've tried an if statement with txtBox.Text > 0 doesn't work Will it involve something with Min and Max values?

View 9 Replies

How To Get 2 Return Values In One Function

Mar 26, 2012

i want to get two output values in one Function is't possible ?i am just using String data type and split the values.but have any other easy way to get two output values actually i want to checking a folder how many jpg files are Horizontal and vertical [code]finally i split the values with "|" character.have any other options to get two values as separate in one functions.i have no moew idea about Dictionary,

View 2 Replies

NPV In Excel And VB Return Different Values?

Nov 30, 2010

If a use the NPV() function in Excel (2010) with a discount rate of 5% and 10 cells that each contain 505,000 the resulting NPV function call "=NPV(5%,C2:C11)" returns the value of 3,899,496.

If I use the Financial.NPV() method in the Microsoft.VisualBasic namespace (in my C# application) and pass in a discount rate of 5% (as a double) and an array of 10 doubles with a value of 505,000 each, the VB function returns the much lower value of 100,999.99 (plus a few more decimals).

View 9 Replies

QueryString Does Not Return All Values

Nov 12, 2010

When I do a
Request.Querystring("key1")
Request.Querystring("key2")

The system doesn't seem to parse the second ?/value out but treats it as if key1 was all one string, e.g. [URL] ...as if it completely ignores or doesn't parse out the second (or other if more) key/value pairs.

View 2 Replies

Return Two Values From The Same Function?

Feb 3, 2010

[size="5"]How can I return two values from the same function?? I need to return an arraylist and an integer...the arraylist is already returning now i need to add the integer

View 3 Replies

Assign SQL Return Values To Array?

Apr 7, 2010

Assign SQL return values to Array

View 2 Replies

How To Return Values To Owner Forum

Aug 28, 2010

ok here is the thing, in my application there is 2 forms, in the main one (not an MDI)it has some textboxes and a picture box, the other small form contains only a ser enters his search criteria in the textboxes in the main formand presses a button to show the results,t opens the second form and displays the results inthe listview(results are names of pictures).

View 2 Replies

If Statements - Program Look At 2 Different Values Then Return A Value

Feb 18, 2012

What I need to do is to have my program look at 2 different values then return a value.

Here's an example:

If my tube material = SA-214 and the tube gauge = 20 then my tube wall thickness = .032. The thing is I have 5 different types of tube material and 12 different tube gauges so based on which tube material is selected and which tube gauge is selected the tube wall thickness will vary. So if I select a TM of SA214 and a TG of 14 then my tube wall will be .076.

View 3 Replies

Return Multiple Values From A Function?

Mar 30, 2011

Is it possible to make a function that returns both a datatable AND a list(of custom class) at the same?In my GUI layer, the main form (the application is MDI) calls this function and it has to fill the datagrid on one of its child forms and it also has to fill lot of other child forms with various information that is calculated from my custom class properties.Both the datatable and the class properties are created from the same external database and that's why I don't want to have two separate functions.

View 3 Replies

Return Multiple Values From A Query .net?

Apr 10, 2012

how to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code

Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String

[code]....

View 3 Replies

Return Multiple Values From Function?

Mar 15, 2011

I have created a function that takes a Car Registation as its argument and I want it to return 3 values (Make, Model, Price and of course True).The code itself works fine (it returning each Individual value but can't find a way to get ALL of them from 1 function) However I need to actually return all 3 values, and I cannot see how to do this with a simple function.

View 8 Replies

Return Values Calling By Private Sub()?

Nov 25, 2009

I have following codes in my Project

[Code]...

Now I am calling Get_Values(). But I am not getting the values in variable G1,G2 & G3.

View 1 Replies

Return Values Of Stored Procedure?

Jun 11, 2011

the stored procedure is within a transaction. I want to get the inserted values after calling the stored procedure. My problem is, I don't know if that is possible because the transaction is not yet commited.

View 1 Replies

Return Values To The Calling Form?

Nov 24, 2009

I have a form which calls other form to achieve some functionality. How can I pass values obtained on other form to the calling form?

View 10 Replies

Search Text Box And Return Values Between X And Y

Apr 7, 2012

i am having a few problems with something i need to create. it firsts needs to get source code of a url i specify, after which i need to click a few buttons so it gets different parts (extract) of the data that i need from the source code and display it in a different text box if possile. (while leaving the original sorce code intact)

[Code]...

View 3 Replies

Unable To Use RegEx To Return Values

Oct 14, 2009

I am trying to get '[NewsLink1234]' from the textbox. I think the Regex code is correct. I need the results to show:
[NewsLink1234]
[NewsLink12333444]
[NewsLink12]
Depending on which ones are in the textbox as the numbers will be ids.

Here is the code:
Partial Class Hertscricket___Test_admin_Default
Inherits System.Web.UI.Page
Public StringVariable As String = ""
Public strValue As String = ""
[Code] .....

View 2 Replies

VS 2008 Having A Function Return Two Values

Aug 19, 2009

I'm having trouble with a function returning two values. Each value contains a string, how can I return these values and have each one of them be stored in one independent variable. [code] I'm trying to return the hashed text with the salt and the generated salt, how can I do this?

View 18 Replies

VS 2008 Oledbcommands-return All Values?

Feb 17, 2010

ive got command below to query db for result = false.I want the switch names returned to be displayed in a textbox. the PROBLEM is only the first result is being returned. I think this is because ive chosen execute scalar but none of the other options seem to work.

Using con2 As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:Network Map.mdb")
Using command As New OleDb.OleDbCommand("SELECT SwitchName FROM tblSwitch where Result = false", con2)
con2.Open()
Dim faileddevices As String = CStr(command.ExecuteScalar)
RichTextBox5.Text = faileddevices

[Code]...

View 9 Replies

VS 2010 How To Get 2 Return Values In One Function

Mar 26, 2012

i want to get two output values in one Function is't possible ?.i am just using String data type and split the values.but have any other easy way to get two output values

View 1 Replies

VS 2010 Return XML Values Sorted?

May 28, 2012

I havew a smal xml file which looks like this:

<?xml version="1.0" encoding="utf-8" ?>
<fv>
<flv url="http://www.mysite1.com">Windows</flv>

[code].....

View 4 Replies

.net - Function Giving Warning Saying No Return Values?

Nov 21, 2011

> Function LoginPass() As Boolean
> Dim LogPass As New waxClass
> Dim Ldt As DataTable = LogPass.LoginPass(LCase(UserName_TextBox.Text),
> LCase(UserPass_TextBox.Text))

[Code]...

When I try to use the above function it gives a Warning saying:

Function 'LoginPass' doesn't return a value on all code paths. Are you missing a 'Return' statement?

View 1 Replies

ADO.NET: Return Multiple Values Instead Of Only The First In An ExecuteScalar()-like Fashion

Nov 18, 2009

currently, I use this code:

[Code]...

View 10 Replies

Asp.net - SQL Stored Procedures Failing To Return Values?

Sep 7, 2010

I am working on a Tag system for a news page designed in ASP.NET. For the system I require a TagExists method to check for tags within the database. The stored procedure I have written is below.

ALTER PROCEDURE [dbo].[Tags_TagExists](
@Tag varchar(50))
AS
BEGIN

[code]....

I have tried switching the procedure to return 0 if the tag exists and 1 if it does not and it still returns 0 despite the exact same testing conditions. I have also returned the actual select query and it has complained of the Tag "news" (my test item) not being an int on execution showing the select itself is definitely properly formed.

View 3 Replies

Functions Return Values As Byref Or Byval Or?

Oct 20, 2011

i have a strange issue today. Sample code is at the below of the post. The code that i have pointed out is too strange. According to my knowledge using return statement the functions return values as byval and copies the value to the stack. Also how can my class can reach outscope elements and change them. Take a look at to the code below. How this could be?

code
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim b As New ByteClass
Dim sumArray As Long = 0

[Code]...

View 21 Replies

Return A Typed Object With An Overriden Values?

Jan 19, 2011

I have the following linq query which returns a Report Object; yet I need to explicitly set the value of one of its proprties from another column. [code]...

View 1 Replies

Return Random Values Based On A Range Given?

Mar 22, 2011

I am coding a lottery number generator for a homework assignment. My project needs to have functions that return random values based on a range given. The first function I am coding is for a pick 3 lottery game.The function should return three random numbers between 1 and 9. I have coded the function but it only returns one number. When the debugger runs it says my function does not return a value on all codepaths.

[Code]...

View 10 Replies

Return Values With Reference Arguments Or By Structure?

Jul 10, 2009

In what situtations is it best to use reference arguments to return values?

Sub Example(byref value as integer)
value = 3
End Sub

In what situations is it best to return the value (perhaps in a structure for more complex types)?

Function Example() as integer
return 3
End Function

View 3 Replies

Selecting Two Values From Combo Box To Return A Price?

Feb 8, 2011

As some of you probably already know I'm currently creating a ticket ordering system. I'm having some slight trouble getting one of the key elements of the application to work mainly because I'm not sure where to start with it.

I currently have a form with two combo boxes (one for the origin of the journey and one for the destination). The idea is that the customer tells the employee over the phone where their journey begins and ends. They will also select a date of travel - but the date of travel doesn't really matter to much at this time.

Once a to and from is selecting from each combo box, the price will be shown in a label on the same form.

I have the to, from and prices information in an Access database table and my database is already linked to my application using a data connection.

trying to get to price to display when the two values in the combo box are selected?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved