void kawasan() { DataSet Ds = new DataSet(); try { string com = "select DISTINCT Area_Code,Area_Name from Ref_Kawasan ORDER BY Area_Name"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); if (dt != null) { adpt.Fill(dt); DD_kaw.DataSource = dt; DD_kaw.DataTextField = "Area_Name"; DD_kaw.DataValueField = "Area_Code"; DD_kaw.DataBind(); DD_kaw.Items.Insert(0, new ListItem("--- PILIH ---", "")); } else { DD_kaw.Items.Insert(0, new ListItem("--- PILIH ---", "")); } } catch (Exception ex) { throw ex; } string script1 = "$(function () {$('.select2').select2() });"; ScriptManager.RegisterStartupScript(this, this.GetType(), "", script1, true); }
void kawasan() { DataSet Ds = new DataSet(); try { string com = "select DISTINCT Area_Code,Area_Name from Ref_Kawasan ORDER BY Area_Name"; SqlDataAdapter adpt = new SqlDataAdapter(com, con); DataTable dt = new DataTable(); if (dt != null) { adpt.Fill(dt); DD_kaw.DataSource = dt; DD_kaw.DataTextField = "Area_Name"; DD_kaw.DataValueField = "Area_Code"; DD_kaw.DataBind(); DD_kaw.Items.Insert(0, new ListItem("--- PILIH ---", "")); } else { DD_kaw.Items.Insert(0, new ListItem("--- PILIH ---", "")); } } catch (Exception ex) { throw ex; } }