How do I solve invalid object error.

@Sinisa Hajnal. No i didn't change any connection strings. Also Default Login seems working.
You were talking about Published scope, can you please elaborate it.

Here is my Code behind @Karthik Bangalore:

using System;
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.Configuration;
using System.Web.Configuration;

namespace Synch
{
public partial class Centre_Cre : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
string IT_ITES = "SELECT (SELECT Count(case when [IT-ITES1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
string RETAIL = "SELECT (SELECT Count(case when [RETAIL1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
string LSC = "SELECT (SELECT Count(case when [LSC1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
string ESSCI = "SELECT (SELECT Count(case when [ESSCI1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
string TSSC = "SELECT (SELECT Count(case when [TSSC1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
string THSC = "SELECT (SELECT Count(case when [THSC1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
string GJSCI = "SELECT (SELECT Count(case when [GJSCI1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
string ASCI = "SELECT (SELECT Count(case when [ASCI1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
string CSDCI = "SELECT (SELECT Count(case when [CSDCI1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
string APPAREL = "SELECT (SELECT Count(case when [APPAREL1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
//string TOTAL = "SELECT (SELECT Count(case when [CSDCI1] = 'Approved' then 1 end) FROM Capacity WHERE State = '" + DropDownList1.SelectedValue + "')";
SqlCommand showresult1 = new SqlCommand(IT_ITES, con);
SqlCommand showresult2 = new SqlCommand(RETAIL, con);
SqlCommand showresult3 = new SqlCommand(LSC, con);
SqlCommand showresult4 = new SqlCommand(ESSCI, con);
SqlCommand showresult5 = new SqlCommand(TSSC, con);
SqlCommand showresult6 = new SqlCommand(THSC, con);
SqlCommand showresult7 = new SqlCommand(GJSCI, con);
SqlCommand showresult8 = new SqlCommand(ASCI, con);
SqlCommand showresult9 = new SqlCommand(CSDCI, con);
SqlCommand showresult0 = new SqlCommand(APPAREL, con);
//SqlCommand showresult2 = new SqlCommand(TOTAL, con);

con.Open();
lblstate.Text = DropDownList1.SelectedValue;
lblTOTAL.Text = (Int32.Parse(lblIT.Text) + Int32.Parse(lblRETAIL.Text) + Int32.Parse(lblLSC.Text) + Int32.Parse(lblESSCI.Text) + Int32.Parse(lblTSSC.Text) + Int32.Parse(lblTHSC.Text) + Int32.Parse(lblGJSCI.Text) + Int32.Parse(lblASCI.Text) + Int32.Parse(lblCSDCI.Text) + Int32.Parse(lblAPPAREL.Text)).ToString();

}
}