void kategori()
{
DataSet Ds = new DataSet();
try
{
string com = "select ast_kategori_Code,ast_kategori_desc From Ref_ast_kategori where Status='A'";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_Kategori.DataSource = dt;
DD_Kategori.DataTextField = "ast_kategori_desc";
DD_Kategori.DataValueField = "ast_kategori_Code";
DD_Kategori.DataBind();
DD_Kategori.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
catch (Exception ex)
{
throw ex;
}
}
void kod()
{
DataSet Ds = new DataSet();
try
{
string com = "select UPPER(kavasan_name) as kavasan_name from Ref_Cawangan group by kavasan_name";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DD_Kategori.DataSource = dt;
DD_Kategori.DataBind();
DD_Kategori.DataTextField = "kavasan_name";
DD_Kategori.DataValueField = "kavasan_name";
DD_Kategori.DataBind();
DD_Kategori.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
catch (Exception ex)
{
throw ex;
}
}
