I suggest you buy a good book on ASP.Net. You seem to have got yourself hugely confused. I would have a look on Amazons top sellers list for ASP.Net books.
Also the reason why SQL Server is primarily used in examples is because it is very very commonly used in the .NET world. Oracle is rarely used. However your code shouldn't fundamentally change by switching from one to the other. On Tue, Oct 5, 2010 at 3:50 PM, charlesm <[email protected]>wrote: > 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. > > > > >
