public void GetConnectionString()
{
try
{
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
connString = rootWebConfig.ConnectionStrings.ConnectionStrings["Expenses"];
if (connection == null)
{
connection = new SqlConnection(connString.ToString());
Session["Connection"] = connection;
//connection.Open();
}
}
}
catch (Exception e)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(),
"MessageBox", "alert('" + e.Message + "');", true);
}
finally
{
if (connection != null && connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}