i want to create a system that will trigger alert based on few condition, my condition is:the alert will trigger if there is a negative value for 2 consecutive years.example:1)negative amount for 20052)negative amount for 2006here is the code that i have for now
View 6 RepliesI am trying have a data grid selection populate a form. I am new to this.Basically I have a connection persistance object and I would like to call that and call a stored procedure with the value of the selection. The datagrid is bound to an object.
[Code]...
I have a listbox (20 Items) with multiselection and label that disply the selection and one button. So I wrote (it works fine)
[code]...
Now when I click on button the label show lets say Item2,Item5,Item10,How do I take off the last ","
somthing like that Item2,Item5,Item10
I used to do: Dim s As String = Trim(Label1.Text)Label1.Text = s.Substring(0, s.Length - 1) but it give me an error converting intiger to string
osheet.Range("A1").Select
'The line below is the one I would like to know how should I write it in VB.NET:
osheet.Range(Selection, Selection.end(xlDown)).Select
[code]......
I am using this code to select a folder.how to do the same kind of thing selecting a file instead of an folder.
Private Sub PathButtonB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PathButtonB.Click
Using FolderBrowserDialog As New FolderBrowserDialog
With FolderBrowserDialog
.Description = "Kies die Folder waar hierdie ResepteBoek die Kunswerke vir sy Resepte moet gaan soek."
.ShowNewFolderButton = False
[code]....
Found this:
Sub SurroundWithAppendTag()
DTE.ActiveDocument.Selection.Text = ".Append(""" + DTE.ActiveDocument.Selection.Text + """)"
End Sub
But I can't seem to figure out how to loop through each line of text in the selection.
See
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"
here i;m trying to select a date and time but i'm having problems can you see what i'm doing wrong Dim table = mydataset.Tables("Bookingen")
[Code]...
I want to end the selection in a rich text box.Example:
Sentence - "I was walking in the park and found a coin."
I want to select from "walking" to "found"
RichTextbox1.SelectionStart = RichTextbox1.Find("walking")
[code].....
I have 3 textboxes TextBox1, TextBox2, TextBox3 and a button, I want to do the followingIf I enter a value in TexBox1 and press the button, some text will be set in textbox2 and textbox3; if I enter a value in TextBox2 and press the button, some data will be displayed in TextBox1 and TextBox3.I have no idea how to make the code check if the textbox1 value is not null and the textbox2 value is null, to execute a certain statement and set a value to Textbox2 and textbox3; and if the value of Textbox2 value is null and the textbox2 value is not null, to excecute a certain statement and set a value to Textbox1 and textbox3
View 1 Replies[url]...Do you see the left perpendicular line. When I click on it appears some annoying selection around it how to disable it?
View 3 RepliesI 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 RepliesI am using VB.NET and I am trying to come up with some algorithm or some pseudo-code, or some VB.NET code that will let me do the following (hopefully I can explain this well):I have 2 collection objects, Cob1 and Cob2. These collection objects store objects that implement an interface called ICob. ICob has 3 properties. A boolean IsSelected property, a property called Length, which returns a TimeSpan, and a Rating property, which is a short integer.
OK, now Cob1 has about 100 objects stored in the collection and Cob2 is an empty collection. What I want to do is select objects from Cob1 and copy them over to Cob2. I want the following rules obeyed when selecting the objects though:
[Code]...
based on a selection of name and time i want to add a value or text in datagridview,but it doesn't return a value... this my code
Public
Sub Btnplanner_Click(ByVal
sender As System.Object,[code]......
I have the following in vb.net
<asp:RadioButtonList ID="rbEdit5" runat="server" RepeatDirection="horizontal" >
<asp:ListItem Value="1" >Yes</asp:ListItem>
<asp:ListItem Value="0" >No</asp:ListItem>
</asp:RadioButtonList>
I need to programatically select one of the 2 listitems.How do I programatically select say 'Yes' above in vb.net?
I have a telerik radgrid, like shown underneath [code]When I click one of the rows, it will display the password of the clicked row, like so:[code]That works fine. I am proceeding this way because the decryption of the password is a rather complicated and long process, so decrypting one password at a time is less time consuming, especially when the user doesn't need all the passwords.When I have the password displayed, I'd like to be able to select the password in the grid to copy it. Unfortunately, the radgrid will fire the "RowClick" item command once more, and the row gets de-selected. Therefore, I cannot copy the passwords. My question is: Is there a way to cancel the itemcommand of a radgrid under certain circumstances? I'd like to be able to disable the itemcommand event when the password is already decrypted.[code]
View 1 RepliesI have a listbox with two values, Current account and Deposit account.The current account has an interest rate of 7% and the deposit account 3%.I have 4 other textboxes. The boxes on the right is where the user inputs and the left side holds the value.
Account Type [ ] Listbox >>[Current account]
Deposit account
Investment Amount [ ] [ ]
Interest over a year [ ]
What I want for the Investment Amount is that if the user selects Current account, the amount invested will be automatically calculated with the 7% interest and the same for the deposit, calculation with 3% interest.And the Interest over a year textbox to show how much the interest will be over that year at the rate (whether its 7 or 3%)
I can change title of a selected Tab but I want to change the title of a tab witch is not selected but I want to change its title because I come to know that tab is loaded following code return me the possible New Title of the Tab but how to make changes ?[code]....
View 1 Replies