when I try to test for a null value using the following:
If not string.isnullorempty(trvlitreadservice.itineraryinfo.reservationitems(zbook).value) then .........
I get an error as soon as it hits a null value. I thought this was supposed to test for a null value yet it throws an error for the very thing I'm testing for.
I'm looking into adding some unit tests for some classes in my data access layer and I'm looking at an update routine that has no return value.It simply updates a row based on the id you provide at whichever column name you provide.Inside of this method, we collect the parameters and pass them to a helper routine which calls the stored procedure to update the table.Is there a recommended approach for how to do unit testing in such a scenario?
View 4 RepliesI use VS team system 2008. At the moment i need to test some business classes, i have found two kinds testing NUnit and the unit testing provided by the VS team system. what are there differences?
View 1 RepliesI'm building an Active Directory wrapper in VBNET 2.0 (can't use later .NET) in which I have the following:
IUtilisateur
IGroupe
IUniteOrganisation
These interfaces are implemented in internal classes (Friend in VBNET), so that I want to implement a façade in order to instiate each of the interfaces with their internal classes. This will allow the architecture a better flexibility, etc.Now, I want to test these classes (Utilisateur, Groupe, UniteOrganisation) in a different project within the same solution. However, these classes are internal. I would like to be able to instantiate them without going through my façade, but only for these tests, nothing more.
[Code]...
I have a fairly simple piece of code:
Private _PurchaseDelivery as PurchaseDelivery
Protected Overrides Sub InsertItem(ByVal index As Integer, ByVal item As PurchaseDeliveryItem)
[Code]....
Which is inside a class which overrides a custom list base. The code is occassionaly throwing an unhandled exception, System.NullReferenceException, on this line when used in production:
If _PurchaseDelivery IsNot Nothing AndAlso _PurchaseDelivery.DefaultSKUBinID.HasValue Then
DeafultSKUBinID is declared as an Integer? (Nullable Int) in the PurchaseDelivery class. I cannot see what might be causing this error, why would this be returning an error?
How to check whether a column is null i use the following code but I got this error "Input string was not in a correct format."
[Code]....
When I put a break point to the last if clause in the sub ("If (backOrder < 0) Then", see below) it runs until the break point, if I put the break point further below, I get the following error:
Cannot insert the value NULL into column 'OrderID', table 'WHM.dbo.OrderDetails'; column does not allow nulls. INSERT fails. The statement has been terminated.
I've discovered first hand that it only happens when prodqty is bigger then qtyOnStock, thus executing the if clause.
The code:
Private Sub NCOSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NCOSubmit.Click
Dim sqlText As String = ""
[Code]....
I am trying to create a treeview in VB.net, the data has to be loaded from MSAccess 2010 database. When I try to run this program I get error : Argument Null Exception was unhandled, 'column' argument cannot be null and the program crashes. I have pasted the code as under:
Imports System.Data.OleDb
Public Class frmRating
Private Sub frmRating_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles
[code].....
In my project developed for using asp.net with vb.net coding. Now we need to performace testing using the Jmeter tool. we can't able to test because in my application lot of session variable used, Jmeter tool does not support session variables i think.Check with debugging:1.Assign the session(userName) ="abc" then goes to next page, then check value same session vaule as nothing.
View 1 RepliesI have a Do loop that I want to exit once it goes through without making any changes to an object I created. I figured the best way to do this was to create a temporary copy of the object at the beginning of the loop and then compare that to the actual object at the end of the loop to determine whether any changes were made to it. The problem occurs when variables are accessed and copied by reference. I have tried to use some of the methods such as .Clone and .Equals (maybe I shouldn't be using these, but I didn't see any better built-in methods), but I seem to be doing some stuff wrong. Can somebody give me an example of a good way to copy an object for later equality testing, and how to do the equality testing?
View 5 RepliesI was once a VB 6 expert, but it's been a while.I am attempting to create a simple DLL in VB. I created a new WCF Service Library, which is what it looks like I needed to do. I filled out the interface and implemented it. Here's the interface:
<ServiceContract()>
Public Interface AgileApi
<OperationContract()>
[code]....
And attempted to call it, but I get System.EntryPointNotFoundException. I've tried pathing the defined library and copying the dll file into the same place where my EXE is, but no change to the error.
I'm writing a piece of code to manage the Unhandled exceptions in my VB application.
I'm using the following code
Partial Friend Class MyApplication
Private Sub MyApplication_UnhandledException(ByVal sender As Object, ByVal e As Microsoft.VisualBasic.ApplicationServices.UnhandledExceptionEventArgs) Handles
[Code]....
I'm trying to determine if a file "G:myfilesfile1.txt" exists. Using sample code from numerous web searches I can't make any of the FileSystemObjects work. Seems to me the FSO routines are an add-in to VB. If this is so, how do I add them in?
In noncode, this is what I really want to do:
if "file1.txt" exists AND "file2.txt" exists
if "file1.txt" filedate > "file2.txt" filedate
copy "file2.txt" to "fileold.txt"
[Code].....
Private Sub CompareTime3()
Dim NowTime3 As Date
Nowtime3 = (TimeOfDay)
[code].....
In each of the two test sub routines, both if-then statements end up as true and I get both messages boxes displayed ("Timeslot is 16" then "Timeslot is 40" are displayed. One comaprison is AM the other is PM. How can one variable be true for both?
When i try to run my unit tests in vb.net, visual studio closes down because of an error.I don't know what is causing the problem but i is very frustrating.I have a project running for school that i can't continue because of this problem.When i had visual studio installed under windows vista i didn't got that problem. (same version of visual studio)
View 8 RepliesPublic Class Form1
Dim SW As New Stopwatch
Dim MS As New MenuStrip
Dim Btn As New ToolStripButton
[code]....
We have a DateTime Service that pulls the Database date down when we need to use a Date. Now, If I want to run a test using "Todays" Date using FitNesse, What would be the easiest way of creating a way to have (OurService).CurrentDate be static? We have a control that ads Days,Years, or Months to the current date.. and I would like to be able to test this.
View 1 RepliesI have been assigned a task of exploring unit testing using tools available in the market.My question is how do i write an API that would help in writing unit test cases.Example i can use nunit to write something like this to check whether file exists in the given location.
<Test()> _
Public Sub CheckOutputFileInfo()
ReportPath = "D:temp est.txt"
[code].....
i need to learn how to do automated testing using visual basic. i already know little bit about visual basic. now how can i do automated testing using vb.any good resource to study about that? even if it a link based resource also fine. and i need your suggestion on how to carry on with testing in visual basic and how to do it well. waiting for your reply.
View 2 RepliesIn the project that i;m currently working on i;m not allowed to touch GUI for anyreason that includes program testing. I'm in bit of s frustration becuase prior to this all must application were developed and tested using GUI. Typicvally it wold take a me a week to develop an app now it taking more than that. Especially the TDD with Unit testing. The documentation kills more time too......
View 4 Replieshow can I test if a dataset has rows? I'm trying to see if my sql procedure call managed to fill up my dataset.Also, is there an easy way to print the rows to a label?
View 3 RepliesI am responsible for rewriting an internal tool for my company. I am currently reworking the most time consuming step to run faster which should give me time to re-think the design of the application for a full rewrite as the interstitial version will meet the current needs. I really want to take this opportunity to implement this code using BDD/TDD but I am new to this method of programming in general and especially within the context of .NET. Are there BDD/TDD tools available for .NET? What resources should I look at?
View 2 RepliesI often get calls from a friend of mine's company saying "ahhh our email is not working!". I thought I could write a program that would test a few things that they could run and have easy answers to my questions when they call. Things like "Is your internet connection alive?", "can you send mail but not receive it?", etc.
[Code]...
1. when testing a service, should I install the exe which is in the bin subfolder or the obj subfolder, and why?
2. when distributing the service, should I use the exe which is in the bin subfolder or the obj subfolder, and why?
I have created a COM callable assembly which consists of an Interface, a single class which implements the interface. In this case the implementation is a single method.I have registered the assembly, created a type library and added the assembly to the GAC.I thought about opening an Office application like WORD or EXCEL 2003 and trying it from there but beyong referencing the COM assembly I have no idea how to code it.
View 1 RepliesI have a windows form application that connects to an access database. When the program is running it connects to the database and populates several textboxes that are bound to the dataset. I have been researching for 2 days and cannot find exactly what..I need, although a few threads have given me a better insight into my dataset. I would like to type text into a textbox that is bound to the primary key and when I tab out of the textbox (lostfocus event) have the program do a quick search of all records in the dataset of the primary key and if a duplicate exists, msgbox the user that that particular text is a duplicate and is not allowed, however if the text is not a duplicate, continue the tab keystroke allowing the cursor to move to the next textbox bound to the database.
View 4 RepliesI am currently using the following code to check for the presence of an entry in a table. I choose this code because I thought it was a good idea to use a public function to reduce the amount of code required. It works fine until the field I am checking for contains a' character.I realise I need to use a parameter like @name but cannot work out how to pass the correct information to the public function.how to amend my existing code so I can use @staffNo.
Imports System.Data.SqlClient
Dim PaddedStaffNo As String
PaddedStaffNo = (TextBox2.Text.PadLeft(4, "0"c))[code].......
I want to test if an image in a picturebox is the same to another image in a picturebox?Also, i get my images from a listBox.I need to use i as a conditional in an if statement.
If (picBox2.Image = picBox1.Image) Then
' code ...
EndIf
[code].....
I have to create a device that takes a randomly generated number and tests that many numbers against an upper and lower bound. I can't figure out why my code isn't working.This is my code and a screen shot of what it is doing.I think I need a loop but I have never worked with loops and wouldn't know what to do.
Private Sub Report_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnReport.Click, miCalculate.Click
Dim intUp As Integer = GetInput(tbxUp, intUp, "Upper")
[code].....
I have an int datatype in my SQL database table (NULLS allowed).
Three values of this int datatype are significant: NULL, 0 and > 0.
I create a variable with:
Dim IntType as Integer = Nothing
And then, using SQL Linq, transfer the value from the int datatype in the table into the variable.
If the int datatype is NULL, I leave IntType = Nothing.
Now, when I test the value of IntType:
If IntType Is Nothing Then
gives an error because cannot use Is with an integer variable.
So I tried:
If IsDbNull(IntType) Then
is never true, even when IntType is set to nothing.
In fact, if IntType is set to Nothing, whilst debugging, IntType = 0 !!!