Пример #1
0
    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);
    }
Пример #2
0
    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;
        }
    }