It all started with this post: 👻 A post on Google+ – Google+ shut down in 2019. Or rather, with the fact that I started writing a page where I would just enter the details and it would do everything else for me, so I could simply copy code tailored exactly to the situation, the table and the database. So today is already the fifth day, though it really only adds up to 3 full days, which is still a lot. Then again, it depends on how you look at it.
Since in that time I have optimized the whole 👻 A page used to live here. Now there is only wind and weeds. website (turned off ViewState, reworked the database access as described above), today I threw myself into the shared components, and I got the most done in the class for working with the database. It now uses 3 of the 4 SqlCommand.Execute... methods – specifically ExecuteReader, ExecuteScalar and “ExecuteDataTable“, which is done through SqlDataAdapter. The only one I don’t use is ExecuteXmlReader, but that one is only for specific purposes.
I had never used the first two until now. A long time ago I tried to work with ExecuteReader, but after a few hours I gave up in frustration. Today I knew exactly what to do and how – I can parse an entire table with it. But I will keep DataTable for cases where I need to fetch more columns & rows from a table. But back to the title. From now on, don’t look for any subsites on my website, with the exception of 👻 A page used to live here. Now there is only wind and weeds.. If you land on any address of another site, for example from Google, you will be redirected to the home page right away.
On the other hand, 👻 A page used to live here. Now there is only wind and weeds. is now blazing fast and everything on it works – even things that hadn’t worked for a long time. Tomorrow I’ll dive into optimizing the remaining shared components.