Asp.net - Why Won't Work As An IIF Function But Will As An IF Statement
Sep 13, 2010The following works:
[Code]...
However, the following doesn't work:
ADVERTISEMENT
Function Where Wait_rtn Statement Does Not Work And Errors Out With Error 0?
Jun 18, 2010I am having issue with this function where wait_rtn statement does not work and errors out with error 0. it is suppose to search the screen and if it finds (true) get out of the loop...
[code]...
SQL Statement Doesn't Work - INSERT Statement Works Fine In The Form Load But Not In The Button Click Event?
Oct 14, 2009See
Public Class Form1
Dim sql As String
Dim conn As New OleDb.OleDbConnection
Dim da As New OleDb.OleDbDataAdapter
[CODE]...
The problem, The INSERT statement works fine in the form load but not in the button click event?
Can't Get If Statement To Work With Htmlelementcollection
Feb 28, 2010I just can't get this If statement to work with htmlelementcollection. The problem is my msgbox pops up saying element found rather the element is there or not.[code]
View 4 RepliesCan't Get MsSQL Statement To Work?
Apr 6, 2012Dim connetionString As String
Dim cnn As OleDbConnection
connetionString = "Provider=SQLOLEDB; Data Source=****; Initial Catalog=****; User ID=***; Password='****';"
cnn = New OleDbConnection(connetionString)
Try
cnn.Open()
[Code]...
I have been working with this for awhile, and I can't get it to work, I have all the correct names where the connection string is, but I just can't get it to work. It is telling me the server does not exist, but I am using a hosted solution that I know is up.
If Statement Doesn't Work Right
Oct 13, 2009Dim
a As Date? = Nothing
Dim b As Date? = If(a Is Nothing, Nothing, GetValue(a))
I thought b would be Nothing, but it is not...is it a bug?
If Statement - Program Doesnt Work ?
Apr 11, 2012I'm not quite sure why, but this program doesnt work as intended. It's kind of difficult to explain but if you tried it, it doesn't work properly.
Private Sub btnApply_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnApply.Click
'clears the changes box before going through if statements
Me.txtChange.Text = ""
[CODE]...
Math.Abs Statement Doesn't Work?
May 12, 2011I'm having a problem with the Math.Abs statement. When I try to use this statement to figure the absolute value of a number, as in:
View 3 RepliesSelect Case Statement Won't Work
Jul 13, 2011I am trying to type in the food Pizza, Taco or Crepe and get a picture of the food to come up along with a message box that gives the country.[code]
View 3 RepliesVS 2008 Randomize Statement Does Not Work?
Dec 31, 2009I was thinking if I can create a code that creates 8 Labels, and each label will show someone's name. The name is not generated, it is randomized. But I Don't want to see 2 same names in 2 different labels. So what I came across is this:
First, I will make an array variable (0 to 8) as String, I will declare each person's name here, the 0 is not used. I Will call this "Names"Second, I'm going to make an array variable (0 to 8) as Boolean. Original State is False. I will call this "Type"Third, I will make another array variable (0 to 8) as Integer, this one is empty. I Will call this "Empty". Original value = false
The Point is that the application will randomize a number between 1 to 8, just say that the randomized number is "x". Then I will take Names(1) and fill it in Empty(x), and set the Type(x) to True, and keep looping. If the application finds the Type = False, then the application will randomize another "x". But after making the code, it seems that the numbers show up the same way everytime I run it. Even with the Randomize() statement.
[Code]...
Can't Get Select Case Statement To Work Properly
Aug 19, 2009I'm working through a programming project, which should be quite easy but im stuck right at the start (relatively new to VB). I have a textbox (named textbox1) and a checkbox next to it. I want the checkbox to be ticked (.checked) when ever the value in the textbox is between 1 and 100, the checkbox to not be ticked when theres nothing in there, and for it not to be ticked when the value is < 1 and > 100. Figured a case statement would be the easiest. (this piece of code is just a validation check, basically in the real thing the user would have to enter in a value between 1 and a given number, and need to tell the user if that value is valid).
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
Select Case TextBox1.Text
Case Is = ""
[code]....
But what happens is, if I enter in the value 1 in the textbox, the checkbox becomes ticked, as it should. It tick with any values between 2 and 99 (any number not starting with 1) but the checkbox becomes ticked again when the value is 100. For any other range, say 1 to 70, the checkbox would be ticked if the value in the textbox is 1 to 7, or any number starting with 1 or 7, but not 8 or 9, or any number starting with 8 or 9.
Get The LIKE Statement To Work If The User Enters A Number?
Sep 22, 2010how I can get the LIKE statement to work if the user enters a number like 403* ? The sql works if I do not enter an *
strWildCardFound = InStr(TNSearchTextBox.Text,
"*")
TNSearchTextBox.Text = Replace(TNSearchTextBox.Text,
[Code].....
Equivalent Using Statement Code For Which Online Translators Don't Work?
Aug 26, 2010How do I write the equivalent c# code below in vb.net? This 'About' form is launched by a ToolItemMenu. It is just informational and contains only an OK button
//Form contains company logo, copyright info and OK button.
public About formAbout;
using (formAbout = new About())
[code].....
VS 2008 - Getting An If Statement To Work - When Detects A Form Is Not Open
Jun 15, 2012I'm currently having some trouble getting an If statement to work. I want the statement to do its thing when it detects a form is not open. this might sound a bit confusing this is what i mean:
If Form2.open = false Then
blah blah blah
blah blah blah
blah blah blah
[CODE]...
Basically i dont know if im able to have an IF statement occur for when a form is not open and i dont know how to word it.
Unable To Use A Linq-to-sql Statement And Getting A Left Outer Join To Work?
Apr 29, 2010i'm having troubles with a linq-to-sql statement and getting a left outer join to work. here is a sample of two tables i'm trying to join and my code that i've wrote.
Table1 Table2
f1 f2 f3 f4 fID f1 f2 f3 f4
val1 val2 val3 val4 1 val1 val2 val3 val4
[code]....
Instead I'm returning ALL values from table 1. I need to return all values from the left outer join where tbl2.fID is null.
2 Exists Function In 1 Sql Statement?
Jul 1, 2009Is it possible to use 2 exists function in 1 sql statement. Below are part of my
select m.ModuleName,sh.Day,sh.Time,sh.Venue FROM Module m INNER JOIN Schedule sh ON m.ModuleID = sh.ModuleID INNER JOIN Student s ON sh.StudentID = s.StudentID WHERE EXISTS (Select * FROM MsgIn WHERE MsgIn.MsgNumber = s.Phone) AND WHERE EXISTS (Select * FROM MsgIn WHERE MsgIn.MsgContent LIKE '%MON%' = sh.Day)
I tried to do like this but an error occured.
If Statement - Mystery Of The If() Function
May 22, 2012I have this code:
[Code]...
EDIT: CELL_VALUE_FLOAT is a Nullable(Of Double) and CELL_VALUE_INT is a Nullable(of Integer) In Quickwatch the condition evaluates correclty to False, but when running the If() function evaluates to the True part.
Return Before 'End Function' When Using A Do And Try Statement?
Jul 14, 2009I know normaly you have to use Return before "End Function", but now the Return is in the Try and Do statement and I can't find a way to variable the Return.[code]...
View 7 RepliesVB Return Statement In A Function
Sep 28, 2009I am a little confused about the use of a return statement in a function. If I understand correctly the return statement returns a value but where? Where is the value being returned to?
View 1 Replies.net - Using Right Function In If Statement Causes Syntax Error
Mar 9, 2012I have a multiple-value-single-string as a parameter field in a report in Report Builder 3.0 (e.g. 20124, 20125). Now I want to split up this string, and show "Summer 2012" instead of "20124" and "Fall 2012" instead of "20125. I am using Visual Basic. Here is my two functions I have made in Report Builder 3.0 custom code. The error is in the second function in the "If Right(yearterm)..." line. It gives me a syntax error. If I write "String.Right" it gives me the error: "'Right' is not a member of 'String'". If i take out the whole "If statement" the report will run but "20124,20125" gives me this: ", 2012, 2012".
Public Function SplitParameterValues(ByVal parameter As Parameter) As String
Dim result As String
Dim a(0 To 10) As String
[code]....
DB/Reporting :: Use SQL Statement To Return Value To Function
May 1, 2012I have 2 functions that need to work together.1 function is to generate a chart number. The other function is to search via SQL to see if the chart number exists. if the chart number doesn't exist then i need function 2 to return a boolean value so function one can generate a new chart number example code: [code] Now i know that i am probably using the incorrect sql statement, my main issue is that i dont know how return available back to the function.
View 1 RepliesGetting Result Of Linq Statement Out Of A Function?
Jun 16, 2011I have something that I want to do and what looks very simple, but I cannot get it to work. I want to build a function that gets as input a xdocument and some other strings. It should have a return that contains a filtered part of the xdocument in a way that I can use it as input for a new Linq function. This is what I mean:
Private Function fncGetFilteredDecendantsOfNode(ByVal xdocDoc As XDocument, _
[Code]...
VS 2005 Date Function In Sql Statement
Jun 1, 2009I have trouble with my vb application.I create query in dataset like this :Select * from Trans where year(dateTrans)=2009 and month(dateTrans)=5But is not work and error message : year and month function not identified, what is the problem ? what a sql date function ?If i create databound from dataset and drag n drop date field in form with datetimepicker control, if i had update dataset, date field is empty.Whats wrong with datetimepicket databound.
View 5 RepliesVS 2008 Return Statement In Function?
Apr 12, 20101. I would like to know why a Return statement is needed in the function in the first set of code, but not in the second(even though it still works with the Return statement). The functions are called the same way, so what is the difference?2. Why in the second code, the variable FutureValue is allowed to have the same name as the function? But when, in the first set of code, I try to rename the variable "discountPercent1"(in the function) to the function name "SetDiscountPercent", VB 2008 Epress gives the error message "The name conflicts with an existing symbol with the same name"?
Public Class frmInvoiceTotal
Private Sub btnCalculate_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnCalculate.Click
[code].....
Windows - Evaluate Two Function In One Statement?
Feb 25, 2011I am using a two-dimensional array of 10 elements, but my code is extremely slow.
[code]...
I create a new empty array with every iteration of the for loop. Is there a way I can use the same array but just clear it instead?
Windows - How To Evaluate Two Function In One Statement
Apr 18, 2012How to declare two object in one statement for vb.net?
Example
If IsNumeric(TextBox1.Text),(TextBox2.Text) Then
lbl_answer.Text = Val(TextBox1.Text) + Val(TextBox2.Text)
Else
MsgBox("Error only number can be calculate")
End If
I can do
if isnumeric(textbox1.text) then
But I can't say
if isnumeric(textbox1.text), (textbox2.text)
How can I do so?
How To Get Function (lines 45-57) To Work.
Jun 8, 2011I am having trouble figuring out how to get my function (lines 45-57) to work. Option Strict is supposed to be on. I am getting the error "Option Strict On disallows implicit conversions from 'Decimal' to 'String'." This is an intro problem so its going to be basic. [code]
View 2 RepliesLeft Function Does Not Work?
Oct 31, 2010I expected the "Left" function in the code below to return the letter "A" but it returns nothing? Also, as a further test, Left(CP, 3) returns nothing?
View 3 RepliesRe-writing A Function To Work In Dot Net 2.0
Nov 18, 2010I have the following function written for dot net 3.5 that uses "ElementAt()" to successively return a value from a dictionary collection.
Public Function GetNextEntryInfo() As EntryInfo
If mFileInfo.Count > mIndexLoc Then
Dim entry As EntryInfo = mFileInfo.ElementAt(mIndexLoc).Value
[Code].....
VB Can't Get The Right Function To Work With Strings
Jun 20, 2012Basically, I'm trying to do some string manipulation to edit directories. I found some code to try and edit the directories, but when I use it it doesn't recognise 'right' as being a function and only recognises it as a right property, thus producing an error.
I was wondering if there's something I haven't imported or if perhaps 'right' is an obsolete function that was used in VB6 but replaced with something. The code I have is as follows:
[Code]...