Advanced Visual Basic.NET

David Gefen is an Associate Professor of MIS at Drexel University. David was a senior MIS project manager in charge of the design, programming, implementation, and ongoing improvement of a large complex IT before entering academia. Prior to that he was a systems analyst, database administrator, and senior programmer. As a professor, he specialized in teaching database analysis and design, programming languages, and MIS management for the last six years. David won the distinguished LeBow Excellence in Teaching Award and the Drexel University Faculty Teaching Award, Graduate Level. Professor Gefen received his Ph.D. in Computer Information Systems from Georgia State University in 1997. He has over forty five refereed publications to his name, many of them in the top MIS journals. Chittibabu Govindarajulu is an Assistant Professor of MIS at Drexel University. He has been teaching Visual Basic since 1996, the year he graduated from University of Mississippi with a Ph.D. in MIS. Professor Govindarajulu has an extensive publication record (over twenty five refereed publications), several of which are in top MIS journals. Before Ph.D. he served as a Deputy Contracts Officer in an Atomic Power Project where he oversaw development of purchase related information systems. Professor Govindarajulu specializes in teaching Windows and Web development courses using ASP, VB.NET, ASP NET, ADO NET. and Cold Fusion.

1. An Essential Introduction.


The Underlying Philosophy of Objects. Rapid Application Design. Classes and Namespaces. .NET Architecture Overview.



2. Review of Variables, Constants, Data Types, and More.


Variables. Constants. Literals. Data Types. Casting. Numeric Data. Strings and Dates.



3. Review of Arrays and Control Statements.


Arrays. Structures. Enum. Control Statements. Catching and Handling Errors. Structured Exception Handling. A Quick Look at Delegates.



4. A Detailed Look at Object Orientation.


Object-Oriented Programming. Encapsulation. Polymorphism. Inheritance. Namespaces and Classes. Designing and Using a Class Module. Object Lifecycle.



5. Directories, Files, Paths and Sequential File Access.


Paths. Directories. Files. Directory and File Dialogs. Streams. Sequential Access Method.



6. The Binary Access Method.


Binary Access. Encryption. FileStream Class. Serialization and Persistent Objects. Random Access Method.



7. Graphics and Animation.


The System. Drawing. Graphics Namespace.



8. Multithreading.


Multithreading. Thread Data Sharing and Synchronization. Thread States.



9. Overview of Database Programming.


Databases. An Overview of ADO.NET.



10. The Connected Layer Command and DataReader Classes.


Command Object. DataReader. XML Reader. Database Schema. Command Object Parameters. Transactions. Brief Look at Stored Procedures.



11. More on the Connected Layer.


The Data Form Wizard. The Query Builder Window. The Data Form Wizard with Parameters in SQL Server.



12. The Disconnected Layer.


Data Set Class and its Related Classes. Example of the Dataset and DataTable Classes. Data Set Methods and Properties. Data Table Methods and Properties.



13. Multi-Table Data Sets.


Multi-table Data Sets. Data Relations and Constraints. Data Sets Without a Data Adapter. Data Row Methods and Properties.



14. A Review of Active Server Pages.NET.


WebPages and Web Server. Form Controls. Intro to ASP.NET. Server Controls. Validation Controls. Other ASP.NET Controls.



15. Active Server Pages.NET and ActiveX Data Objects.NET.


HTTPRequest Class. HTTPResponse Class. Maintaining State in Web Applications. HTTPSessionState Class. Intrinsic Classes in ASP.NET. ActiveX Data Objects.NET. .NET Data Providers, OLE DB.NET Data Providers. The SQL Server.NET Data Providers.



16. Web Services.


XML Web Services—Established and Emerging Standards. Designing a Simple XML Web Service Using Visual Studio.NET. A Web Service New Project. Consuming the Web Service. The E-Mail Web Service.



Appendix: SQL.


SQL Overview. DDL. DML Select, Join and Union in the Select Command. DML Action Queries. Performance Considerations in SQL.