How to validate dataSource name and PortNumber in Connection String of SqlConnection

Question

Please tell how to validate dataSource name and PortNumber in Connection String of SqlConnection. Connection state changes to Open, even I donot give any value for dataSource. Like the code below..

var Connection = new SqlConnection("Data Source=;Trusted_Connection=True");
try
{
    Connection.Open();
    MessageBox.Show("Connection Succeeded");
}

My requirement is I need to validate the Data Source name and Port Number that are entered by EndUser.

If no data source and port number is defined then an SQLException is thrown at Connection.Open, so do you want to validate connection string before opening connection — Deepak Bhatia
– Deepak Bhatia, Commented Oct 25, 2013 at 10:54

Deepak Bhatia · Accepted Answer · 2013-10-25 12:07:02Z

1

For offline validation, use SqlConnectionStringBuilder to parse it...

SqlConnectionStringBuilder myconBuilder = new SqlConnectionStringBuilder();
myconBuilder.ConnectionString = "Data Source=;Trusted_Connection=True";  //Throws exception if garbage connection string like 'abcd' is supplied
if (string.IsNullOrWhiteSpace(myconBuilder.DataSource))
{ 
    //Throw exception that data source specified is blank 
}

answered Oct 25, 2013 at 12:07

Deepak Bhatia

6,2962 gold badges28 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to validate dataSource name and PortNumber in Connection String of SqlConnection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related