windows form C# project using PhpMyAdmin platform

[Gennady Gurin]

Hi, I am new to this. To make it brief, I have Windows Form project with C#.

I need to use MySQL database. I created a database with PhpMyAdmin on my local

drive. Then created a table with its fields: FName, LName, Email, Phone, Key,

DateTime, SystemID. All of them varchar except Date Time. Then I changed a user

name and password of my database. All I need is a code example in C#, how to

connect to my database with user and password, to my table, which is "users",

and INSERT statement. And maybe later on SEARCH by Key, so that when match is

found (except spaces) I have to do a certain action. Thanks in advance.