protected void GetRateType() { ddlratetype.Items.Clear(); iCompanySetupClient CompanyClient = new iCompanySetupClient(); CustomProfile profile = CustomProfile.GetProfile(); ddlratetype.DataSource = CompanyClient.GetRateTypeDropdown("RateCard", profile.DBConnection._constr); ddlratetype.DataTextField = "Value"; ddlratetype.DataValueField = "Id"; ddlratetype.DataBind(); ListItem lst = new ListItem { Text = "-Select-", Value = "0" }; ddlratetype.Items.Insert(0, lst); CompanyClient.Close(); }