using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Web.Configuration;

namespace WebApplication16
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string connectionString = "Data Source=localhost; Initial Catalog=Database1.mdf; Integrated Security=SSPI";
            SqlConnection con = new SqlConnection(connectionString);
            
            try
            {
                con.Open();
                TextBox1.Text = "Server Version: " + con.ServerVersion;
                TextBox1.Text += "Connection Is: " + con.State.ToString();
            }
            catch (Exception err)
            {
                TextBox1.Text = "Error . ---------         " + err.Message;
            }
            finally
            {
                con.Close();
                TextBox1.Text += " NOw Connection is: " + con.State.ToString();
                


            }
        }
    }
}