the testBoolean is set to the value True, but for some reason when debugging, it step through both conditions, so in the end the button1.visble becomes False, but I want it to be set to True.[code]....
View 14 RepliesSo I am trying to evaluate 3 conditions in an if statement. Its not working how I would assume it should. I basically want to do this:
vb.net
If PGN = &HEF007E And PGNData(0) = &H58 And (PGNData(1) And &H40) = &H40 Then IgnOn = True Else IgnOn = False
If I write it in that manner it gives inconsistent results. If I workaround by writing it this way it works perfectly:
vb.net
If PGN = &HEF007E And PGNData(0) = &H58 Then
If (PGNData(1) And &H40) = &H40 Then IgnOn = True Else IgnOn = False
Endif
What is the proper way to do this with only one if statement?
I am trying to figure out how to test two conditions in a Case Statement.[code]...
View 2 RepliesI currently have an If...Then statement that checks if all fields of a form have been filled before saving the info in a file. I'd like to be able to tell which field has not been filled to give the user a dynamic message (at the moment, it only tells them that the checklist is not completed ) :
If (txtNoDemande.TextLength = 8 _
Or txtNoDemande.TextLength = 13 _
And txtDateLoad.TextLength <> 0 _
[CODE]...
Is there a way to determine which of these conditions is false without having to do a seperate If statement for each ?
I am trying to write a Function which will return a data table, filled with a data from a database.
The Function will accept 6 diffrenet parameters as Optional. Each one of them will be an additional condition to be added to a where clause, if it`s provided when the function is beeing called.
Is there any method in .NET to simply add a new condition to the where clause?
I'm working on my first project using LINQ (in mvc), so there is probably something very simple that I missed. However, a day of searching and experimenting has not turned up anything that works, hence the post.
I'm trying to write a LINQ query (Linq to SQL) that will contain a multiple number of conditions in the where statement separated by an OR or an AND. We don't know how many conditions are going to be in the query until runtime. This is for a search filter control, where the user can select multiple criteria to filter by.
select * from table
where table.col = 1
OR table.col = 2
OR table.col = 7
'number of other conditions
Before I would just construct the SQL query as a string while looping over all conditions. However, it seems like there should be a nice way of doing this in LINQ. I have tried looking using expression trees, but they seem a bit over my head for the moment. Another idea was to execute a lambda function inside the where statement, like so:
For Each value In values matchingRows = matchingRows.Where(Function(row) row.col = value)However, this only works for AND conditions. How do I do ORs?
I 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?
Public Class Inventory_Edit
Private Sub Inventory_Edit_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CategoryDataSet.Category' table. You can move, or remove it, as needed.
Me.CategoryTableAdapter.Fill(Me.CategoryDataSet.Category)
[URL]
I added an "edit" icon on my bindingNavigator. When users click on it, a new form will come out and pull out all the data records from the datagridview. Now the strange thing is that when I wanted to edit the data records, when I left the product name blank, I would get an error message saying "Product cannot be blank" - please see above code. But when I left the "Cost Price" blank(same applies to "Sell Price" and "Quantity"), the error message box wouldn't come out, instead, it did not allow me to move on to another textbox, close the form etc until I filled out that textbox with INTEGER. May I know why the error mesagebox would not come out when I entered the wrong datatype?
I am very new to vb, I know there is an error somewhere, I had an assignment which stated that if a number was < 101 or > 500 and the answer is correct the output should be, for example-123, if the answer was wrong then the message output should be wrong number <101>500. Everytime I type in a number(no matter what the number) and click on my check button I get the output message. If at all possible, can you please assist. My professor gave the following example, but I am still not getting it:
Dim strInteger As String = "52.801"
Dim dblNumber As Double
dblNumber = CDbl(strInteger)
[code].....
I want to use a value that is pulled from the SQL within the if statement. Ideally i want to do the equivalent of <% If DataBinder.Eval(Container, "DataItem.BookID") == 1 Then%> Is there a way to do this with the correct syntax?
View 2 RepliesHow to combine these two conditions in one section
Private Sub DataGridView1_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles DataGridView1.CellValidating
'condition 1
' check given value is numeric or charactr type
If e.ColumnIndex = 3 Then
If Not IsNumeric(e.FormattedValue) Then
DataGridView1.Rows(e.RowIndex).ErrorText = " must be a numeric value"
[Code] .....
'condition 2
' check given value is greater than 0 or not
If e.ColumnIndex = 3 Then
If (e.FormattedValue.ToString = "0") Then
[Code] .....
I have and existing .rdlc file where I display the grades of each students as well as the general average. I get general average like
=FormatNumber(Switch(Fields!YearLevel.Value="LC7" or
Fields!YearLevel.Value="LC8",(IIF(Fields!SectionName.Value<>"1st Sec A" and
Fields!SectionName.Value<>"2nd Sec A",
[code]....
I want to display:
"1st Honor" if gen. ave is >=90 but all the subject grades must be >=90 also
"2nd Honor" if gen. ave is >=88 but all the subject grades must be >=88 also
"Third Honor" if gen. ave is >=85 but all the subject grades must be >=85 also
How do I do it?
Having problem make last if an statement work in the code. the variables in the if statment are doubles but the ide keep telling i need a proceeding if statement. but is already there it is in the last if statement of the code
Public Class Form1
Dim Totals As New List(Of Double)
Private Sub btnclear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE].....................
I'm doing a stock Control System as a school Project using An Access 2007 DB and Visual Studio 2010. I'm trying to do an update Query based on two variables entered into comboboxes, I cannot get the VB to accept the conditions for this, Can anyone Help me?[code]I Cannot get the Code to recognise the Last "'", is there a way to do this?
View 7 RepliesThe following code is looking for the phone number of contacts in a database when the column "hoohoo" = 15. However it doesnt keep to this condition, but displays all of the numbers. Am i missing a line that tells it to keep to the condition???
Dim SQL As String = "SELECT *, Phone FROM TblContacts WHERE Hoodoo=15"
Dim myOleDbCommand As New OleDb.OleDbCommand(SQL, con)
con.Open()
[Code].....
client2 so like this my treeview has be displayed.i can able to display the value in my treeview.my requirement is i need to keep image for the treeview nodes. for example Group1 - sample1.gif server1 -sample2.gif client1 -sample3.gif so i need to keep images to this nodes at run time and i need to chage the image depeds on my need. for example in some situation i will keep sample2
View 3 Repliesi want to set 2 conditions for a for loop as i want to loop through the same line of code at the same time . here it is as i have it now
it does not work how i want it to as i want both loops to run simuntaneously instead it runs the first loops continuously before the second and way around this?
For Me.i = 0 To maxrows - 1
For Me.h = 1 To maxrows
Me.Controls.Item("TextBox" & Me.h).Text =
[Code].....
I am trying to combine 2 regular expressions into 1 with the OR operator: |
I have one that checks for match of a letter followed by 8 digits:
Regex.IsMatch(s, "^[A-Z]d{8}$")
I have another that checks for simply 9 digits:
Regex.IsMatch(s, "^d{9}$")
[Code]...
Apparently I am not combining the two correctly and apparently I am horrible at regular expressions.And for those wondering, I did take a glance at How to combine 2 conditions and more in regex and I am still scratching my head.
how can we add images in treeview using vb.net. Different images in different conditions .
View 1 RepliesI am using VS2008 and VB.NET. Can someone provide or point me to info on how to add a Terms and Conditions form to an installation? The user would have to accept in order for the installation to continue or else cancel installation.
View 2 RepliesI am developing a website on writing reports ...users can comment on a report (huh!! as if a new thingy ;))..back to question..what am doing is showing the comments using a listview.
Question: i want that when someone comments on his own post the row should be of different color, so that its clearly visible that the post owner has commented...I have seen this in Scott Guthrie's blog.
deal with ever changing SQL queries based on various conditions? i am using Cmd.BindByName = True so it doesn't need to be in an ordered way when adding parameters. Just that this is the hectic way of doing the update SQL ..or even worse insert SQL/I favor doing parameters instead of using stored procedure bcoz i find it faster by using parameters .
SQLStr.Append("Update Table set col1 = :time ")
Cmd.Parameters.Add("time" , OracleDbType.Varchar2)
Cmd.Parameters("time").value = "xxx"
[code]....
Using the Application Framework in a WinForms Project, I need to check conditions to determine whether the application should run at all and if it shouldn't run then I need to kill it before it even shows the main form. My conditional checking is occurring at the MyApplication.Startup event handler, so all I need is the method that shuts down or kills the current application.
I'm pretty sure this question's been asked a thousand times, a few of those even by me, but I can never remember the right language to get any useful info out of a Google or MSDN Search string.
It never hurts to try. In a worst case scenario, you'll learn from it.
I've recently started running into DotNET difficulties with newer HP and Dell systems that are pushing x64 processors and operating systems onto a totally unaware end-user market, so suddenly a lot of work I've done in VB.NET is going to ____ in a handcart; specifically all the work I've done with 3rd Party tools that are only available in x86 or x64 builds and not DotNET Native builds for any CPU. The biggest problem is that all the DLL File Names, in-code Namespaces, Classes, and Methods are totally identical - just one version is compiled for 32 bit and one for 64. What I need to do to fix this is provide some #If compile conditions that alter the paths of existing references based on the Build Configuration, so that when I'm compiling for the x86 platform it references C:DBAPISQLitex86System.Data.SQLite.DLL but when compiling for x64 it references C:DBAPISQLitex64System.Data.SQLite.DLL.
I don't have a problem writing compile conditions, but can't figure out how to alter the reference paths before the compile begins, short of manually removing one reference and adding the other every single time I need to do a dual-platform compile.
I'm working on a piece of code at the moment that allows the user to enter values into fields. Once the user clicks on the 'save' button I am checking those fields against certain conditions (essentially calling a bunch of stored procedures to assess the values). If any of these 'rules' are met, I need to generate a popup that informs the user that certain values need to be fixed before they can continue for some of the conditions, and for others just to inform them of what conditions may need their attention. how do I generate a popup box in my codebehind if the conditions are met?
View 1 RepliesI have been programming an activation type of security protection for my software but i ran into problems when i try to generate an alphanumeric key with conditions. i cant seem to be able to make the keys to be valid with the condition.Basically i can get the 25 keys but all of them seem to be returning 1(ones) instead of 0(zero which what i want. below is my sample code may be someone can tell me what i am doing wrong, by the way i did google, woogle,bing, bang, yahoo, yadoo etc but no go.
generate the keys
Public Function GenerateCode() As Object
Dim IntRnd As Object
Dim IntStep As Object[code]....
the damn thing keeps returning 1 instead of 0. I do know i can simply change to 1 and be off the issue. but if is that easy to generate 1 the isnt easy just to break it. oh yeah the whole thing hangs when i generate the code? if i loop it, its able to get a 0 but i cant take the key thats in the loop?
I have been programming an activation type of security protection for my software but I ran into problems when I try to generate an alphanumeric key with conditions. I cant seem to be able to make the keys to be valid with the condition. Basically I can get the 25 keys but all of them seem to be returning 1 (ones) instead of 0(zero which what i want.
Code:
generate the keys
Public Function GenerateCode() As Object
Dim IntRnd As Object
Dim IntStep As Object
Dim StrName As Object
[Code] .....
The damn thing keeps returning 1 instead of 0. I do know I can simply change to 1 and be off the issue. but if is that easy to generate 1 then isn't it easy just to break it. The whole thing hangs when I generate the code? If I loop it, its able to get a 0 but I cant take the key that's in the loop??
How would I perform this SQL query
Select Distinct s.*
from #ScopeIDs x
Join Scopes s on s.ScopeID=x.ScopeID or x.ScopeID is null
in LINQ to SQL? (This query would return all Scopes whose ScopeID is present in #ScopeIDs, unless one of the entries in #ScopeIDs is null, in which case it returns all Scopes).
A "literal" translation doesn't work, since LINQ doesn't support joining with multiple conditions - code along these lines ...
From x in ScopeIDs
Join s in Scopes on s.ScopeID equals x.ScopeID or x.ScopeID equals nothing
Distinct Select s
... doesn't compile.
Basic out line connecting to an irc server. We connect to this server using a TCP client on a separate thread from the UI. Now the raw numeric for the MOTD is "372" so when our streamreader reads this value from the worker thread it raises it's value and displays it to a RTB. Now my issue. When i connect to a server i wait till raw "372" before i check to see if i need to join a channel. But a lot of servers have more then then one line MOTD each sending there own "372". So if a server has a long MOTD that could mean over 100 "372".
Now while it does not effect the UI of my app i wish to move the "372" to it's own thread from the current worker thread. But thats the problem. How do i move the MOTD to it's own thread when it's still being read.
I am trying to link to a Access database at runtime using a SELECT FROM WHERE query, which I can do but.......
with the WHERE part I want to select several conditions, 4 actually and it is not working, what am I doing wrong?
Here is my code,
Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=V:GYMDBFLineProdSanderProduction.mdb")
[Code]....