Hi,

I am currently reading the book ASP.NET web programming problem, design solution. I am wanting to create a database class but the book only describes methods for use with stored procedures. I want to use in line sql statements. Is this possible?? Could anyone advise.

Thanks

Adz - The World is not enough

__________________
Adz - Learning The J2EE Ways.

There is very little difference between using stored procedures versus standard text queries. usually, the only thing you need to do different (aside from the obvious of writing in the full query) is to set the command object commandtype to Text instead of StoredProcedure. Otherwise, the rest is the same. Provide a full query. It can include parameters (@someFieldValue) so you can use the parameters collection in the same way as you use parms in stored procedure calls (with the exception of output parameters).

Peter
-------------------------
Work smarter, not harder

thanks man!

Adz - The World is not enough