Connection String .

public static string dbconn = ConfigurationManager.AppSettings["dbcon"].ToString();

public void CenterBind()
{

using (SqlConnection sqlcon = new SqlConnection(dbconn))
{
string query = "MSP_GetDivision";
SqlCommand cmd = new SqlCommand(query, sqlcon);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sqlcon.Open();
da.Fill(dt);
dpd_CenterName.DataSource = dt;
dpd_CenterName.DataTextField = "divisn";
dpd_CenterName.DataValueField = "dvcode";
sqlcon.Close();


}