Final Year Project Smart Home System

Question

Hello

 

My name is Dan, and I on my final university year.

I am thinking about the project that I wanted to do for the final year, and would not like to go with something very basic that everyone does like, hotel, students management systems etc.

Instead I had an idea of designing a centralised software for a smart home.

 

I do like this idea, but the thing, that stands in my way of developing this software is that I will have to test it, therefore I'll have to buy or make my software work with some sort of micro controller, chip, and other hardware.

 

Any ideas on how I could design the smart home system, demo it, but keep it purely at software level witouth this hardware sensors. 

 

Thanks for any ideas 

Answer 1

A DataTable in ADO.NET has no concept of a 'current row' because, once it's been populated, it's disconnected from the underlying database. In fact, it doesn't need to have an underlying database at all - it can be created entirely using code!

Once you have your DataTable (dt, say), you can iterate through its DataRows just like any other collection:

foreach(DataRow dr in dt.Rows)
{
   // do something with dr
}

You can also obtain a DataRow directly:

DataRow rowFirst = dt.Rows[0];

DataRow rowLast = dt.Rows[dt.Rows.Count - 1];

It follows that there's no concept of being before the first row or after the last row (BOF or EOF in an ADO RecordSet). You must always be within the row collection itself or you'll get an exception.

Answer 2

Thank you so much.