C#, VB에서 MySQL 사용하기

by **Admin** 2008-09-09, 6:24 am

1. C# , VB에서 MySQL DB 연동을 사용하려면 .Net Connecter 를 설치해야한다.
http://dev.mysql.com/downloads/connector/net/5.1.html

2. Visual C#, VB 2008을 실행한후 메뉴중 프로젝트 > 참조추가 > 찾아보기 > 경로 “C:\Program Files\MySQL\MySQL Connector Net 5.1.5\Binaries\.NET 2.0″ 에서 ‘MySql.Data.dll’ 을 지정해 준다.
[C#]
Form.cs 코드 편집창에 ‘using MySql.Data.MySqlClient;’ 을 추가한다.
[예제] MySQL 접속과 DB 변경, DB 접속상태, 자료입력에 대한 예
private void button1_Click(object sender, EventArgs e)
{
MySqlConnection myConnection = new MySqlConnection();
myConnection.ConnectionString = “Persist Security Info=False;database=디비명;server=localhost;Connect Timeout=30;user id=아이디; pwd=비번”;
myConnection.Open();
MessageBox.Show(”Server Version: ” + myConnection.ServerVersion + “\nDatabase: ” + myConnection.Database);
myConnection.ChangeDatabase(”dbs”);
MessageBox.Show(”ServerVersion: ” + myConnection.ServerVersion + “\nDatabase: ” + myConnection.Database);
MessageBox.Show(”ServerVersion: ” + myConnection.ServerVersion + “\nState: ” + myConnection.State.ToString());
myConnection.Close();
// 자료입력
InsertData();
}
public void InsertData()
{
MySqlConnection myConnection = new MySqlConnection();
myConnection.ConnectionString = “Persist Security Info=False;database=디비명;server=localhost;Connect Timeout=30;user id=아이디; pwd=비번”;
myConnection.Open();
string myInsertQuery = “INSERT INTO info (name, id, pass) Values(’이름’, ‘myid’, 1234)”;
MySqlCommand myCommand = new MySqlCommand(myInsertQuery);
myCommand.Connection = myConnection;
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
}
[VB] Form1.vb 코드편집창에 ‘Imports MySql.Data.MySqlClient’ 을 추가한다.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim myConnection As New MySqlConnection()
myConnection.ConnectionString = “Persist Security Info=False;database=디비명;server=localhost;Connect Timeout=30;user id=아이디; pwd=비번”
myConnection.Open()
End Sub
End Class