private void bindWilayah()
{
DataSet Ds = new DataSet();
try
{
string com = "select distinct wilayah_code,wilayah_name from Ref_Cawangan where kavasan_name='" + DD_kaw.SelectedItem.Text + "' order by wilayah_name asc ";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
if (dt != null)
{
DD_wilayah.DataSource = dt;
DD_wilayah.DataTextField = "wilayah_name";
DD_wilayah.DataValueField = "wilayah_code";
DD_wilayah.DataBind();
DD_wilayah.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
else
{
DD_wilayah.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
}
catch (Exception ex)
{
throw ex;
}
string script1 = "$(function () {$('.select2').select2() });";
ScriptManager.RegisterStartupScript(this, this.GetType(), "", script1, true);
}
private void bindWilayah()
{
DataSet Ds = new DataSet();
try
{
string com = "select distinct wilayah_code,wilayah_name from Ref_Cawangan where kavasan_name='" + DD_kaw.SelectedItem.Text + "' order by wilayah_name asc ";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
if (dt != null)
{
DD_wilayah.DataSource = dt;
DD_wilayah.DataTextField = "wilayah_name";
DD_wilayah.DataValueField = "wilayah_code";
DD_wilayah.DataBind();
DD_wilayah.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
else
{
DD_wilayah.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void ddkaw_SelectedIndexChanged(object sender, EventArgs e)
{
//-Pusat---------------------------------------------------------------------------------
string cmd6 = "select distinct wilayah_code,wilayah_name from Ref_Cawangan where cawangan_code='" + DD_cawangan.SelectedItem.Value + "'";
con.Open();
SqlDataAdapter adapterP = new SqlDataAdapter(cmd6, con);
adapterP.Fill(wilayah);
DD_wilayah.DataSource = wilayah;
DD_wilayah.DataTextField = "wilayah_name";
DD_wilayah.DataValueField = "wilayah_code";
DD_wilayah.DataBind();
//ddPusat.Items.RemoveAt(0); //remove 'Semua Wilayah'
con.Close();
DD_wilayah.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
protected void DD_kaw_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet Ds = new DataSet();
try
{
string com = "select distinct wilayah_code,wilayah_name from Ref_Cawangan where kavasan_name='" + DD_kaw.SelectedItem.Text + "' order by wilayah_name asc ";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_wilayah.DataSource = dt;
DD_wilayah.DataTextField = "wilayah_name";
DD_wilayah.DataValueField = "wilayah_code";
DD_wilayah.DataBind();
DD_wilayah.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
catch (Exception ex)
{
throw ex;
}
}
void wBind()
{
DataSet Ds = new DataSet();
try
{
SqlConnection con = new SqlConnection(conString);
string com = "select Wilayah_Code,Wilayah_Name from ref_wilayah order by Wilayah_Name ASC";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_wilayah.DataSource = dt;
DD_wilayah.DataBind();
DD_wilayah.DataTextField = "Wilayah_Name";
DD_wilayah.DataValueField = "Wilayah_Code";
DD_wilayah.DataBind();
DD_wilayah.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
catch (Exception ex)
{
throw ex;
}
}
protected void DD_kaw_SelectedIndexChanged(object sender, EventArgs e)
{
string script1 = "$(function () { $('#GridView1').prepend($('<thead></thead>').append($(this).find('tr:first'))).DataTable({ 'responsive': true, 'sPaginationType': 'full_numbers' }); $('.select2').select2() });";
ScriptManager.RegisterStartupScript(this, this.GetType(), "", script1, true);
DataSet Ds = new DataSet();
try
{
string com = "select distinct wilayah_code,wilayah_name from Ref_Cawangan where kavasan_name='" + DD_kaw.SelectedItem.Text + "' order by wilayah_name asc ";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_wilayah.DataSource = dt;
DD_wilayah.DataTextField = "wilayah_name";
DD_wilayah.DataValueField = "wilayah_code";
DD_wilayah.DataBind();
DD_wilayah.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
catch (Exception ex)
{
throw ex;
}
}