프로그래밍/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;
}
반응형