public void DataBindToDDL(string customerID) { decimal deliveryCharges = 0; //Get Login Customer's Township CustomerController customerController = new CustomerController(); string CustomerTownship = customerController.GetTownshipByCustomerID(customerID); txtCustomerTownship.Text = CustomerTownship; DeliFeesController deliFeesController = new DeliFeesController(); DataTable dt_township = deliFeesController.GetAllTownship(); for (int i = 0; i < dt_township.Rows.Count; i++) { //Get Delivery Charges by Login Customer's Township if (CustomerTownship.CompareTo(dt_township.Rows[i]["Township"].ToString()) == 0) { deliveryCharges = Convert.ToDecimal(dt_township.Rows[i]["DeliFees"].ToString()); } ddlTownship.Items.Add((i).ToString()); ddlTownship.Items[i].Text = dt_township.Rows[i]["Township"].ToString(); //When value are same, we can get wrong selected text because of same value. So combine "Township" and "Fees". ddlTownship.Items[i].Value = dt_township.Rows[i]["Township"].ToString() + "-" + dt_township.Rows[i]["DeliFees"].ToString(); } ddlTownship.Items.FindByText(CustomerTownship).Selected = true; lblDeliveryCharges.Text = decimal.Round(deliveryCharges, 2).ToString(); }
protected void Page_Load(object sender, EventArgs e) { DeliFeesController deliFeesController = new DeliFeesController(); DataTable dt_township = deliFeesController.GetAllTownship(); ddlTownship.DataSource = dt_township; ddlTownship.DataBind(); ddlTownship.DataTextField = "Township"; ddlTownship.DataValueField = "Township"; ddlTownship.DataBind(); }