Make An IF ELSE While Using With End With Statement?
Feb 6, 2012How do I insert an If Else Statement here when I want to display the studentID and loginID if there is no student name/address.[code]...
View 2 Replies
ADVERTISEMENT
Make A 'like' Statement Or Use Some Kind Of Wildcard To Make The Statement Not Case Sensitive?
Jul 11, 2010I'm building a listview search feature in my app. (See the code below). It works really well, except if you search "T" then the code removes all items, if you search "t" then it removes every item except for those starting with "t". Is there any way to make a 'like' statement, or use some kind of wildcard to make the statement not case sensitive?
For Each itm As ListViewItem In ListView2.Items
If itm.Text Like TextBox1.Text & "*" Or itm.SubItems.Item(1).Text Like TextBox1.Text & "*" Then
Else
[code].....
How To Make SQL Insert Statement
Jan 6, 2011i have a query here run in SQL server 2008 which produces the error "Conversion from string "INSERT INTO Faculty (emp_id, lna" to type 'Double' is not valid."
"INSERT INTO Faculty (emp_id, lname, fname, mname, nickname, date_of_birth, place_of_birth, gender, address, civil_stat, contact_num, citizenship, e_add) VALUES ('" + enumm + "', '" + txtlname.Text + "', '" + txtfname.Text + "', '" + txtmname.Text + "', '" + txtnick.Text +
[code].....
Make An Insert Statement?
Oct 7, 2009I am using this code for my project. What I am not sure is that when I search on the net, they use the "@id" for the insert statement.[code]...
View 3 RepliesVB Program : Make An If Statement?
Dec 14, 2010I am trying to make an If statement. I have 4 radio buttons
Part Time
Full Time
Part Time Temp
Full Time Temp.
I am calculating Fringe and Calucalted Funds.I also have 6 constants
Const PEIABasic_RATE_Decimal As Decimal = 5.06
Const PEIAFAMILY_RATE_Decimal As Decimal = 778.0
Const WORKERSCOMP_RATE_Decimal As Decimal = 0.0049D
[code]....
I have two text boxes where a user can enter the hours worked and hourly rate. and Salary rate. If a user clicks the Full time radio button the calculation for fringe should be FICA const * salary Works comp const * salary.Then u would add the fringe to the base salary. Part time the user needs to click the part time button along with another button, either TIAA or State REtierement.
If FullTimeTempButton.Checked & TIAARadioButton.Checked Then
FringeTextBox.Text = (FICA_RATE_Decimal * SalaryTextBox.Text) + (WORKERSCOMP_RATE_Decimal * SalaryTextBox.Text) + (TIAA_RATE_Decimal * SalaryTextBox.Text)
[code]....
Make An If Statement Inside A Button?
Oct 26, 2011I want to make an if statement inside a button. So basically its this Private sub Button1_Click ....
If Button2.click then
blah blah blah
else if button3.click then
'blah blah blah
End If.
How would I do this because I can't seem to solve it with any code of mine, i searced through all the allowed values that vb offers and nothing ...
Make Condition Statement But Un-successful
Jun 16, 2010i want to make condition statement in my function. i use this method : [code]if i try to insert a data already in the database, the function will directly go to the updateDatabase()the problem is, if i try to insert the data that currently not in the database, the function will directly go to update database as well.
View 1 RepliesUpdate Statement To Make A Record = 1?
Feb 18, 2011i need a update statement to make a record = 1 example : the colum what need to change is active and it must stand on 1 to show you in to a listview (that part works) but i need to do it manualy to make them active now i liked to when the login is a succes then the record = 1 for you this is my code :
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim adapt As MySqlDataAdapter
Dim sqlquer = ""
[code].....
i get this error : Object reference not set to an instance of an object.
.net - Make Crystal Report Of Profit And Loss Statement?
May 2, 2011i want to make crystal report of profit and loss statement i have a column of "vr_type" and there are 4 types in it "sale invoice", purchase invoice" now i want that put a 4 formula s where i select that "sum (vr_detail.debit) where vr_detail.vr_type} sale invoice it make Sum of al these types so kindly tell me what formula i should use to get the result in simply i want sum of sale,sum of purchase,sum of expense?
View 2 RepliesMake A Statement That Sets The Focus To The TxtPassword Control?
Sep 29, 2010how do you make a statement that sets the focus to the txtPassword control?
View 1 RepliesMake Program Case Statement Evaluate All Cases?
Jul 15, 2010Is there a way to make a VB case statement evaluate all the cases? Similar to a java switch statement (without the break).
View 5 RepliesMysql Functions - SELECT Statement And Make A Function ?
Jul 12, 2010I am trying to clean up my code a bit.
I made the following function:
Public Sub sqlUpdate(ByVal table As String, ByVal column As String, ByVal var1 As String, ByVal column1 As String, ByVal var2 As String)
Public CN As New MySqlConnection
Public cmd As New MySqlCommand
[CODE]...
Which is fine, if I want to use mysql update all I have to do is call something like: sqlUpdate("test", "test", 0, "test", test) I was wondering if I could do the same with the SELECT statement and make a function. I cant think of a way to do it though...
sqlConnect()
Dim cmd As New MySqlCommand
With cmd
.CommandText = "SELECT * FROM users WHERE username=""" & lblAccountName.Text & """"
[CODE]...
The data I would want to extract would be different every time.
How To Make A Statement Run If All Conditions Are True From Multiple Condition Or If Statements
Mar 22, 2011I have a form that contains multiple conditional or if statements on several defferent for controls.
Example: Radio Buttons, TextBoxes and CheckBoxes.
I am intending to create an order form(demo) where the user can select multiple products.
I have a default order number that changes by one everytime an order is successful.
An order is only successful if all the information on the form is entered correctly.
My question is where do I insert the code for the order number?
Basically for the order number I have a counter that count by increment of one if an order is successful.
Meaning when the user hit place order, and all the infromation is right, then the order numer goes to 1 from zero.
Where do I add the condition for the order number since all the fields must first be completed.
Do I have to create a whole line of if else statements?
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?
Make An If Statement The "if Textbox2.text Has Only One Line Of Text?
Jul 8, 2010how can i make an if statement the "if textbox2.text has only one line of text then..."
View 3 RepliesIf <expression> Then <statement [:statement]> Else [statements] In Concrete Form?
Jan 1, 2010I was convinced that If <expression> Then <statement [:statement]> Else [statements] in concrete form of If a = b Then SayHello() Else SayBye() End has sense. I read article on msdn on If-then-else, but I forgot why I was reading, so I concluded, that snippet above means this
If a = b Then HelloIsSaid : IsNotEnded Else ByeIsSaid : IsEnded But I have tested it now, and I see, that Else without statement is nothing more than decoration. It would be pretty good if it had function I described. Do you think its good request? Or do you know any circumstance where this Else has some function?
Making A Next Statement Into A Loop Statement In Visual Basic?
Jun 8, 2009y friend and I are re-learning Visual Basic, and we are stumped on this bit of code.
For intAsterisks As Integer = 0 To intLine - 1
lblAsterisks.Text = lblAsterisks.Text + "*"
Next
Sql - Perform An Inline Select Statement In A LINQ Statement?
Jun 24, 2011I have the following SQL:
[Code]...
I want to put it (the select count statement) in this LINQ statement so I can get the sales count in my linq statement: Dim TheLeads = (From L In DB.Leads Where L.IsDeleted = False Select L).ToList() Is this possible to do in LINQ?
Change The Exit Statement To A Continue Statement?
Feb 23, 2009add an if statement and an exit statement to my do loop that exits when my future value (FV) is greater than 1000, then to change the exit statement to a continue statement so my loop will continue even though my fv is greater then 1000, point is to get this to run even though my if statement doesnt do anything. problem something wrong in my code and an exception error (xception of type 'System.OverflowException' occurred in mscorlib.dll)
so can someone show me where or why I have an error is, what am I overthinking now! I could use a hint, OMG i could use a tutor for that matter
[Code]...
ElseIf Statement Into A Select Case Statement?
Jun 23, 2010A co-worker wants to convert the following IfThenElseIf statement into a Select Case statement.
Explain why this is not possible.
If temperature = 100 Then
X = 0
ElseIf population > 1000 Then
X = 1
ElseIf rate < .1 Then
X = -1
End If
SQL Statement :: Nearly Working Just Cant Get Form Values In Statement?
Aug 4, 2010I cant get this SQL statement to insert any of the values in the form to add to the database
sql
sql = "INSERT INTO prevresults (ExamDate, ExamTime, CorrectAnswers, PassPercentage) VALUES (date.now, time.now, rightanswers, percentage.text)"
[code]....
Return Statement Which Is True In An If Statement?
May 24, 2012Return statement which is true in an if statement
View 3 RepliesMake A Number To Number If Statement?
Oct 9, 2011I need to know how to make a number to number if statement e.g. if min = 20 to 40 then ...
Current code:
If hour = 8 And min = 20 or 21 or 22 or 23 or 24 or 25 or 26 or 27 or 28 or 29 or 30 or 31 or 32 or 33 or 34 or 35 or 36 or 37 or 38 or 39 or 40 Then
TextBox1.Text = "Test"
Else
TextBox1.Text = "Text1"
End If
Break Up The Code In A Method Body Into Statement By Statement Symbols/"tokens"?
Apr 22, 2011I'm writing something that will examine a function and rewrite that function in another language so basically if inside my function F1, i have this line of code var x=a.b(1) how do i break up the function body into symbols or "tokens"?I've searched around and thought that stuff in System.Reflection.MethodInfo.GetMethodBody would do the trick however that class doesn't seem to be able to have the capabilities to do what i want..dit 2:basically what I'm trying to do is to write a program in c#/vb and when i hit F5 a serializer function will (use reflection and) take the entire program (all the classes in that program) and serialize it into a single javascript file. of course javascript doesn't have the .net library so basically the C#/VB program will limit its use of classes to the .js library (which is a library written in c#/vb emulating the framework of javascript objects)
View 4 RepliesExceptions - Can The "Throw" Statement Exist In A Block With No Try/catch Statement
Oct 5, 2009how to use them then before, but am still a little confused with a few aspects. Here goes:
1.) Lets say you have a method that checks for a certain condition(s) and if it fails Throws an exception. Does it have to be in a try/catch block? Meaning can the "Throw" statement exist in a block with no try/catch statement?
2.) Now lets say we have a method that has a try catch block and in it there is a throw statement. When the throw statement is executed does it first try to find an appropriate catch block in the same method or does it immediately go back to the calling method without looking at the catch statements in the current method where the exception was thrown?
3.) I created a custom exception class that inherits from ApplicationException. Next I created a method which has a catch block that catches this type of exception and does some action. Is the System(i.e CLR) smart enough to throw an exception of this type, or does it only throw exceptions from SystemException?
4.) I know that some people are more liberal in their use of exceptions and others use it more sparingly when truly strange stuff happen like the DB going down. I am writing code where I am getting some info back from the database, converting it and then storing it. Sometimes there might be data that comes back from the database and other times the field is empty and the Null value comes back. Therefore in the instances where Null comes back from the database I should not convert the value to anything, since I will get an error. What should I do in this situation? Should I let the CLR throw the exception when it goes to convert the Null value or should I check for the Null value and if it exists not convert?
5.) In general when I throw exceptions, is it sensible to only throw exceptions of the type Application Exception or are there instances where the programmer throws exceptions of the type SystemException?
"End Of Statement Expected" Error In VB 2010 In A Do While Statement?
May 2, 2012I have a line of code that is working in one statement but not the second statement. I'm not sure what I'm doing wrong, I am learning slowly but surely, and it is by no small margin because of the ave found here =) The error is occuring in the intResult = intSelection x intCount line of the SECOND Do While Loop.
The blue squiggle line is under "intCount" just FYI
Dim intSelection As Integer
Dim intCount As Integer = 0
[code]....
Components - "if" Statement Shows An Error " Statement Cannot Appear Outside Of A Method Body"
Jan 29, 2009I have the following vb code which works as expected when it's in a code-behind page. I tried to move it to a shared or component page since I will need to use it in multiple pages:
Imports Microsoft.VisualBasic
Public
Class DetTime
'Determine eastern time
[CODE]...
However the "if" statement shows an error " statement cannot appear outside of a method body" and the Microsoft solution is to "move statement into a procedure or subroutine"
Case Statement Inside A Case Statement
Oct 31, 2011I have coded a case statement that changes the background colour of a panel. [code]When the code is run, it works for the case of colour1 that is NOT 1 or 2. However, when the colour1 is 1 or 2, it is supposed to pick a number from set array and run another case statement. Instead, it only picks the last value (for 1, this is 5, and for 2, this is 7).
View 3 Replies"Using" Statement - "statement Cannot Appear Outside Of A Method Body"
Mar 17, 2010Where should i put the Using statement in Visual Basic 2008 Express Edition? as i put in under general declaration, it said "statement cannot appear outside of a method body"
View 1 Replies.net - SQL Statement In Vb?
Jan 11, 2012I have a table named "Admin(a)"And i have a SQL statement:
SELECT *FROM Admin(a);
But (a) gives me a error.How should i express Admin(a) in a sql statement?
