private void fillGauge(int custId) { try { string stgauge = q.GetGaugeIdname(custId); DataTable dtgauge = g.ReturnData(stgauge); ddlGauge.DataSource = dtgauge; ddlGauge.DataTextField = "gaugeNameAndID"; ddlGauge.DataValueField = "gauge_id"; ddlGauge.DataBind(); ddlGauge.Items.Insert(0, "--Select--"); } catch (Exception ex) { g.ShowMessage(this.Page, ex.Message); } }