프로그래밍/Visual C#

MS-SQL DB 연결

Dev-Drake 2020. 1. 2. 17:39
반응형
public bool ConnectDB()
{
	SqlConnection DBConn;

	bool Flag = true;

	String strConn = "Server=ip주소\\sqlexpress;"
                           + "database=DB명;"
                           + "uid=sa;"
                           + "pwd=패스워드;";

	try
	{
		DBConn = new System.Data.SqlClient.SqlConnection(strConn);
		DBConn.Open();
	}
	catch(Exception ex)
	{
		MessageBox.Show(ex.Message, "DB Test", 
        MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
		Flag = false;
	}

	if(Flag)	{
		MessageBox.Show("DB 연결 성공!!", "DB Test", 
        MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
	}
                
	return Flag;
}

 

반응형