Use Less Condition For Many Condition?
Aug 10, 2011i mean for e.g., numbers are between 1 and 100 .i want to show messagebox for each number as text for example "One" for 1.
View 1 Repliesi mean for e.g., numbers are between 1 and 100 .i want to show messagebox for each number as text for example "One" for 1.
View 1 RepliesI had posted this question before but didn't get the right answer -here's my code again with the if condition.
Dim provider As CultureInfo = CultureInfo.InvariantCulture
Dim a1 As DateTime = Nothing
If date1.selectedvalue isnot nothing Then
[code]....
I have a problem. 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. below is my sample code may be someone can tell me what i am doing
[Code]...
I have the following code which gives me an error at run time. The problem is when TxtSearch.Text - is not an integer a message box should be prompted saying- Only a numeric value is allowed in this field, otherwise continue with the sub.
Private Sub ButtonSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonSearch.Click
Dim query As String
[Code].....
The error I receive is showing ''saved_prac = cmd.ExecuteScalar()''..
First it brings the Message box - Only a numeric value is allowed in this field. When I OK it, then it brings another message box "error converting data type varchar to numeric". When you click OK the application crashes...
What is the correct syntax to go to the next sequence in a loop if certain conditions are met bypassing the contents.
I am using goto and inserting a line number which is probably not the best way.
I.E. My syntax:
For i = 0 to 100
If i = myvariable goto 100
Functions to be performed
[Code]....
When I am click a button every time adding +1 in a textbox but I want to give condition that it will add until the desite is 8 I am using the following code
If e.KeyCode = Keys.Down Then
textbox1.text = Val(textbox1.tex)+ 1
End If
I'm trying to read data from database.
If objReader.Read = True Then
If objReader("cell") IsNot DBNull.Value Then
Me.txtContact.Text = Trim(objReader("cell"))
[code]....
Problem is, no data displays if cell is empty.
my problem is that i want to put if condition on textbox for example i want if key board keypress on textbox then enter no in textbox
[Code]...
I use a worker thread to do the procedure of query and fill the datasetAnd I use 3rd party component called DevExpress XtraGrid: GridControl to view the query outputI don't forget to use invoke and delegate to set the GridControl.datasourceOn Timer.Tick(), the thread is started and the procedure is called user has scrolled down the GridControl, even only one scroll value instead,and then the Timer.Tick() fired, I gottwo errors randomly. Mostly aNullReferenceException error and eventually anInvalidOperationException error
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at DevExpress.XtraGrid.Views.Grid.ViewInfo.GridViewInfo.UpdateCellAppearance(GridCellInfo
[code].....
Scenario: I need to create a report for the auditors for an ASP.Net application. I have a program that parses the XML of the web.config files in a directory for the authorization tag and creates a report providing which users have access to which folder in the site structure. The report is shown below.
UserName, Firstname, LastName, Directory, Roles, Access,
LastLoginDate
Problem: As you can see from the report some directories (the middle column with GISMO in it) show up twice, with both allow and deny for a user. I am wondering if there is a way to group the results in such a way that if there is a row that has allow for a directory then the deny's are not shown but otherwise they are.
Alternatively if this can be manipulated in VB.net/C# that is also an option. It comes back there and is pumped into an Excel spreadsheet.Edit: I should have explained better. I still need the deny rows to show if the user isn't allowed in the directory. But if they are allowed then there is no point showing the deny rows.
I am developing an application to my official use. In which I have one combo box for selecting the customerName.When I select the custName from the combobox I want to retrieve data from a particular field of a table and sum it within a selected date value. i.e: When the user selects a custName from the combobox the field within the date value should be summed up and grouped by custName. I think it is possible but I dont know how it is to be done.
View 10 RepliesI think im going mad but can some show me what im missing, it must be some stupidly simple i just cant see the wood for the trees.BOTH side of this if then else statement are being executed?
Ive tried commenting out the true side and moving the condition to a seperate variable with the same result. However if i explicitly set the condition to 1=0 or 1=1 then the if then statement is operating as i would expect. i.e. only executing one side of the equation...
The only time ive seen this sort of thing is when the compiler has crashed and is no longer compiling (without visible indication that its not) but ive restarted studio with the same results, ive cleaned the solution, built and rebuilt with no change?
Dim dset As DataSet = New DataSet
If (CboCustomers.SelectedValue IsNot Nothing) AndAlso (CboCustomers.SelectedValue <> "") Then
Dim Sql As String = "Select sal.SalesOrderNo As SalesOrder,cus.CustomerName,has.SerialNo,
[code]....
I have one datagridview with first column may contain checkbox or could be empty space depending upon data in second column. How can I put checkbox or keep it empty in first column whever required ? Checkbox column puts check box in all cells of first column.
View 1 RepliesIn aspx page:
if (<%= Not Me.ThisVisa.PassportExpirationDate.IsNull %>){
Returns error:Microsoft JScript runtime error: 'True' is undefined
I tried this:
if ("<%= Me.ThisVisa.PassportExpirationDate.IsNull.ToString %>" != "True"){
..but I get a compile time error:
Error 5 Option Strict On disallows implicit conversions from 'String' to 'Long'
I've got this function which converts wav files to mp3. I call this from my button_click handle. The thing is, when the conversion is started, the rest of the code in the button_click handler continue, while the conversion is happening in a different thread. Now, I need the rest of the code in the button_click handle so continue to try until a boolean is true, so that I know that the conversion is done before the rest of the code continues. I've tried using Do While but it didn't seem to do the trick. Perhaps it's just me though..
View 2 Repliesas the title says , for example i want to say if the first letter in textbox1 is "d" then do a specific command ,so what is the code for this ?
View 2 RepliesI have form on VB2008 and Mysql as Database which have 24 textfields on a form.I want to impose certain condition that when ever user adds/updates/modifies data into database for example You may have entered text in a numeric fied or a number that is larger than the fieldsize setting permitts. if violates message box should appear with Invalid entries
View 5 RepliesSo I have case statements grouped together here, but I have a few case statements that need extra decision based on a second variable after the original case is confirmed. [code] And then just have 3 case statements instead of one but the code wouldn't look ugly. By the way Condition is declared instead the same select.Is there any reason why I shouldn't use this if it does work?
View 3 RepliesHow Can I Row Filter with a condtion on colam where Coloum1 = > 0
View 2 RepliesI have a String variable in this page named "a".I wanted the scenario to be.When the page is started "a" will be null.But when the user selected an entry from the DetailView Control "a" will become "have".The following is my code. But i keep getting "a" = null even though i have selected an entry from the detailView control.[code]
View 2 RepliesMy problem consist in show values into a cell of a DGV control, for example:MySQL Table:
ID - Name - Price - Type
1 Mouse Pad 2.85$ - a
2 Keyboard 10.50$ - a
[code].....
I'm trying to format a label based on it's value and I'm having difficulty making the font bold. All other formats work apart from the "bold" part. Here is my code:
Private Sub SchoolTxt_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles SchoolTxt.TextChanged
If SchoolTxt.Text = "Invalid DfE Number!" Then
[code].....
i set this code in my mainform form_load Tabcontrol.Tabapages.clear()when i close all the open tabpage from the tabcontrol. there is still a window left of tabcontrol although its empty. it annoys me because i cannot see my mainform wherein it has a design, i cant see it bcoz of that empty tabpage window from tabcontrol.
View 4 Repliesi want to validate many textboxes with same condition....Do i need to write code for each text boxes.
View 1 Repliesi have 1 query with aggregate with condition using access
SELECT
HD.No,
SUM(IIf(DT.Status = 'A', 1, 0)) AS One,[code]...
i can run it in access but not in .Net QueryBuilder
I am trying for a message box to pop up but this code gives me always "Absent".
Dim time As Date
Dim CurrHour As Integer
Dim CurrMinute As Integer
time = DateTime.Now
CurrHour = time.Hour ' Get current hour value
CurrMinute = time.Minute ' Get current minute value
[Code] .....
So I have a few variables in an array a I want to compare another variable to each of them, if it is the same do something, AND STOP THE FOR LOOP. else carry on the for loop. So...
for i = 0 to 4
if variable = a(i) then
do some stuff
[code]....
how do i end the for loop from within an if statement that is in the for loop
how can i put datagridview checkbx condition
i have a datagridview and datagridviw culumn(0) is checkbox
if datagridview culumn(checkbox) is true then code working and the datagridview culumn(checkbox)= false then msgox show("first select any one row")
give me a code without using currentcell(0) and selectedcell(0)
because in this datagrigview to many rows thats why i can't use currentcell or selectedcell or selected row
I have two array I'm trying to compare at many levels. Both have the same structure with 3 "columns.The first column contains the polygon's ID, the second a area type, and the third, the percentage of each area type for a polygone.So, for many rows, it will compare, for example, ID : 1 Type : aaa % : 100..But for some elements, I have many rows for the same ID. For example, I'll have ID 2, Type aaa, 25% --- ID 2, type bbb, 25% --- ID 2, type ccc, 50%. And in the second array, I'll have ID 2, Type aaa, 25% --- ID 2, type bbb, 10% --- ID 2, type eee, 38% --- ID 2, type fff, 27%.So, my function has to compare these two array and send me an email if there are differences.(I wont show you the real code because there are 811 lines). The first "if" condition is [code]I have two different layers in a geospatial database. Both layers have the same structure. They are a "spatial join" of the land parcels (55 000), and the land use layer. The first layer is the current one, and the second layer is the next one we'll use after 2015.So I have, for each "land parcel" the percentage of each land use. So, for a "land parcel" (ID 7580-80-2532, I can have 50% of farming use (TYPE FAR-23), and 50% of residantial use (RES-112). In the first array, I'll have 2 rows with the same ID (7580-80-2532), but each one will have a different type (FAR-23, RES-112) and a different %.
In the second layer, the same the municipal zoning (land use) has changed. So the same "land parcel" will now be 40% of residential use (RES-112), 20% of commercial (COM-54) and 40% of a new farming use (FAR-33).So, I wanna know if there are some differences. Some land parcels will be exactly the same. Some parcels will keep the same land use, but not the same percentage of each. But for some land parcel, there will be more or less land use types with different percentage of each.I want this script to compare these two layers and send me an email when there are differences between these two layers for the same land parcel ID.The script is already working, but it takes too much time. The probleme is, I think, the script go through all array2 for each row in array 1. What I want is when there are more than 1 rows with the same ID in array1, take only this ID in both arrays.Maybe if I order them by IDs, I could write a condition. kind of "when you find what you're looking for, stop searching when you'll find a different value?
I just learn how to create an array literal in VB.NET. [code]...
View 1 Replies