On 12 Feb, 17:10, Cerebrus <[email protected]> wrote: [...]> Someone appears to have misled you into believing that this is VB.NET ! This is all VBScript with ASP. [...] >I mean no offense and I would be happy to show you how it should have been written.
Cerebrus ( you're great, you know?) I agree with all, and hope to see your way of building the "SqlOracleHelper". Will, my two cents: if you could try to call a different function, you should get back a DataTable instead of an array (yes, you culd use two dimensionals arrays, but why as you could get a container able to keep data, colums, rows and table informations?), have at least a couple of overloads of this function : at least one more to use parameters instead of a sql query with all inside (I am sure it happens to you to call different queries where you specify something in a where clause...) , and it could come at hand an overload (better two: with and without parameters) to call stored procedures (packages) instead of using inline queryes. I would also avoid to call basepage in Dal - SqlHelper should be a class library or in any case a class that should not speak directly with pages, but with class(es) of Business Logic (Now, this last is a bit advanced topic for a beginner, so do not mind too much if you do not follow immediately : simply remember these names and, when you get a better working SqlHelper and some spear time, have a search for them and for "three tier" developement).
