Monday, December 28, 2015

Resident Database

I am now concentrated in ASP.NET to get our resident database reports ready this year. I haven't be happy with MS Access reports and I am now investigating Crystal Reports for Visual Studio and Visual Studio's own report tool. I hope I can use the flexibility of LINQ. I used Crystal Reports ten years ago.

It was a time consuming work to figure out, how to transfer MM Access database to SQL Express. I didn't get the conversion tool to work. I transferred the data table by table by converting them first to text. I am naturally overdoing our database, but I want to learn.

Basically the database front end is now designed with the Web Forms. I was planning to go the ASP.NET MVC, but it was too much learning at this point. Eventually I have to do that later.

Front End- design is not so easy with ASP.NET than with MS Access and Visual Studio Windows Forms. I made a lot of googling, but I couldn't find proper solutions. Then I started to make that with the old way. It means start to think:)  All controls on ASP- pages actually create a HTML code. It took a lot of time to profoundly understand  it!  I can now combine data controls with regular controls by editing the source HTML file.

No comments:

Post a Comment