i want to retrieved data from MS Access by select the date using date time picker. so my problem is how to write the sql statement.
My code is as below:
sql = "SELECT * FROM summary WHERE line = '" & cbLine.Text & "' AND date = '" & dtp.Text & "'AND plants = " & cbPlant.Text & ""
Mentor Edit:
I am writing as if statement that when I click the button to access to google site and when the page fully loaded then show the messagebox. Here it the code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
WebBrowser1.Navigate("http://www.google.com")
[Code].....
I have trouble of writing the select case statement. I am trying to select the first case to change the labels text and if I select the case again then show up the messagebox.
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Select Case test
Case test
Label1.Text = "test"
[code]....
When I selected the button which the labels text have changed and I have selected the button again, but the messagebox doesn't appear on the screen.
How would I go about writing an IF statement that would check for letters? Something like:
IF field IS NOT Int THEN
Response.Write "WRONG!"
ELSE
Response.Write "OK"
END IF
I have Visual Basic 2010, can you tell me how I could simplify this code without using the last IF statement? In other words, have console.beep when form2 comes up, but with out adding the extra line?What would an easier way to write this be? I mean instead of writing the separate if statement for the console.beep?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If TextBox1.Text = "valentines" And TextBox2.Text = "day" Then Form2.Show() Else MsgBox("That's Not It Theresa!")
If Form2.Focus = True Then Console.Beep()
End Sub
I am writing the code as on if statement that if the html class has strings called "<a id=""rowTitle1""(.*?)</a>" then do something. In what property that come after pattern that I could check the string whether if it valid or not??
View 13 RepliesSee
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?
I 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?
y 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
I 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?
add 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]...
A 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
I 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
View 3 RepliesI'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 Replieshow 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?
I'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].....
I 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]....
I 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"
I 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 RepliesHow write folllowing into cmd schtasks /create /tn "savita"
Here savita is value in the textbox1, i dnt knw how to write " into cmd
Where 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 RepliesIt would be easy enough to make my own system for this, but I'm figuring that the .NET library, being as massive as it is, probably already has a class made for this very purpose.For hit detection, my VB.NET game uses two 2D arrays that store the state of each pixel in the level. Each element in these arrays is a Byte (or, more accurately, a value of a flag enumeration type based on Byte).
Public TiHD(,) As HitDT ''//State of each pixel in the level based on
''// its underlying tile.
Public SpHD(,) As HitDT ''//State of each pixel in the level based on[code].....
I would enjoy being able to just give each sprite & tile its own 2D array of hit detection data (defining which pixels of the object are solid, dangerous, etc) that can be directly written to TiHD or SpHD at a specified offset.I'm willing to bet that .NET has a class that can do this for me.Presumably I would just have to pass TiHD or SpHD to the constructor, and then I would be able to use the object to indirectly modify the array with extended functionality (similar to using a Graphics object to modify a Bitmap). Is there such a class?
I have a mail application. While sending to each recipient I am writing to an XML file named mail.xml. I use the following code:
Dim from As String = txtFrom.Text
Dim txto As String = txtTo.Text
Dim subj As String = txtSubject.Text
Dim body As String = txtBody.Text
[Code]...
I have been searching the net for information on backing up files to cd from vb.net application cannot find anything?
View 2 Replieshow to write such app? Or maybe knows some nice tutorial? I would like to use System.Net.PeerToPeer namespace, but everything I can find about it is MSDN which I can't read without getting mad. Or maybe using "old-school" TCP/IP would more efficient?
View 1 RepliesI am currently making an old school adventure game for a college project, it uses an Access database (dbGameStats) which has the primary key (gameStatsId) which is an auto number. The main form of the game holds the data bindings, dragged into text boxes, and the various screens of the game are shown over the top of the main form. So on the main form I have highscore and player name text boxes, bound to the corresponding database fields, when running the program, the user enters a name, the highscore field is altered as the game progresses and when the user exist the database is updated using this:
[Code]...
I have two files like this
File one
[2 11.63 39.7] X7.705 Y0.735 209.037
Open -209.037
18N694 P321 117461, 50374 100MIL;
[code]...
what i need to do is from file 1 let say my line is like this
[2 11.63 39.7] X7.705 Y0.735 209.037
Open -209.037
18N694 P321 117461, 50374 100MIL;
from the line i must take P321 and match with my File2 if i find the mathing line like this
12N709 11.3611 4.9474 P321 L6 BOTTOM 100MIL 43-CHISEL X11.3611Y4.9474 1922 0
then i must take the value beside P321 which is L6 and write it in my original file like this
[2 11.63 39.7] X7.705 Y0.735 209.037
Open -209.037
18N694 P321 117461, 50374 100MIL; L6
How we can do this. To get the P321 from my file 1 can i use regex pattern like this P*[0-9]. And how to match the regex pattern with file 2 write the content ?
i have made a program that converts a number you put into a text field into hex What i now want to is to be able to write that variable into the file as hex still [code]if that worked that is what i want to do but it doesn't can you help me
View 12 Repliesmy problem is how i can write this code
SCHTASKS /Create /S system /U domainuser /P password /SC MINUTE /MO 5 /TN rtest2 /TR calc.exe /ST 12:00:00 /SD 15/09/2001 /ED 15/09/2001 /RU runasuser /RP *
in .bat flle using vb.net2003?