public DropDownList GetFaslForSaf(int EmpID,int SafID, DropDownList dlist)
{
OleDbCommand com = new OleDbCommand("SELECT DISTINCT gadwal_alhasas.fasl_code FROM gadwal_alhasas WHERE CODE=@CODE and alsofof_code=@alsofof_code", MySchool.GadwalConnection);
com.Parameters.AddWithValue("@CODE", EmpID);
com.Parameters.AddWithValue("@alsofof_code", SafID);
com.Connection.Open();
OleDbDataReader DR = com.ExecuteReader();
Codes cd = new Codes();
ListItem li;
dlist.Items.Clear();
dlist.Items.Add(new ListItem ("ÇÎÊÑ ÇáÝÕá .......","0"));
while (DR.Read())
{
string s = cd.ClassName(Convert.ToInt32(DR["fasl_code"]));
li = new ListItem(s, DR["fasl_code"].ToString());
dlist.Items.Add(li);
}
com.Connection.Close();
return dlist;
}
protected void Label5_DataBinding(object sender, EventArgs e)
{
Codes cd = new Codes();
(sender as Label).Text = cd.ClassName(Convert.ToInt32((sender as Label).Text));
}
