I have this SQL Statement:
de.SqlStatement = "SELECT A.Name, A.Catagory , COUNT(Patient_ID) AS PNO FROM PatientApplyToAssociation P INNER JOIN Association A on A.Association_ID = P.Association_ID WHERE A.Catagory='" & "health" & " '" & "' GROUP BY A.Name '"
[Code]...
[code]why this code dosnt work? the if statment dont excute it work only if it's like this [code]
View 1 Replieswhich statment is right and why
vb
Private Sub BackgroundWorker1_DoWork(sender As System.Object, e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
[code].....
How can i exit a for each statement i mean say i had the code below (not real code its sudo code)
CODE:
but i don't want to exit just this for loop i want to exit the previous for loop at line 1
CODE:
It is possible to catch an exception and throw a new exception which wraps the first exception as an inner exception: [URL] Also, if I call a function and it throws a certain error, but I catch it, will the calling code's catch handler execute? If so, and it is of a higher exception type, is this not wrapping the exception? eg I can throw exception ex of type IndexOutOfRange, log it but rethrow, catch a higher up exception and do something, or I can throw a new exception and wrap an inner exception like:
View 1 RepliesI am getting an error saying that I don't have for For, for my Next statment. It looks like it doesn't even finnish the initial compile. What is going on?
Code:...................
A company pays its salespeople on a commission basis. The salespeople receive $200 per week, plus 9% of their gross sales for that week. For example, a salesperson who grosses $5000 in sales in a week receives $200 plus 9% of $5000, or a total of $650. Develop a console program (using a one-dimensional array of counters) that determines how many of the salespeople earned salaries in each of the following ranges (assume that each salesperson?s salary is truncated to an integer amount):
a)$200-$299
$300-$399
c)$400-$499
[code]....
My gross salary formula works fine but im confused about my For Next Statement. Not sure if im doing it right. i forgot one thing.... i'm not sure if my increment counter should be where i put it. I think it needs to be in my for next statement?
I am trying to scroll a datagridview for that i created a scroll event scroll event should have 3 conditions:
1. if I = last row then do not continue adding one to the row index
2. if I < last row then continue adding one to the row index
3 if I = first row do not subtract one from row index
This is the code i wrote for the first 2 conditions, and my system keeps crashes
HTML
If i < grdAccountTypes.Rows.Count Then
i = grdAccountTypes.CurrentRow.Index + 1
Else
[CODE]...
I am having an issue with the following code. It works when the data is all numeric such as 9200000 but not when the data is alpah numeric such as b101462 I am collecting data from a textbox into a string variable findacct and then using the variable in the sql statement. The data in the access database is char type.
The following select statement works when all the data is numeric for the find acct varialbe but if start with a alpha char like B101462 it gives me a missing parameter error."Select * From purchase where issuedate >= " & "#" & finddate & "#" & "and account like " & findacct)The following statement works when I actually put the account info in the select statement and do not use a variable."Select * From purchase where issuedate >= " & "#" & finddate & "#" & "and account like 'b101462'")
I use in my Project the IfExistsTable function; in order to see the existence of a table.
For this purpose I use the Select statement as follows.
MASQLComm = New SqlCommand("SELECT COUNT(*) AS [RecCount] From sys.tables WHERE name Like '%" & tName & "%'", SQLConn)
RecCount = CInt(MASQLComm.ExecuteScalar)
After that I take the number which returned in RecCount. Until now the numbers was 1 and 0
And so I was turn the numbers in True or False.Now suddenly the returned number is 2 which I can't understand what it means.
I am creating a windows application using VB.Net and this application will take a SQl create .sql file as a parameter and will return all fields and their data types inside in a list or array.
Example:
USE [MyDB] GO /****** Object: Table [dbo].[User] Script Date: 07/07/2009 10:16:48 ******/
SET
ANSI_NULLS ON GO
[code]....
Should Return:
UserId int, FirstName string, MiddleName string
I want to do this by any way, pure vb.net code or using RegEx.
I m tryng to make report but its not working.i explain u to description of my project
i have 5 tables in form Payment,Receivable,Expense,Sale,Purchase and now i want to make debit credit form and its work that when i give a party name the report show me its statment
if the party is vendor show purchse from him and payment paid to him and if he is buyer so show him payment received and sale to him
I have a filter expression that contains a single quote (Al ' ABC), and i am using the Select statment of the datatable where i want to select all rows containing the filter expression, but i am encountering an error. how can i resolve it?
View 1 RepliesI have a filter expression that contains a single quote (Al ' ABC), and i am using the Select statment of the datatable where i want to select all rows containing the filter expression, but i am encountering an error. how can i resolve it
View 3 RepliesI have two table the 1st std table (stdid,stdname,etc...) 2nd table (stdid,sdate,stdcase)the 1st table for student data 2nd for attendance my program read two table and show them to user in datagridviewdatagridview will show stdid stdname stdcasei want to write sql statment to show all rows from std table and show only rows from 2nd table there sdate = todaydate
View 8 RepliesIs there a way that when using a Try, Catch statment to give details of the sub routine and line that the error occurred? The reason I ask, is that there is a user in a different state who is using a tool, and he is getting some errors. He is getting an unhandled exception message. I can not seem to reproduce the error, and want to know where it is happening, other knowing that is has happened somewhere in the UpdateModelLists.
View 3 RepliesI have this code to pass the data from a datagrid to a table that will be created at the same time the data will moved. I have cancreate the table with no problem, but I have the name of the table on a variable and I can't call it on the sql. I have try diffrent codes and it doesn't read me the variable. This is the code I have. It says syntax error in query incomplete query clause
[Code]...
I was doing my project and came across an error (The I/O operation has been aborted because of either a thread exit or an application request) regarding this
"Private Sub SerialPort1_DataReceived(ByVal sender As Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort1.DataReceived
If closingdown = False Then
received = SerialPort1.ReadTo(vbCr & "R") 'Motion port receiving data. needs a vbCR & "R" is sensor out is an ASCII "R" followed by three characters (which is the distance measured)
End If"
I'm writing a program that's supposed to keep the employees at my work away from doing things they're not supposed to on the computer. So I made a "launcher" window that's only closeable with password. I also disabled task manager. However when I start an application from my launcher window, the launcher window goes over it because of its topmost property.
View 2 Repliesi dont understand what this means. im not using an array as far as i can tell. i am in a vb class and wou. here is my
Public Class frmMain
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code].....
Anyone out there who happens to have an exhaustive code snippet for SEH (including all possible exceptions) for VS 2008 or VS 2010 (.NET 3.5 or 4.0) ?
View 10 Replieshere is the exception error System.IndexOutOfRangeException i want a msgbox saying device not detected
View 2 RepliesI have a class library that is referenced by several other class libraries along with the main program. About two weeks back, I made a change to one of the classes in that base library, which is used as an argument for some events. Since that time, I have been testing code. Today, after a couple more tests, I started getting this exception. It is indicating a field is missing, which was renamed in that change about two weeks ago. The exact code that is raising the exception is code that I have run a couple dozen times in the intervening time, and it has always worked.I have tried everything I can think of, including deleting the bin and obj folders of every module that could be in any way related to this issue, such that the whole thing was rebuilt. I have removed the references and re-added them. Nothing worked. Code that has run fine for weeks has decided that it wants a version of an object that has not existed for weeks.
This problem arose immediately after a different problem, so the two might well be related. The other problem was that, while stepping through code, the IDE decided that one of the code pages was different from when it was last loaded. I get that a fair amount, and solving it is fairly routine. It generally means that I am stepping through code in a dll, and inadvertently tried to fix a bug in that code, rather than in the dll itself. Now it no longer matters. I can't get to that code page, nor can I get to anything else in that dll. It is acting like it has sponaneously decided to revert two weeks back in time, and use that source code for debugging, despite any attempt I make to bring it up to modern times.
i keep getting this null reference exception error and i can't figure out what i need to do to fix it. I have this in the form
[Code]...
keep getting this null reference exception error and i can't figure out what i need to do to fix it.I have this in the form
Private Sub cbLookUp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbLookUp.Click
Dim webDownload As New Net.WebClient
[code].....
im making a program and it needs to load 95 files on form load.im trying to make it to if the file cant be found that it will give a error instead of a JIT debug thing. i triedadding
HTML
Catch ex As Exception
MsgBox("Error: " & ex.Message)
[code].....
I am getting this warning after I have changed the computer. I just installed framework and visual basic 2010, trying to edit the application that I been working on and one of the main forms is giving me this error.
Warning 1 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) 0 0
I developed an app, tested on few computers and all seemed fine. But now, some people suddenly get an error, which I can't repeat on my computers. Part of the exception:
** Exception Text **
System.TypeInitializationException: The type initializer for 'NumoABC.functionsBurtuSummas' threw an exception. ---> System.InvalidOperationException:
The form referred to itself during construction from a default instance, which led to infinite recursion. Within the Form's constructor refer to the form using 'Me.'
at NumoABC.My.MyProject.MyForms.Create__Instance__[T](T Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 180
at NumoABC.My.MyProject.MyForms.get_MainForm()
[Code] .....
The If Me.Created = False Then is because while the form is loading, some events fire the updatePersonDataHandlers() sub, but I don't want it to happen until form is fully loaded. In the module functionsBurtuSummas line 2
Module functionsBurtuSummas
Private f As MainForm = MainForm
I have many modules who work with the MainForms' controls, so I use a private variable f to refer to the MainForm.
I am trying to search the C: drive for all files with a certain extension. I am using the following code which is working fine, however when it encounters an error the whole process stops rather than continuing with the scan. (running in backgroundworker, hence the invoke)
Private Sub ScanFiles(ByVal rootFolder As String, ByVal fileExtension As String)
'Determine if the current folder contains any sub folders
Dim subFolders() As String = System.IO.Directory.GetDirectories(rootFolder)
[code].....
Im am trying to get two separate applications to communicate with one another via a txt file. The first application writes to a txt file every even second and the second application reads the text file every odd second. The problem is Im getting an exception saying The process cannot access the file FILE_PATH.txt' because it is being used by another process. Not sure if my code is correct or not? Or if there is a better way to do this?
[Code]...