Warnar Boekkooi

Get info from a Excel file using ASP.NET

Hey all,

I got a small job that has a XML file that should be displayed and i'm not in the mood of typing how i did it so here are the links i used:

http://www.c-sharpcorner.com/Code/2004/June/AccessExcelDb.asp (Mostly used the screenshot from the Excel file)
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B306572 (What to say it's the microsoft way and it works)

Hope that this may help :D

Happy Netting,

Warnar

N00B Mistake with a Component used for a Database (To mutch Database connections)

Hey all here is yet a again one of my blog about what i'm doing wrong :D

I have been bizzy with www.kapperkapper.nl as you may know. The problem is that i got error's that where like all connections to the database are open and stuff like that and i was Like WHAT!

I have a Component with all the dataset's adapters and code to use for the db on it i had my constructor witch opens the database and i had my dispose witch closes it.

A well it seemed to me that that should do the job but hey stupid me the Dispose is only called then ASP.NET thinks it is needed or what ever but not when i think it is needed.

So to fix this not i do:

using(ClientDB.Database db = new ClientDB.Database())
{
//Some stuff todo with the DB
}

Now the class is opend and disposed when the using stop's and Bug fixed :D

Happy Netting

Warnar

b.t.w. If you have any Tips for using MSSQL or related stuff me Please post them here :)