I would like to get some input as to how I would create the same code without a dreaded "goTo" statement. This is something i've wanted to get an answer to for a while and just thought about it again.
[Code]...
I have process that needs to create a bunch of records in the database and roll everything back if anything goes wrong. What I want to do is this:
[Code]...
I just want to know whether there is any method to return from a goto statement.
[Code]...
I wanted a good example of the GOTO statement, I really want to know how to imply the goto statement in my future projects.
View 7 RepliesI have a for each item in listbox:
try
'code goes here
catch ex as exception
end try
next
now, in my code, i also have if ex = certain error. i'd like it to go back to the top of the try. reason for not letting it do its thing is, i am wanting it to retry it, under the same item. So, is there a way to goto a portion of the code.
i was trying to make a free microsoft word plugin in vb.net. It automatically fills a web form. The main problem with the plugin is that it uses web browser control and once it has filled a form it will need to navigate another form. The form can only be filled once it has completely been loaded.so my approach is
1. navigate to first site when form loads
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
WebBrowser1.Navigate("http://google.com")
End Sub
2. use an integer i and use if statements to check which form to fill :
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEv entArgs) Handles WebBrowser1.DocumentCompleted
If (i = 1) Then[code].....
3. this is the main step. you see when main form loads, i=1 so browser goes to google.com (first form), when form is completely loaded, itchecks for value of i. Since i=1, it fills google. After filling and continuing i=2 and browser goes to my personal account page. This means browser again loads the document. Now i=2, so it fills my personal detalis. Now the timer starts. Since i=3, browser navigates to second site and fills the details.
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
If (i = 3) Then
WebBrowser1.Navigate("http://blogger.com")[code]...
now the problem arises. The browser does not go to the third site. Once the timer has been stopped and started, the following code does not goto the elseif part (i.e. i=5) why is that so?
I've seen a few people on here saying that you shouldnt use GoTo in VB.NET and to be honest I've tended to agree as I have never needed to use it and there is always another way of doing something without using it. However, I'm just wondering what is so bad about it? I actually noticed that Microsoft seem to use it a fair bit in the internal .NET framework code, which is what makes me wonder why people are so against it.
View 26 RepliesI have an SQL statement which i need to code in vb:
CODE:
Notice the fields prodno1 and prodno2 in the table structure.. this is part of a number of sql statements i need to run and put inside a loop. my problem is i want to automatically use this same code such that on the next loop, this sql statement is going to be:
CODE:
Note that in this "2nd loop"
- the table name is now r3 from r2 in the first SQL statement
- there are now prodno1, prodno2 and prodno3 instead of just prodno1 and prodno2
- in the WHERE clause, the p.prodNo becomes p.prodNo2
And so on and so forth.. so for the 3rd loop
- there's going to be r4
- there's going to be prodno4
- in the WHERE clause i will use p.prodNo3
I'm currently making a code that will login to a cisco router, and show the version, then return the version to me. The connection to the cisco router is using telnet, and I'm using Dimac's w3Sockets code to Connect, login, and return data. Reference
But currently I'm having some problems, since the router sometimes need the login typed 2 times, or having a key pressed to update the terminal(telnet),meaning i have to check if it gets logged in or not. But the problem is that using dimac code, i can only wait() and waitFor(), and if it none data comes whilst waiting, it keeps on waiting. Is there away to do like: "if wait fails goto"
I've tryed "on error goto", but since its not a error, but just keeps waiting, that dont work. Also, To locate where it gets stuck I have it write to my textbox everytime it takes a step in the code, but its like the dimac code overtakes vb.net. ex: If i send some text to a textbox in the same sub as the connect code is, and it gets stuck at a wait, it dont even write to the textbox, eventhough the textbox.text command was suppose to execute before the wait().
Code:
Private Sub telnet(ByVal port)
TextBox3.Text = TextBox3.Text & Environment.NewLine & "Telnet func Called" 'Cant execute this if it gets stuck at login below. ??
Try
[CODE]...
We have an application that has a memory leak. The leak occurs when we run batch processes that utilize objects in a COM library (ArcObjects by ESRI). It's not real noticable when the batch is small, but when it gets into several hundred interations the memory leak gets into the hundreds of megs.
We've looked over everything and made sure we're doing Using... End Using where possible. We've made sure all our objects implement iDisposable and explicitly dispose of their COM references in the Dispose method. We've put in explicit calls to the garbage collector. My development lead has fretted and pulled his hair out on this one for two years. Still the leak remains.
Today I noticed something strange. I ran a large batch process and the app had grown to several hundred megs in size. I had the task manager up with the app - looking at them at the same time. I moused over the 'close' button on the app and suddenly the app dumped about two thirds of it's RAM. Mind you - I didn't actually press the close button, just moused over it.
So something happened inside the app that caused it to clean itself up, but I don't exactly know what. If we could find out what happened maybe we could plug this leak.
I'm typing this up only to document it and possibly save others the three days of frustration and hell I had to go through. Because this unhanded exception was damned near untrappable (it happens on Form.Show(), but since my primary form was affected, I couldn't tell at the time), it's one I know I lost a lot of hair nailing down.
I have an office application. Standard fare utility program that grew to do lots of custom tricks for my place of business. Lots of database providers to pull data from various unconnected sources and crystal reports to make fancy reports from it all.
When I make a change or addition to it, it usually is only needed by one employee, so I only deploy the new version to one computer at a time. Recently, I had to reinstall the program to the whole company. Everything was going fine, until somebody who had a Windows XP machine tried to run it. It was giving a "clr20r3" "System.InvalidOperationException" on program boot. None of my Try-Catch blocks were catching it. Any Windows XP machine I installed it on was failing, and any Vista/Win7 machine had no issues at all.
I spent the next three days trying to catch what was causing it, pulling out references, reinstalling .NET. Searching for references to this error online was futile since System.InvalidOperationException is one of those ultra-generic errors that pop up for hundreds of oddball reasons.
Finally, by happenstance, I found the cause via a single, obscure post on TechArena by a poster with only that post to his name who decided to chime in with his two cents on someone else's System.InvalidOperationException problem.
About a month ago, I replaced the program icon with a new one. I made up a nice Icon, and compiled pre-sized versions of it into a proper .ICO file from 16x16 all the way up to 256x256. I replaced the program icon with it, the links to the shortcuts in the setup program, and the icon on the main form.
THAT was the bug. Because my .ICO file had sizes larger than 64x64, Windows XP couldn't handle it as a form icon! It works fine for the program icon and for the shortcuts, but the form icons MUST be 64x64 or smaller or the program will throw System.InvalidOperationException on Form.Show(). I didn't know this was the issue since this change was over a month old and I hadn't needed to upgrade a Windows XP machine in that time. Windows Vista and 7 can handle large icon files just fine!
Solution, I made a second, WinXP compliant icon just for the main form. Problem solved. My big icon is still used for my program and shortcuts, so they look great scaling to max size in Windows Vista/7 and XP no longer crashes with a cryptic error message.
I'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 RepliesTo create a program that asks for input then uses an else statement to create a handling fee balance.
Input: sales record - first name, last name, purchase amount, balance before purchase
Output: report - full name, old balance, purchase amount, handling fee, new balance
Definitions: handling fee is 5% of the old balance if the old balance is less than $1000.00 else it is 2% new balance = old balance + purchase + handling fee
Processing:
Ask for and receive sales information
Calculate new balance
Print output report
End the program when a purchase amount of 9999.99 is entered
It looks like this: Itis stripping out HTML characters.
Imports System.Text.RegularExpressions
Function GetTextFromHtml(ByVal htmlText As String) As String
[code].....
I have 3 tables: Users, Plan, Organization [code]What i want is when a user logs in, and opens frm.Plans to only allow that user to view Plans for his/her company. This is the sql statement i have currently:"Select Plan.*, Organization.*, [Users].* from Plan left outer join Organization ON Plan.Plan_Name = Organization.Company_Name inner join [Users] on [Users].Company_id = Organization.Company_id where [Users].UserID = current_user and Plan.Plan_Name like '%'+@Organization.Company_Name+'%'"My login code is also posted in this forum with the title "Login Permission".
View 14 RepliesIve got my pdf file to open but i need to open the document on a specific page. button 4 is an accept button/ user clicks it searches and opens files.
im using VB2008 express my code is:
Dim readfile As String = ("C:Program FilesRimless Data SheetsApplication FilesRimless Data Sheets_1_0_0_4shape file pdfsShapes files")
Private
[Code]....
I am trying to create a session after the else statement. How do you create a session and for it to be read by another file ?
Dim conn As MySqlConnection
'connect to DB
conn = New MySqlConnection()
[code]....
I Have A form With With Data source DS1 Is There A Way To Filter The DS1 To Show A Specific Record Parameter Input Textbox
View 2 RepliesI'm just wondering why using GoTo<label> is so frowned upon?I'm learning VB, and I want to develop good habits as I go. One thing I don't entirely understand, is why everyone avoids GoTo like its the plague (except in error handling...). I feel like GoTo could be useful in some situations.
View 1 RepliesIs there a way to make a listview select an item based on what a user types? for example, If i have a listview with a column (last name), and the Listview is in focus, I want the user to be able to start typing and have the row select move to the row that has the letters in that column
View 4 RepliesI need to standby the remote computer(windows 7) in given time.
there are Server and clients... From server machine I need to standby(windows 7) the client system given time.
I created a sql query to check if the mobile number is registered or not. If its registered, it will send the new pin code to the customer and if its not, the customer will get a message that "This number is not registered or you are not authorized to this"... something like that... Sending of new code is already working. I just dont know how to make it as conditional statement like PHP. After you query on PHP, you can just set a variable and make a conditional statement..Here is my script in vb.net:
Private Sub CheSMS()
Dim SQLServer As String = My.Settings.SQLServer
Dim conn As SqlConnection[code]......
how to create a conditional statement if the value of rows is zero or not.I want my output to something like... IF the value is zero, an sms message will be sent to the client that he is not registered ELSE an sms message will be sent containing his new autogeneration code. Been working on this for a month but i have no luck.
Here's my code:
Private Sub CheSMS()
Dim SQLServer As String = My.Settings.SQLServer
Dim conn As SqlConnection
Dim cmd As SqlCommand
[code]....
Option Explicit On
Option Strict On
Option Infer Off
[Code].....
For example, 10 people cost 800, 11 people the cost goes down to 770.
well i am not that good at the programming i was about to make a small program that allow me to change a character to another , like if the whole text contains the litter "a" in some places i would like to change it to other character in the same places they are, but instead of having it in the same text box , the program transfer it to a label with the changes i maid
View 23 RepliesIn my first application I need to create a multi-level "IF" statement and I am a little lost on how to proceed. The idea is to do figure out an estimate on costs based on the quantity of products being sold. I can do this in Excel, but the VB code escapes me.
So I'll show you in psuedo code what I want to do.
IF comboBoxA = 1 and comboBoxB = 1 then
value X
IF comboBoxA = 2 and comboBoxB = 1 then
value X
If comboBoxA > 3 and comboBoxB > 1 then
(comboxBoxA * costA) + (comboBoxB * costB) = Value X
I have another IF statement that will work off the calculations here. Haven't figured this one out yet, but I haven't gotten there yet in my form.
If Value X > Y Amount then
Offer product Z as a better idea
i need to create a xml file to be used for translate from english to spanish, i have create the file using sql server since i have data on my server this is how it looks
<row ENGLISH="" SPANISH="" />
<row ENGLISH="Align" SPANISH="Alineacion" />
<row ENGLISH="Body Motion" SPANISH="Movimiento del cuerpo" />
<row ENGLISH="Cut" SPANISH="Cortar" />
<row ENGLISH="Distance" SPANISH="Distancia" />
I'm trying to create a quiz system and I have 200 question stored in question table.I have two quizID which is 1 and 2. Each quizID have about 100 questions. I trying to randomly select 50 question from the 100 question.
SELECT [QuestionID], [Title], [Answer1], [Answer2], [Answer3], [Answer4], [CorrectAnswer]
FROM [Question]
WHERE ([QuizID] = @QuizID)
ORDER BY NEWID()
I only want to return a certain number of rows into the DataTable via LINQ's Take or use it on the Rows property, but I am not sure how or where to do it: Here is the current code:
Dim dt As DataTable = GetDataTable("sp", params)
For Each dr As DataRow In dt.Rows
Dim o As New OR()
[code].....
How would you go about reducing the code for this but still allowing it to work the way it is now
Dim updatelesson As String = cmbChange.SelectedIndex
Dim chosenlesson As String = cmbSession.SelectedIndex
Dim changed As String = lstNames.SelectedItem
[CODE]....