Depo Yazılım – Günlük Notlarım

C# .Net and the MySql Connector/Net

11 Temmuz 201211 Kasım 2014 webadmin 0 yorum CONNECT, Depo Yazılım, LOGO

Download Mysql.data

1	Download Mysql.data

<a href="http://dev.mysql.com/downloads/connector/net/1.0.html">http://dev.mysql.com/downloads/connector/net/1.0.html</a>

1	<a href="http://dev.mysql.com/downloads/connector/net/1.0.html">http://dev.mysql.com/downloads/connector/net/1.0.html</a>

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&lt;Reader.FieldCount;i++)
						thisrow+=Reader.GetValue(i).ToString() + ",";
				listBox1.Items.Add(thisrow);
			}
			connection.Close();
		}

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

}

Devam