I would love to find the jackass that invented ADO and take all his drugs 

away!!! 

Or give me a stick and let me beat him about the head and shoulders like a 

runaway read-headed step child!!!



Other than massive REDUNDANCY, I can find absolutely no purpose for ADO.



What moronic, meglo-maniacal, arrogrant grunt devised something this 

assinine??



Can not acces Database tables unless you build them in your program???

Select all the data or none? 

The only other oprtion is stored procedures? Please...

Just one more set of code that someone else can screw up.



Why the hell can't I SELECT data from a table with a variable? 

A rather simple task actually in most languages.  

A good example. In COBOL even Object Oriented COBOL, or C. 



SELECT NAME INTO :host_variable

 FROM TABLE_NAME WHERE NAME > :host_variable;



Simple statement, selecting all the names that are greater than a value 

that is entered by the user. 



Ahh, but not in ADO, or C#. Stored procedures or build million row 

internal tables, so I can select a SINGLE name. 



Tell me all that I have read on this was wrong!!!!

And I have read 3 seperate books. They all give the same stupid example.

"SELECT * FROM AUTHOR" If that is the best ADO can do, well I hardly think 

that ADO is a step in the right direction. No point in having a DataBase 

to store data. With ADO the best description of a database is a flat file.



Sorry for the RANT, but simplicity has left the building and was hit by a 

truck!!!

public class InventoryDB 

   {

      public DataTable GetProducts(int categoryID) {



          SqlConnection sqlConnection = new

SqlConnection("server=(local)\\NetSDK;database=grocertogo;Trusted_Connec

tion=yes");

          SqlDataAdapter sqlAdapter1 = new SqlDataAdapter("Select * from

Products where categoryid=" + categoryID, sqlConnection);



          DataSet products = new DataSet();

          sqlAdapter1.Fill(products, "products");



          return products.Tables[0];

      }

Here is your answer in c# from

http://samples.gotdotnet.com/quickstart/util/srcview.aspx?path=/quicksta

rt/aspplus/samples/grocertogo/grocertogo.src&file=CS\Market.cs&font=3



Watch the wrap



-----Original Message-----

From: gary liptak [mailto:gary_liptak@y...] 

Sent: Tuesday, December 18, 2001 2:39 AM

To: Application Development

Subject: [application_development] ADO's and WHY?





I would love to find the jackass that invented ADO and take all his

drugs 

away!!! 

Or give me a stick and let me beat him about the head and shoulders like

a 

runaway read-headed step child!!!



Other than massive REDUNDANCY, I can find absolutely no purpose for ADO.



What moronic, meglo-maniacal, arrogrant grunt devised something this 

assinine??



Can not acces Database tables unless you build them in your program???

Select all the data or none? 

The only other oprtion is stored procedures? Please...

Just one more set of code that someone else can screw up.



Why the hell can't I SELECT data from a table with a variable? 

A rather simple task actually in most languages.  

A good example. In COBOL even Object Oriented COBOL, or C. 



SELECT NAME INTO :host_variable

 FROM TABLE_NAME WHERE NAME > :host_variable;



Simple statement, selecting all the names that are greater than a value 

that is entered by the user. 



Ahh, but not in ADO, or C#. Stored procedures or build million row 

internal tables, so I can select a SINGLE name. 



Tell me all that I have read on this was wrong!!!!

And I have read 3 seperate books. They all give the same stupid example.

"SELECT * FROM AUTHOR" If that is the best ADO can do, well I hardly

think 

that ADO is a step in the right direction. No point in having a DataBase



to store data. With ADO the best description of a database is a flat

file.



Sorry for the RANT, but simplicity has left the building and was hit by

a 

truck!!!
















$subst('Email.Unsub').

> public class InventoryDB 

>    {

>       public DataTable GetProducts(int categoryID) {

> 

>           SqlConnection sqlConnection = new

> SqlConnection("server=(local)\\NetSDK;database=grocertogo;Trusted_Connec

> tion=yes");

>           SqlDataAdapter sqlAdapter1 = new SqlDataAdapter("Select * from

> Products where categoryid=" + categoryID, sqlConnection);

> 

>           DataSet products = new DataSet();

>           sqlAdapter1.Fill(products, "products");

> 

>           return products.Tables[0];

>       }

> Here is your answer in c# from

> http://samples.gotdotnet.com/quickstart/util/srcview.aspx?path=/quicksta

> rt/aspplus/samples/grocertogo/grocertogo.src&file=CS\Market.cs&font=3

> 

> Watch the wrap

> 

> -----Original Message-----

> From: gary liptak [mailto:gary_liptak@y...] 

> Sent: Tuesday, December 18, 2001 2:39 AM

> To: Application Development

> Subject: [application_development] ADO's and WHY?

> 

> 

> I would love to find the jackass that invented ADO and take all his

> drugs 

> away!!! 

> Or give me a stick and let me beat him about the head and shoulders like

> a 

> runaway read-headed step child!!!

> 

> Other than massive REDUNDANCY, I can find absolutely no purpose for ADO.

> 

> What moronic, meglo-maniacal, arrogrant grunt devised something this 

> assinine??

> 

> Can not acces Database tables unless you build them in your program???

> Select all the data or none? 

> The only other oprtion is stored procedures? Please...

> Just one more set of code that someone else can screw up.

> 

> Why the hell can't I SELECT data from a table with a variable? 

> A rather simple task actually in most languages.  

> A good example. In COBOL even Object Oriented COBOL, or C. 

> 

> SELECT NAME INTO :host_variable

>  FROM TABLE_NAME WHERE NAME > :host_variable;

> 

> Simple statement, selecting all the names that are greater than a value 

> that is entered by the user. 

> 

> Ahh, but not in ADO, or C#. Stored procedures or build million row 

> internal tables, so I can select a SINGLE name. 

> 

> Tell me all that I have read on this was wrong!!!!

> And I have read 3 seperate books. They all give the same stupid example.

> "SELECT * FROM AUTHOR" If that is the best ADO can do, well I hardly

> think 

> that ADO is a step in the right direction. No point in having a DataBase

> 

> to store data. With ADO the best description of a database is a flat

> file.

> 

> Sorry for the RANT, but simplicity has left the building and was hit by

> a 

> truck!!!

> 

> 

> 

> 

> 

> 




> $subst('Email.Unsub').

> 

NOT.. 

I tried that.. And even tried using the code from the example..

The example code does not work.



Altering only the db connection. 

It does not accept the code:

-----where categoryid=" + categoryID---- 

the =" (equal end-quote)craps at compile time. Invalid statement at 

compile time. Expects the end of statement.