How do i get the following code to throw two exceptions, IOException, and UnauthorizedAccessException, when deleting a file?I am trying to test a delete procedure and its associated exceptions. However, I cannot set the ACL appropiately to cause either exception for FileSystem.DeleteFile.
NequePorro
As
String
= "Neque porro quisquam est
[code]....
Public Sub DeleteDirContents(ByVal dir As IO.DirectoryInfo)
Dim fa() As IO.FileInfo
Dim f As IO.FileInfo
[Code]......
This is the code snippet posted on the site, anyway i tried various diffrent delete contents of a folder methods, but none could skip a file if it was in use or undeletable (but the reason is mostly due to it being in use)
I have a multi user application that stores temporary files in a folder that the users are using, but i want all unused temporary files deleted in it. So how do i go about doing this?
I'm writing a SSIS 2005 script (vb.net)in which I want the functionality to checks if a file exists if so then delete it.For testing purposes I'm renaming files to replicate an exception i.e. file cannot be read for whatever circumstance,to ensure the error handling is correct.The code works fine and catches any errors with the File.Exists(errorLookUpLog File) command, if the file does not exist/cannot be read but not with the code below using System.IO.File.Delete(lookupErrorLogFile) as when file is renamed and therefore cannot be deleted (looking for the file under it's original name then no exception is shown (see full code below, have yet to try catching specific exception for if a files doesnt exist)[code]
View 2 Replies[Code]...
I want to use a stored procedure to populate a label on my asp.net page and a dropdownlist @tourname will be populated into a single label while @tourdepartures will be multiple dates, that i want in a dropdownlist however when i run my sp i get this error
[Code]...
I have a stored procedure (SQL Server Express) that returns a count of records:
SELECT COUNT(AdminUserID) AS CountEm
FROM Licenses
WHERE (AdminUserID = @AdminUserID);
Table "Licenses" has a field "CompanyID" which is a uniqueidentifier.
I need to add a clause to the WHERE to exclude records from the count where "CompanyID" is null/empty.
In VB code I'd do this with "If Not (TheCompanyID.Equals(Guid.Empty)) Then"
How would I do this in a stored procedure?
Dim parm1 As New SqlClient.SqlParameter("@Category_ID", txtCategory_ID.Text)
Dim parm2 As New SqlClient.SqlParameter("@Category", txtCategory.Text)
Dim parm3 As New SqlClient.SqlParameter("@Area_Name", txtAreaName.Text)
Dim cmd As New SqlClient.SqlCommand
cmd.CommandText = "dbo.udp_tblArea_ups"
[Code]...
i am using this code to insert data into my new table using a stored procedure now i want to delete data from the table using a delete stored procedure.
i have a gridview, linked to a sqldatasource. I have added a stored procedure to delete from multiple tables, and then enabled deleting on the gridviews smart tag.
When i click the delete button i get an error message, "Object must implement IConvertible". I read that it is a problem passing the parameter to the stored procedure, possibly the wrong datatype being passed. Im not sure if i am passing the parameter to the stored procedure at all. The parameter should be the gridviews datakeyname, in this case it is "UserId".
The stored procedure works i fine in management studio, so i think it is just the parameter being passed (or possibly not being passed)
Do i have to code the parameter in the code behind to be passed to the stored procedure?
<asp:SqlDataSource ID="selectUsers" runat="server" ConnectionString="<%$ ConnectionStrings:CASSFConnectionString %>"
SelectCommand="SELECT aspnet_Membership.UserId, aspnet_Membership.IsLockedOut, aspnet_Membership.Email, aspnet_Membership.CreateDate,
[Code].....
I've just skipped around a few inbuilt VB classes' methods which throws exception. of all that i've came across, methods may throw multiple exceptions but ALL of them are exclusive, meaning there is no way 2 exceptions will ever occur simultaneously, yea and i was trying to make my class throw 2 exceptions simultaneously, hence this question, must all exceptions be exclusive?
View 1 RepliesMy question is How can i create insert,update,delete query by using class file and store procedure. This query is use for 3 tier.
View 2 RepliesI don't understand the error, Argument not specified for parameter 'test' of 'Public Shared Function TestThis(test As String)'.
Partial Public Class Form1
Shared Sub ReceiveCallback(ByVal ar As IAsyncResult)
Form1.Invoke(TestThis, New Object(){"test"}) 'error
[code].....
How can be find out which file is going to delete when, user provides command like DELETE or SHIFT + DELETE or by programmatically gives DELETE command. Well I know about FileSystemWatcher Class, but this class doesn't provide information before delete...
View 1 RepliesThe instructions are as follows:
1. Write a Visual Basic Console Application.Inside the main procedure call a function procedure to input and return a value for a double variable called x, the width of a right triangle.Inside the main procedure call the same function procedure a second time to get a value for a double variable called y, the height of a right triangle.
2. From the main procedure call a function procedure which calculates and returns a value for the hypotenuse equal to the square root of (x squared + y squared).You will have to pass the values of x and y to this function procedure.The procedure should calculate and return a double type value.The value that is returned by this function procedure should be equal to the square root of (x squared + y squared).
3. Also from the main procedure call a sub procedure to display the values of x, y, and the hypotenuse.
In a tic tac toe game I am making there are two blocks of code that are identical except that they access different arrays:[code]Arrays plyrTaken and plyrPairs are used in the first block and cmptrTaken and cmptrPairs are used in the second. Is it possible to wrap these blocks into one Sub Procedure passing the different arrays when the procedure is called?
View 5 Replies[code]...
and from VB6 project I reference to Test.dll but an error messege was appear A reference to Test.dll file could not be added (If I create VB NET project and reference to file Test.dll it OK )
Probably a dumb question, but can you write a unit test project in one language to test against another project in a different language?I'd like to translate one of our VB assemblies into C#, but want to build unit tests to verify the results. I've tried to set a unit test project up to do this, but I can't seem to access the VB code within a unit test... I can't figure out if I'm just missing/doing something stupid, or it really isn't allowed.
View 2 RepliesWell i ran into some problems changing my getfwt to a independant sub procedure. This stuff is so confusing to me.[code]...
View 14 Repliesi able to get data then i click second time i got error Procedure or function "procedure name" display has too many arguments specified" why this error. [code]
View 2 RepliesIs there a way to terminate calling procedure from the callep up procedure? I tried 'Stop' from a called up procedure in an executable; it has gone stuck; I am not able to remove it(the form) from the screen!
View 18 RepliesI finished coding an application for converting Celsius to Fahrenheit, and vice versa. I used the Sub Procedure to convert them. What I need now is to modify it. I would have to use the Function Procedure instead of my Sub Procedure.
[Code]...
Im a student doing an assignment, how do i pass the value from a sub procedure to a function procedure....i want to pass the value from decSubtotal to a function procedure named CalculateDiscount; check out my code--
[Code]...
I need to write a program that indicates the larger of two variables using exceptions.I'm not sure if this is an acceptable code. I'm new at this and attempted with this code here:
[Code]...
I normally wouldn't use an exception but I am asked to use one, I'm just not sure what kind of exception would work best.
I'd like some advice on building in known errors. Let's say I have a Windows form that needs to set the source path of an image in an object. It must be:
A valid path
An image
A PNG
[code].....
I have a class that has a method A and a helper method B, method A internally calls method B. method B throws few exceptions to the caller also method A throws it's own exceptions, Assume method A throws "NotImplementedException" and Method B throws "SQLException", in the XML of each method, one which method that should put "NotImplementedException" and "SQLException" in <exception cref></Exception >
Should i put both exceptions on the XML of method A?
I'm working on an ASP.NET web application, written using Visual Basic, and I'm trying to track down an error message that I'm getting.I'd like to get it to log the exception to a file (or the event log) so I can see it, as the error only occurs on the production server, and not on the development environment (therefore VS isn't installed on there...).
Does anyone have any thoughts as to best practice as to how to do this ?
Why is the net filled with examples like this? Why do people just chuck try catch around any expression with out the slightest thought about pre-validation?
i would never just add try catch and not handle the exception. I tell people this is basically on error resume next in disguise.
Is an exception ever unimportant to just use try catch but with out any message?I really want to progress as a programmer but have i been approaching all this wrong?
But what if you can not think of the exception that could be thrown?for example
Private Sub ListCurrentlyRunningProcesses()
Dim ActiveProcesses() As Process = Process.GetProcesses()
Try
[code].....
When you use Try Catch for Exceptions, will
Catch ex As Exception
Catch any possible error that could occur or do you have to catch each exception separately?
Is there a way to catch these Exceptions? (I am not looking for "just put try/catch or on error goto around them"). I am trying to find out if these errors can be caught by something outside of them.[code]...
View 1 RepliesThe store procedure which give me the information I need is:
USE [UCSMIS]
GO
SET ANSI_NULLS ON
[Code].....
When I try to add it to my report it gives an error, is it because of the temp table and how should I go about it?
I have a project that runs perfect under windows xp. Now I have tried to run it under Windows 7 and got there a lot of exceptions under Immediate window.
A first chance exception of type 'System.ArgumentNullException' occurred in Microsoft.VisualBasic.dll
A first chance exception of type 'System.IO.FileNotFoundException' occurred in LP_Wizard.exe
[CODE]...
What wrong with that Microsoft.VisualBasic.dll in windows 7 and how i correct that problem ?
