I'm having trouble getting a If Statement to work on a button.It will only work when on the "Form Load" section.Heres the If statement I'm trying to put on the button press event.[code]
View 19 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?
im just wondering how the try statement works. what i want to do is this: allow user to enter link eg "calc.exe" then open that link using shell like this: [code] if the user enters a name that the system doesnt recognises it glitches, so i thought i would try the try statement.
View 5 RepliesI am trying to understand how a for each loop works and am having some trouble. I am trying to create a program that will query a sql database, pull back the information and store it. I currently having it writing to a text file, and would like to take the information (such as name) and compare it to another list where the name is equal. However I am not exactly sure how the for each statement really works. I have looked at numerous sources and it doesn't make since to me as you can probably see from what I have put in here.
HTML
Public Class Form1
Public Sub newarrest()
Dim strsports As New System.Collections.Generic.List(Of String)
Dim employeelastname As New System.Collections.Generic.List(Of String)
Dim cnPodaci1 As New SqlConnection
[Code] .....
I'm creating a db tool for automatic database repairs i have the following sql statement:
[code]...
Where the 'BrokenDbFile' is the location of the db where data has to come from and the 'sqlString' = the access statement.it gives a error when i put it in a try the exception is of type OleDbExceprion and de message text is "De instructie INSERT bevat een syntaxisfout" in Dutch Where it says that the syntax of the INSERT INTO is not correct. but when i paste the string from my inteli snce into access it works fine.
I am converting old VB6 code to VB.NET with ADO.NET (OleDB). This is my query that will create a blank table when ran in VB.NET, but then works when ran directly in Access. This code presumably also works in VB6, as I am using the same SQL:
SELECT qryAsOf.name, qryAsOf.type, 0 as opt, 0 as swap
INTO qryCon
FROM qryAsOf
LEFT JOIN qryLinked on qryAsOf.c = qryLinked.lc
I feel like this has something to do with the left join and select into being together, but like I said it is only VB that has an issue with it, Access handles it perfectly.Without the INTO line, this query returns all 600+ rows.
This DOES NOT WORK:
cm.CommandText = "CREATE TABLE qryCon (etc...)"
cm.ExecuteNonQuery()
cm.CommandText = "INSERT INTO qryCon SELECT ..." '(rest of query above without INTO line)
cm.ExecuteNonQuery
This DOES WORK:
cm.CommandText = "CREATE PROC qryCon AS SELECT ..." '(same select as above without INTO, again)
cm.ExecuteNonQuery
The CREATE PROC that does work is fine, except I need to insert data into it later, so I get errors about how I need an updatable table. I really want the end qryCon to be a table, but I can't seem to get that to work :(
*However, when I do something like this (using the stored proc (renamed) above which, if viewed in Access, is full of data)
cm.CommandText = "SELECT * FROM storedProc"
dr = cm.ExecuteReader
[code]....
This DOES NOT WORK! By the way, I removed the concatenation in the query for readability. It is correct in the actual project.
I have developed an ASP page in Visual web developer that retrieves the data usingan AccessDataSource object. I have the following UPDATE Command:
[Code]...
I am having, and it may be related to another issue i am having, but im not sure.I have a form that all of a sudden stopped executing the formload event.i checked the initialize component method, stepped through it, and it runs fine.the formload has the handles clause on it. i put a breakpoint on formload and it does not stop on the sub header. so could it be part of this issue?::: every once in a while, the code parser breaks, and reads partial lines of code (designer generated code at that)...so an error that pops up is Error in line "clearBeforeFi" not recognized....in dataset designer code, it is reading half the line, seeing it as the whole line, and i get a thousand errors. I restart the IDE, and that is fine again.....
however, this formload thing does NOT want to go away.it shows the form, runs the initialize code, so it shows the form fine, but executes nothing.[code]...
I want my application to be able to be changed by the user. For example on my form I have the labels Blue, Red and Green but the user requires yellow and another colour which is unkown to me so they would have an ADD function which saves to the database so next time they login their colours are there as labels.
How would you pick up the name of the colour from the database? and place that into your code to create a dynamic control with the same name as the colour which is unkown?[coded]...
I am using VB 2008 .net3.5. I have a form with a datagridview. The datasource of the dgv is a BindingSource. The datasource of the binding source is an object and the datamember of the binding source is a List(Of T) from that object. On formload, I create a new object with new and give the list some values and Set the datasource of the binding source to the list. The dgv loads the data but I can't delete a row. The AllowUserToDeleteRows is set to true. I select a row and nothing happens. Just to be sure I went back and did the EXACT SAME PROGRAM with C# .net2.0 and of course the dgv allows me to delete a row.
View 2 RepliesI have a project which is 98% complete. Its basically a Shop(till) interface. I have a form that has tabs the first being the main till, second shows a listview with everything in stock and the quantity of items in stock. Im stuck on one part of the program where when the form loads it checks the stock and if any of the items have a quantity less than 5 for example than it displays a message box to the user telling him/her to order new stock, but im not sure exactly how to do that.
View 5 Repliesi have a issue when i load my ini to my listbox and 'this my load ini to listbox
im a As String = My.Computer.FileSystem.ReadAllText("movieextlist.ini")
Dim b As String() = a.Split(vbNewLine)
ListBox1.Items.AddRange(b)
try to scan for extentions it crashs, BUT if i do on formload listbox add every ext 1by1 it works. if i use the load and hit scan it crashes
Using FB As New FolderBrowserDialog
If FB.ShowDialog = Windows.Forms.DialogResult.OK Then
For Each Ext As String In ListBox1.Items
[code]....
I use a datagridview where the rowheaders frustratingly stay blank after I load the form. If I modify/add/delete anything the rowheaders pop up. then when I sort by clicking on a columnheader the rowheaders become blank again. all these actions (load/add/modify/sort) go through the same refresh function. I can't seem to figure out why the rowheaders sporadically show up. they should stay visible all the time. btw, datagridview.refresh() doesn't work
[Code]...
One of my clients is going from Server 2000, SQL 2000 w/ VB6 to a new environment of Windows SBS 2008, SQL 2005 standard 64bit, w/ Visual Studios 2005. We have a custom built app written all in VB that has been converted. We already took care restoring the databases and setting up the odbc and such. After conversion, the app threw a couple of errors, and warnings, which have been fixed. We have a formload function that is supposed to populate 2 fields with dropdown information. One is a folders list in outlook and the other is a send recipient. The Recipient field populates fine and the outlook email box does not.Here is the formload code. I can't figure out why this would allow one box to fill and not the other.
Private Sub frmProcessEmail_Load(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles MyBase.Load
'starts up email
start()
[code]....
is it possible to call form load event on button click
Following is the vb code i want same function in vb.net
Private Sub cmdaddcancel_Click()
Form_Load
[Code]......
in vb we simply call Form_Load is it possible in vb.net
For eg: IN VB.net currnetly i am on form no 1 and there is one button on click of dat button i want the current form should again load is it possible
The Title says it all Adding Multiple Checkboxes on FormLoad Depending on Amount of Items In Database. [code]
View 4 RepliesI have a spreadsheet with this code:
'insert link
sheet1.Hyperlinks.Add(sheet1.Range("P1"), "http://http://www.vbforums.com", "")
the code of the button (ribbon)
[CODE]...
When I press the button, it connects to the web site. when the sheet1 is selected, it works, but when the sheet2 is selected, not works, why? the path is sheet1,What's wrong?
this is my code:
Dim WB As WebBrowser
WB = GetPage("http://speed.travian.ir/a2b.php?z=" + VillageID.ToString + "&c=" + Type.ToString + "&" + AttackParams)
[code].....
I'm currently having a problem dragging and dropping my label1.text to a richtextboxt which isn't created on design time...well im currently found a solution but i think it is only for a temporary solution because i use a drag and drop i drag it to a textbox then it willl transfer the data to the richtextbox....through the use of the textbox... here is the code ive come through..[code]...
View 2 RepliesI 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]....