How to write a test case for function having data table as parameter

Question

1.00/5 (1 vote)

See more:

Hi,

I am writing a test case and i want to write a test case for a function having a datatable as parameter.

How i can achieve it?

My purpose is that i want to check whether certain columns exists in the datatable. So i can create a datatable, add columns and pass the datatable as parameter like this,

C#

DataTable dtExcel = new DataTable();
         DataColumn dtColumn = new DataColumn();

         dtColumn.ColumnName = "ID";
         dtExcel.Columns.Add(dtColumn);

         dtColumn = new DataColumn();
         dtColumn.ColumnName = "SyncID";
         dtExcel.Columns.Add(dtColumn);

         dtColumn = new DataColumn();
         dtColumn.ColumnName = "SyncRefDateTime";
         dtExcel.Columns.Add(dtColumn);

         dtColumn = new DataColumn();
         dtColumn.ColumnName = "Changed Date";
         dtExcel.Columns.Add(dtColumn);

         var validateExcel = objWISyncForm.ValidateExcel(dtExcel);

THe validate excel returns a bool value , how can i check with assert statement ?

Posted 1-Apr-14 19:18pm

Arjun Menon U.K

Updated 1-Apr-14 20:30pm

v4

Add a Solution

Comments

Maciej Los 2-Apr-14 2:16am

var validateExcel = objWISyncForm.ValidateExcel(dtExcel); - What kind of result should ValidateExcel function return?
It looks like you want to return IEnumerable or IQuerable object.
Don't you know how to declare function or what?
ValidateExcel(DataTable dt)

Arjun Menon U.K 2-Apr-14 2:33am

Sorry for not being clear. It just checks whether the dt contains the specified columns nothing much. One more question(may be a dumb question) , i have written test case for this function. Is there any sync between test case & code. Or we create test case only to check whether the function fails if any modifications is done on the function?

Maciej Los 2-Apr-14 3:00am

I'm not sure what you mean by "test case". Please, describe your issue in details.

Arjun Menon U.K 2-Apr-14 3:07am

I have a wind form project. I have added a unit test project. I am writing test case for some functions inside my project. One such function is ValidateExcel.But ValidateExcel function has a datatable as parameter. When i call the ValidateExcel from unit test class i have to provide the parameter and i am asking whether the code i wrote above is sufficient ...

Maciej Los 2-Apr-14 3:27am

I know what you want to do, but i'm interesting what "unit test" means in this case. What ValidateExcel function should do? The answer on question "is that sufficient?" depends on it.

Arjun Menon U.K 2-Apr-14 3:51am

It just checks whether the dt contains the specified columns nothing much

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 2-Apr-14 2:26am

What is the exact issue?

Arjun Menon U.K 2-Apr-14 2:58am

I just want to make sure, whether it is the right method to put data for unit testing

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 2-Apr-14 4:46am

Depends on your requirement. You have to decide what you want to validate and how?
Do you need suggestions on what to validate?

Arjun Menon U.K 2-Apr-14 6:56am

I am only asking whether i process i did is rt or not?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 2-Apr-14 7:33am

Ya you are doing good. But you should return a Boolean Parameter from that function, whether that is validated or not. Something like below...

if(objWISyncForm.ValidateExcel(dtExcel))
{
// Validated
}
else
{
//Not Validated.
}

Got me?

Arjun Menon U.K 2-Apr-14 9:04am

Assert i can use rt?
Assert.AreEqual(validateExcel, true);

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bernhard Hiller · Answer 1 · 2014-04-01T20:11:00

Solution 1

Creating the datatable line by line in code is one possiblility. You could also serialize a datatable, add that to your project (as a file, or embedded as a resource), and then load it in your test function.

Posted 1-Apr-14 20:11pm

Bernhard Hiller