Data Driven Testing with Excel (Part 2) in CUIT -- Part 28 (CUIT Video Series)

In this part we will discuss reading the data from Datatable, store the data in Custom collection, read the data from collection.

[qualityassurance]

Thank you. Thank you. Thank you Karthik, for these amazing videos! They have helped my transition from manual testing to automated testing in such a big way. You deserve a metal of honour!!

[ramaswami]

Hi Karthik,
Thank you for your great work.
I thought to share an alternative approach to traverse the data table collection without creating a custom class

You can make use of DataSet extensions by including a reference called System.Data.DataSetExtensions which gives a method called AsEnumerable() to the DataTable objects. Then you can directly access the excel column names and their values using a "Field" property

var parmAccountNumber = => x.Field<string>("ParamName") ==

Hope this helps

[thewicked]

Karthik, I am in the process of converting to Coded UI from UFT and have found your videos very useful. I was wondering if you had an easy way to write values into the list created here, and then exporting the final list (previously read in values plus on-the-fly updates) back to Excel? To briefly explain the need...we have some hosted apps and I need to be able to grab system generated values from one app to use as search or verification criteria in subsequent apps. Any help is appreciated. These videos are amazing!

[qualityassurance]

Hi Karthik, I am trying to add the data file to the project. I set the properties "Copy to Output Directory" = Copy if newer, but the application doesn't seem to be copying the file over. I get a message. I modified the reference in my initialize class file to instead of keeping the local path. Do you know what I could be doing wrong?

[focamedia]

Hi Kartick!! amazing videos, i keep following you from Argentina!. Question, how can i close de exceldatareader after each test? It happens that when i run the test in the ordering, once after another, they don´t run because they see the file open

[phaneendrabheesetti]

I'm trying to pull a Value and I have 2 rows and 4 columns of data.

Facing below error:
An exception of type occurred in System.Data.dll but was not handled in user code

Additional information: Cannot find column 4.

Plz help....

[NefisaUK]

I am changing from QTP to Visual Studio 2013, and I think you are a QTP user too, it sounds like it. The process of integrating Excel to make a data driven test seems much more difficult in Visual Studio than it was in QTP. I would be really grateful if you could explain this video in a more simple way, since you change your tactics many times during this video and it's not easy to follow at all. I can see you have a lot of knowledge but I'm afraid it is not clear in these videos. In the most simple way, how can you explain how to take a Excel sheet and, with Visual Studio, read the rows, and write them into a webedit box (google search, for example).

Any links or pointers which you can give me to start from scratch myself would also be great.
Best wishes
N

[PriyankaSaroch]

HI Kartick i have done the same code as said by you but i am getting null value at the end can you pleas help me