I've downloaded great example of Imar Spaanjaar.

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=476

I've created a script for import records from excel file ... Can you tell me how to integrate the script in nTier example?

Do you think that is it possibile to do this:

in che script, after reading each row, do something like this:

Person person = new Person();
person.firstname = ....
person.lastname = ...

and then save the record readed in DB using:

PersonManager.Save(person);


Can you tell me if this is OK?? Read each record and call .Save method with each record readed from Excel!

Thanks

Yes, that's certainly a good way to do it if you want to import records from Excel using the object model (and thus using validation, for example).

As an alternative, you could directly insert into SQL. However, that means you loose the checking of rules that takes place in the business layer.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!