Monday, January 4, 2016

Check if sql connection string is valid



string cs = "Data Source=.\\SQLEXPRESS;Initial Catalog=HawaiianAirlines_Analytics;Integrated Security=False;User ID=sa;Password=Oregon@2008";

            using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(cs))
            {
                conn.Open(); // throws if invalid

            }

No comments:

Post a Comment