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
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?
I've created a log in system using a database and query builder to return the correct values, however, once the users signed in I need to bring up the rest of their data from the same table in the database. How'd be the best way of going about this? I'm not sure whether the log in should be changed to use the primary key as well.
Quick query...I'm trying to scan a long string and return any values that occur between the tags <FileName> and </FileName> I've got a bit of code here to use regular expressions to return the position of the occurunces of both substrings..Just wanted to find out if there is any way to scan for both substrings within one loop (as im currently doing 2, one for the first substring and one for the 2nd) so I can use something along these lines:
to msg box the value between the substrings...either that or another approach to return the value between the 2 substrings (it can be of variable length)
Dim patternstart As String = "<FileName>" Dim patternend As String = "</FileName>" Dim matchesstart As MatchCollection = Regex.Matches(XMLRESP, patternstart)
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,
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).
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.
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.
[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
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).
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.
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.
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
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.
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.
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)
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] .....
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
> 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?
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.
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
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]...
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.
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?
