So 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 to Add Not condition in the below select case.Is <> works for single value, and 'To' works for a Range but the value are specific values there are not series of numbers. Is it possible to use select case in this scenario, or do i have to switch to if-else. Ex: i don't want case to execute when value is 0 and 3.
View 3 RepliesThe following lines are supposed to display to a text box the phones numbers that match the condition in the sql statement, however it shows me all the phone numbers:[code]
View 7 RepliesMy code is:
CODE:
Now i want to know can i use select case instead of if (condition)statement in this code?
i have datagridview with rows in it and one of the col show type of product. there are row with same type. on click of button i want to select all the row where productype = 1 (for example)
do i have to go thru each row in grid and check the condition for product type and then select it or there is another quick method.
Why i run script 1 is give me the Compiler Error Message: BC30451: Name 'Rpttitle' is not declared. But when run script 2 is working fine with output? Anybody have an solution about this issue?
[Code]...
i want to select specific nodes of a xml document.Everything is ok until the document has an xml namespace. Then when i try to select the specific nodes no node is being returned.. This is because an xml namespace is declared. Is there a way to select those nodes and ignore the xml namespace ?
The file is :
<?xml version="1.0" encoding="utf-8"?>
<xliff xmlns="urn:oasis:names:tc:xliff:document:1.1" xmlns:tek="http://www.tektronix.com/TC" xmlns:cals="http://www.tektronix.com"
[Cdoe]......
The following is a screenshot of the problem: What can I do?
View 3 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 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 Replies