c# sql 연결하는 법
nuget 패키지 로 system.data.sqlclient 를 설치하여 프로젝트에 참조시킨다.
using system.data.sqlclient
|
string strConn = "Data Source=IP,port;Initial Catalog=DataBase;User ID=id;Password=pw";
SqlConnection sqlConn = new SqlConnection(strConn);
sqlConn.Open();
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = sqlConn;
myCommand.CommandText = "query";
myCommand.ExecuteNonQuery();
sqlConn.Close();
|
cs |