We're finally beginning to migrate from asp to asp.net. But I'm finding the experience frustrating.
For instance in asp you want to use arrays instead of recordsets. But in asp.net I see datasets and talk of how this is better. But why? Do you not still have the problem with going back repeatedly to the database? I seen a few posts/pages about datasets being more efficient but always in the scope of using the data once and displaying it. I almost never display data, its used behind the scenes to generate other values. I've searched and search and just recently found a page that talks about the many database calls of recordsets and what is better about datasets. Why was this so hard to find? You would think it would be one of the first things mentioned and mentioned just about in every page about datasets. Also many times I've come across examples, I copy and paste to try it out and , it fails! Why? Are they leaving something out or what? Something I need to include but the author has left out? And why are examples with database SqlServer or non-databases like Access (I know these are Microsoft products), but a lot of us use Oracle . Is everything the same for Oracle? And why do so many pages/ posts assume you want to pull data and display only? As far as I know you can only use a datagrid to display. I have absolutely no use for something like that. Ever. What about those who use data from a database to perform calculations to generate other results that may or may not be displayed. Where are our examples? I found a method to retrieve data from Oracle. But I've many other queries I need to run. It seems like I have to redo a bunch of setup with database connection each and every time even though all that's changed is the sql statement. Is this right? Most of our pages have no controls on them. Information is bases from a previous page that specifies what should be on the page and we form controls dynamically. How does this fit in with a html part and a code behind part? I can't assume the user can click a button, because that button may not exist. Admittedly I am just starting to learn this. But these are really basic issues and seem very difficult to find an answer to.
