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.
I created a menu with action buttons in SharvDevelop ver.3.2.0 it looks like.is there any way to put a condition for that menu - don't execute bat file assigned to SSILINKCLIENT button if metric or imperial radio button is not marked ?
View 2 RepliesI have a form called LogIn.vb which has no errors. After log-in, it opens the MainForm.vb which IsMDIContainer property is set to true. From the MainMenu, it opens a child form called Assure_Benefits.vb So far no problem up to this point. When Assure_Benefits.vb loads, it displays 2 DataGridViews with datasourses from my 2 tables in my database.
There is still no problem with the loading. Now, to show the difference between different user types, I only allow the admin to edit the DataGrid. SO I set the readonly property to true when UserType = "user".
I have no problem doing that. My problem is I want to add some codes besides the readonly being set to true and false but other codes are not executed and the program does not display any errors at all. i tried to add messageboxes on the if and else conditions to try if added codes will work but even the messagebox does not appear though the codes next to it are properly executed.
When my Assure_Benefits.vb loads I call for the subroutine below.
Private Sub SetControlProperties()
If LogIn.UserType = "admin" Then
MessageBox.Show("Yes") 'This line is not executed
[CODE]...
I can't seem to understand why the first code is not executed when the next codes works fine.
[Code]...
how can i get this code to return all values instead of just the first value ?
i 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
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