Database connector: MySQL, MS SQL and MS Access for Beginners
DRANK

IntroductionSome of the beginners in software development have a problem on making their first program with database management such us database connection and CRUD operation. There are many things to consider like:Create function to insert new record;Read function to provide a view;Update function to modify  record;And Delete function to remove a record.And also, there are many frameworks that offered a complete database features but none of them are taught in the colleges specifically in the remote area or small colleges.With this basic database connector. It is now easy to connect to the database and process CRUD operation. Public server_name As String = "DESKTOP-server" Public db_name As String = "database_pos" Public db_userid As String = "sa" Public db_password As String = "password" Public my_instance As String = "globalpos" Public myconns As New MJzeits.MJzeitMSSQL_MySQL.SQLdatabase() Using the codeThis connector is easy to use and manageable but still we need to install first…

codeproject.com
Related Topics: MySQL Microsoft Access SQL