|
|
How to connect to MySQL 5.0. via C# .Net and the MySql Connector/Net |
This article and tutorial describes and demonstrates how you can connect to MySQL in a c# application.
-
-
Next create a new project
-
Next add reference to: MySql.Data
-
Next add "using MySql.Data.MySqlClient;"
-
Finally add the following code to your application:
private void button1_Click(object sender, System.EventArgs e) { string MyConString = "SERVER=localhost;" + "DATABASE=mydatabase;" + "UID=testuser;" + "PASSWORD=testpassword;"; MySqlConnection connection = new MySqlConnection(MyConString); MySqlCommand command = connection.CreateCommand(); MySqlDataReader Reader; command.CommandText = "select * from mycustomers"; connection.Open(); Reader = command.ExecuteReader(); while (Reader.Read()) { string thisrow = ""; for (int i= 0;i<Reader.FieldCount;i++) thisrow+=Reader.GetValue(i).ToString() + ","; listBox1.Items.Add(thisrow); } connection.Close(); } |
|
|
|
| Highlighted Products |
|
|
|
|
|
|
|
|
ThunderStor
BitDaddys Corp.
$10
More Info
Free Trial
Buy Now!
|
|
ThunderStor offers the user a simple, fast and effective method to extract ThunderBird Mail from the mail box files to individual standard email message files. |
|
|
|
|
EMLDETACH
BitDaddys Corp.
$12.00
More Info
Free Trial
Buy Now!
|
|
Detach Email Attachments from your .eml files and Save them wherever you want! Extract your message attachments from eml files. more ... |
|
|
|
|
emlBridge
BitDaddys Corp.
$12.00
More Info
Free Trial
Buy Now!
|
|
Import eml Files into nearly any Email Client. With emlBridge you can import rfc822 standard text email files into programs like Outlook, Thunderbird and Outlook Express more ... |
|
|
|
|
mboxPack
BitDaddys Corp.
$10.00
More Info
Free Trial
Buy Now! |
|
Pack email files into mbox files. Plain text, individual eml,msg,txt files to Thunderstor compatable and ready to use mbox more ... |
|
|
|
|
|
|
|
|
|