كيف استطيع الاتصال مع قواعد البيانات البعيدة

First, you need to install the mysql connector/net, it is located at: http://dev.mysql.com/downloads/connector/net/1.0.html

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();

}

منقول من هنا

http://bitdaddys.com/MySQL-ConnectorNet.html

نفس طريقة الاتصال مع القواعد القريبة فقط غير الConnection String