Design a class in vb.net for accessing a remote mysql database.
Source written entirely in VB.net (c# NOT ACEPTED).
Source must be well commented
Target .net framework 3.5 +
No 3rd party libraries or dependencies to be used (except Devart dotconnect (free version))
Create methods in a single class that do the following...
will connect to the database and create a new shema (colums etc)
method CreateNewCustomer (customer name, serial number, email, etc, etc)
will connect to the database and create a new row for the customer populated with data
Method DeleteCustomer (emailaddress)
will delete customer row from database
method Search (select from... where... etc)
will run quiery on database and return results to a datagridview
function GetCustomer (emailaddress)
will find customer in database and return row fields to an array
Download Devart 'dotconnect express' (free edition) here:- [url removed, login to view]
Any questions please ask.
14 pekerja bebas membida secara purata $120 untuk pekerjaan ini
I have more than 10 years software development experience and over 4 years Database Architect and Engineering experience. I bring the best to the table