.net - NUnit Testing Show A Form And Populate Its Textbox From Dataset In TestClass
May 20, 2011
I have written my and in a test class for vb.net and it works as follows:
A stored procedure is executed and the result is saved in an xml file with the help of a dataset. What I need to do now is , Information of this dataset should also be redirected to a textbox in a form so that I can copy this information in clipboard and create dynamic assert statements for instance I want
datatable.rows.count,
datatable.columns.count,
datatable.columns(i).ColumnName,
and same to get columnType. All of this info would be shown in the form but I am unable to open a form in NUnit test class.
View 2 Replies
ADVERTISEMENT
Aug 25, 2009
I 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 Replies
Oct 18, 2011
I am retrofitting unit testing into a fairly complex system designed and written by other developers in VB.net. I am trying to develop unit tests for the GUI forms using NUnit and the NUnit Forms extension. (I've been looking at c# examples that are fairly easy to port over if you have a solution but don't know VB syntax as long as it uses NUnit classes)
I will try and explain what I am doing but first a brief description of the program. It basically monitors server activity. You need to connect to a server via a modal form with IP and Port fields(amongst others). Once you have connected to a server other parts of the program unlock and become usable (such as configuration of the server).
Desired process: Load program > click connect button > modal connect form loads > enter details > click OK to connect > main form updates to logged-in state > other functionality
The problem is that I cannot test the functionality of the connect form and then the logged-in functionality of the program. I can test that it loads the modal connect form correctly; enters the details and clicks OK (all fine so-far) but it does not appear to logically progress the program. The modal form just closes again seemingly without running the connect code from the program back-end and I'm back at the main menu not logged in to anything.
I have a feeling that I've either missed something really obvious or that it's simply not doable in NUnit.I have trawled the internet in search of anything similar but the closest was another SO thread that was really generic. Without being able to actually test the logged-in version of the program, I'm at a major hurdle.Another issue is handling message boxes that don't have unique identifiers (e.g. "are you sure you want to exit?"); these also seem to be a major pain in the arse with NUnit (If it makes any difference, I'm running the tests as a stand-alone project using a reference to the executable file of the built project, not the actual source)
View 2 Replies
Jun 10, 2012
I am retrofitting unit testing into a fairly complex system designed and written by other developers in VB.net. I am trying to develop unit tests for the GUI forms using NUnit and the NUnit Forms extension. (I've been looking at c# examples that are fairly easy to port over if you have a solution but don't know VB syntax as long as it uses NUnit classes)I will try and explain what I am doing but first a brief description of the program. It basically monitors server activity. You need to connect to a server via a modal form with IP and Port fields(amongst others). Once you have connected to a server other parts of the program unlock and become usable (such as configuration of the server).Desired process: Load program > click connect button > modal connect form loads > enter details > click OK to connect > main form updates to logged-in state > other functionality
The problem is that I cannot test the functionality of the connect form and then the logged-in functionality of the program. I can test that it loads the modal connect form correctly; enters the details and clicks OK (all fine so-far) but it does not appear to logically progress the program. The modal form just closes again seemingly without running the connect code from the program back-end and I'm back at the main menu not logged in to anything. I have a feeling that I've either missed something really obvious or that it's simply not doable in NUnit. I have trawled the internet in search of anything similar but the closest was another SO thread that was really generic. Without being able to actually test the logged-in version of the program, I'm at a major hurdle.Another issue is handling message boxes that don't have unique identifiers (e.g. "are you sure you want to exit?"); these also seem to be a major pain in the arse with NUnit(If it makes any difference, I'm running the tests as a stand-alone project using a reference to the executable file of the built project, not the actual source)
View 1 Replies
Mar 1, 2012
I'm working with .NET 3.5 and Nunit 2.5.10. I'm attempting to write some tests to validate our role-based security enforcement through the PrincipalPermissionAttribute at a class-level. The test appears to succeed (it gets a green checkmark) and the Assert.Throws call properly catches the exception, and all my other assertions about the exception pass. However, once TearDown is complete after a test has run, the exception is re-thrown by NUnit. So even though the test "passed", every one of the tests shows that an exception was unhandled exception was thrown 'while executing' the test run.
I'm guessing I'm doing something wrong, but can't figure it out. My test is:
Public Sub New_TheForm_NoRoles_DeniesAccess()
' attempt to create a new instance of the form, but it should throw an exception with an inner SecurityException
Dim ex As TypeInitializationException = Assert.Throws(Of
[Code]....
Basically, Initialize is normally called in the application with Nothing so that we use the Windows Principal. During unit testing, we instead initialize it with a GenericPrincipal that has no roles, so that we can test that a SecurityException is thrown.
The tests are passing, but NUnit just seems to be re-throwing the exception post-Teardown.
View 2 Replies
Aug 11, 2009
I am working in vb.net and i have a simple requirement. I have added a MDB file to a dataset and it contains 21 tables. I have a datagridview and a combobox on my form. I was able to get the combobox populated with the table names available in the dataset by iterating through dataset.tables. Now i want to add the feature where the user can select the table name from the combo and then it should populate the contents of that table. I tried the following Code
[Code]....
View 2 Replies
Jan 6, 2010
Im wondering how to use a dataset to populate a textbox. For example, textbox1.text needs to display information from a table with a few rows of data
View 14 Replies
Feb 21, 2010
how 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 Replies
Jul 12, 2010
I have a form with multiple DataSets (filled by multiple Stored Procedures) and corresponding DataAdapters. Associated with the DataApters are commands for UPDATE, INSERT......... Before using the DA Update I am using 'If DSxyz.HasChanges(). It seems that when I make a change anywhere on the form affecting 1 dataset, all of the datasets show this to be true. Why should changing one dataset on a form cause all of the datasets to show changes?
View 1 Replies
May 16, 2011
[Code] Somewhere my system haves a function that returns a DataSet with the books of a certain subject and all the Authors that wrote such books. I need to show the book's attributes in some textboxes inside a Form. I use a BindingSource to display the ISBN, Name and Subject of the books in a textbox, yet I don't know how to display the author name of the book I am currently viewing in a TextBox, taking into account I already fetched the Author into the DataSet.
Its pretty much the Child/Parent display problem somewhere discussed in the codebank, but kinda backwards, the thing is that I;m navigating through the CHILD records here, not the parent, yet i have all the data needed in my Dataset.
View 6 Replies
Jun 10, 2011
I am new to VB2010 and writing a MDI child form to open another form as dialogbox, then pass a value back to the MDI child form, the value is successfully passed back to the MDI child form but it can't be shown on a text box [Code]
View 19 Replies
Jun 15, 2012
I'm trying to show a modal form below my text how can I set form position?
View 1 Replies
Mar 12, 2009
I am a rookie in VB and have been trying to show in form2 only the records in table2 filtered by the value of a textbox shown in form1 which is a value from table1.So far I have not been able to achieve this and I have seen so many answers to similar questions but when I try there is always something wrong.
View 2 Replies
May 15, 2009
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 Replies
Nov 18, 2009
I have a class that has timers and logic that I want to "Kill". Performing a TestClass = Nothing does not destroy it (calling it form a form).
View 3 Replies
May 8, 2012
I am new to Visual Basic and I'm trying to make a simple combo box that automatically populates from dataset. The table is from BaseMaterial with the column Material.
View 5 Replies
Sep 17, 2009
I am trying to populate a dataset from an XML file. Within the xml file are some € signs. However, when the data is read from the XML, the € sign is displayed as a ?. Has anyone seen this behaviour before, and if so do you know how to correct this? Below is a copy of the code i use to read the data from the xml file:
Public Function ReadExportFile(ByVal sFilePath As String) As Boolean
Try
msExportFile = sFilePath
[Code].....
View 3 Replies
Apr 8, 2010
Is it possible to populate a listview with a dataset? I have a function that returns a dataset. Why im asking this is because my SQL is quite complicated and i can't convert it to a SQLDataSource..
[Code]...
View 2 Replies
Feb 24, 2012
I'm trying to populate an array from a dataset with only specific column using vb.net 2010. is there any code to populate the array directly or must i make the use of a query?
View 1 Replies
Mar 12, 2009
I'm trying to populate a combo box with a dataset, this sort of works, but everything is just appearing on the same line. I think this answer might be to put the dataset into an array, then put the array into the combo box.
...problem is, I'm not sure how to do this! My code thus far is,
Dim usernameList As Array
'Retrieve usernames where player has available status
GetFilteredData()
[Code].....
View 1 Replies
Jan 6, 2011
My problem is that I can't populate a datgrid with the contents of a dataset. Having searched for the last few days to try and resolve this, I have given up and thought I would try here. I am using Visual Studio 2010 and attempting to create a WPF application. As you can tell from the code I am very new to this and any suggestions for improvement will be most welcome. I can see that the dataset is populated ok via the visualizer, I have a datagrid 'dgBOM' which I want to display the results. A popular solution in my searches was to add '.DataSource' but when I type the '.' after dgBOM the Datasource option is not there.
Code:
Public Sub Connect()
Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
[Code].....
View 1 Replies
Oct 12, 2011
I have need for a database in my latest app, i quickly realised it had been a long time since i last used a database and am in fact very very rusty on the subject. So i decided to create a simple DataSet using the designer, i created 2 tables as follows
Table 1 is Named Map and contains a 2 dimensional array each cell containing an array of object id's of anything in that cell, and a level ID.
Table 2 contains data about these objects ie size weight and a z-order, again referenced by an object id (matching Table1)
This i did with no issues, when it came however to actually populating these tables i drew a blank. Do i have to locate the database file and edit with notepad? I presume not. Maybe i have to use an external app like sqlmanager? I seem to recall from my past that i added table rows from within the designer but i cannot find this in 2010 express
View 12 Replies
Feb 21, 2011
This is a problem I have been trying to conquer for some time now and haven't managed to deal with. I've looked pretty hard on Google and so on, but most of what I find there is for populating a TreeView from a database. The closest I got was a bit of C# code for populating with a list of file paths. But unfortunately the result is individual roots & branches for each item.
What I'm working on is a message template tool where I'm trying to get the nodes in the treeview, which represents the templates, to populate from an XML file. I'm using DataSets for their simplicity of working with XML. Here's a basic example of the structure of the XML which is imported to the DataSet;
Code:
<?xml version="1.0" standalone="yes"?>
<Templates>
<Item>
[Code].....
So the path to each node will look like RootBranchName. I know this will no doubt require some recursion, but recursion is one thing I haven't fully grasped yet.
View 5 Replies
Jun 13, 2009
What does the "where T : new()" do? VS 2005 public class TestClass<T> where T new()?
View 1 Replies
Jan 6, 2012
How do I loop through a dataset and populate a DataGridView - heres my code. Hopefully someone can point out where Im going wrong... Not getting a specific error, just failed message box. when i take out the try/catch function then Im given no error but the DataGridView does not populate.
[Code]...
View 10 Replies
Dec 14, 2011
I have a simple access database that a log record gets written to a few times an hour.
I'm trying to make a DataGridView that shows that data as it arrives.
My "Solution" is simple;
when a user clicks the view -> read from the database (fill the datatable) -> update the view.
Not what I dreamed of, but functional, if totally sub-optimal.
However, my "solution" is a dud, using fill draws every single record from the database, even if there are already 599 on screen.
Really, I just want fill the datatable once, and add new records as they arrive (or on click if needs be).
Bonus point if you can also explain another way (that isn't called so often) to hide the ID column, and change the header of column 1 (named DateTimeStamp) to TimeStamp.
Public Class FormMain
Shared dataAdapter As OleDbDataAdapter
Shared logTable As New DataTable("log")
[Code]....
View 1 Replies
Sep 10, 2007
I was wondering what is the most efficient way to populate a dataset from an excel worksheet.I have tried many ways but most are very inconvenient.
View 3 Replies
Mar 8, 2011
I am creating an electronic display board using Visual Studio 2005, this will be an application using VB and not web based.What I am trying to do is use labels dynamicly and populate them from a dataset, Now there is a lot of labels on this board and to be honest the perfect solution would be to use a Data Grid View, unfortuantly I have to fit the information into a Custom Graphic that was created, hence the reason for labels.So obliviously I dont want to have to name each label and specify its information, for example:
Code:
Label1.text = MyDataSet.Tables(0).Rows(0).Item(0)
Label2.text = MyDataSet.Tables(0).Rows(1).Item(0)
Label3.text = MyDataSet.Tables(0).Rows(2).Item(0)
So I thought about something as follows but not sure how to get it work.Say I new I had 100 Labels Label1 to Label100.
Code:
Dim i as Integer
For i = 1 to 100
[code]....
Now the above doesnt work but it doesnt throw up any errors either.
View 4 Replies
Feb 20, 2009
I'm having a little trouble figuring how to do this.I have a dataset with a single table. Each row has the following fields ProductName, Version, CompanyName
The data might look like this
Visual Studio, 2005, Microsoft
Visual Studio, 2008, Microsoft
Office, 2007, Microsoft
I have already populated the TreeView with a list of Company names from a separate table. Now, what I want to do is to loop through my dataset adding a single node for each product under the appropriate manufacturer. Then under each product adding a separate node for each version of that product.
[Code]...
View 2 Replies
May 13, 2010
I'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]...
View 1 Replies
