如何显示App.Config连接字符串的登录失败消息框 [英] How to display a login failure messagebox for App.Config connection string

问题描述

我使用以下连接字符串，并且能够登录到SQL 2008 R2 Server.

I use the following connection string and am able to log into SQL 2008 R2 Server.

My.Settings.Item("CustomerConnectionString") = "Data Source=FAROOK-PC\SQLEXPRESS;Initial 
Catalog= '" & Me.ComboBox1.Text & "'; uid = '" & Me.Login1.Text & "'; pwd = '" & 
Me.Password1.Text & "'"

如何在登录失败时显示消息框.

How do I display a messagebox on login failure.

谢谢.

推荐答案

使用尝试捕获块.如果连接失败，请在捕获块中使用您的消息框.

use Try Catch Block. If connection fails use yor message box in catch block.

Dim sqlCnn As New SqlConnection
Dim connString as string = "Your Connection String"
Try
   sqlCnn = New SqlConnection(connString)
   sqlCnn.open()
Catch ex As SqlException
   MsgBox("Login Failed")

End Try

这篇关于如何显示App.Config连接字符串的登录失败消息框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！