Using-MyODBC-with-Visual-Basic-6-and-ADO PDF
Preview Using-MyODBC-with-Visual-Basic-6-and-ADO
Using Connector / ODBC with Visual Basic 6 and ADO Mike Hillyer Webmaster – VBMySQL.com Copyright 2003, Mike Hillyer Presentation Outline • Why VB/MySQL • MySQL datatypes and their VB counterparts • Useful VB controls • ADO Basics • Displaying data • Inserting Data • Updating Data • Using BLOB fields • Error handling Copyright 2003, Mike Hillyer Why Visual Basic? • Fast development • Easy to learn • Well suited for database apps • Performance • Connector / ODBC 3.51 Copyright 2003, Mike Hillyer What You Will Need • Visual Basic 6 – Service Pack 5 – MDAC 2.5+ • MySQL – 3.x or 4.x • Connector / ODBC – 3.51.06 is now stable Copyright 2003, Mike Hillyer VB/MySQL Datatypes • Use most appropriate MySQL datatype, deal with conversion in client application • Visual Basic.NET handles most if not all MySQL data types, one reason to upgrade? • www.vbmysql.com/articles/datatypes.html Copyright 2003, Mike Hillyer Useful VB Controls Treeview Listview Copyright 2003, Mike Hillyer Listview • Located in Microsoft Windows Common Controls 6.0 • Great for displaying multiple records in one view • More versatile than the datagrid • Greater control by avoiding bound controls • Data can be hidden in zero-width columns Copyright 2003, Mike Hillyer Listview Demonstration Copyright 2003, Mike Hillyer Treeview • Located in Microsoft Windows Common Controls 6.0 • Useful for navigating groups or tables • All items are nodes, nodes have parent/child relationships to determine hierarchy • Set key values to link relationships Copyright 2003, Mike Hillyer Treeview Demonstration Copyright 2003, Mike Hillyer
The list of books you might like
