快速判断SQL数据连接是否正常
我这里先做了一个Button按钮。用于测试所用!其Click事件:
private void Btn_Test_Click(object sender, EventArgs e) { if (!ContentSQL()) { MessageBox.Show("服务器连接失败!", "服务器连接", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } MessageBox.Show("服务器连接成功!", "服务器连接", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); }
private bool ContentSQL() { try { _sqlClient = new TcpClient(); var ar = _sqlClient.BeginConnect("192.168.0.1", 1433, null, null); ar.AsyncWaitHandle.WaitOne(500); return _sqlClient.Connected; } catch (Exception e) { ErrorLog.Add(e.ToString()); MessageBox.Show(e.ToString(),"连接失败",MessageBoxButtons.OK,MessageBoxIcon.Error); return false; } }
服务器IP:192.168.0.1