c# sql 연동

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