public void Bind_DataList()
{
var dt = this.conn.GetDataTable("SELECT * FROM vw_alert_sms order by TGL_SMS asc", null, this.dbtimeout, true, true);
if (dt.Rows.Count > 0)
{
DataList_sms.DataSource = dt;
DataList_sms.DataBind();
lb_Sms.Visible = false;
}
else
{
DataList_sms.DataSource = dt;
DataList_sms.DataBind();
lb_Sms.Visible = true;
}
}
protected void cari_Click(object sender, EventArgs e)
{
s_unit = ddl_UNIT.SelectedItem.Text;
var dt = this.conn.GetDataTable("SELECT * FROM vw_alert_sms where (UNIT = '" + ddl_UNIT.SelectedValue.ToString() + "' or isnull('" + ddl_UNIT.SelectedValue.ToString() + "' ,'')='') order by TGL_SMS asc", null, this.dbtimeout, true, true);
if (dt.Rows.Count > 0)
{
DataList_sms.DataSource = dt;
DataList_sms.DataBind();
lb_Sms.Visible = false;
}
else
{
DataList_sms.DataSource = dt;
DataList_sms.DataBind();
lb_Sms.Visible = true;
}
}
