public DropDownList GetSafForEmp(int EmpID, DropDownList dlist)
{
OleDbCommand com = new OleDbCommand("SELECT DISTINCT gadwal_alhasas.alsofof_code FROM gadwal_alhasas WHERE (((gadwal_alhasas.CODE)=@CODE))", MySchool.GadwalConnection);
com.Parameters.AddWithValue("@CODE", EmpID);
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.StageName(Convert.ToInt32(DR["alsofof_code"]));
li = new ListItem(s, DR["alsofof_code"].ToString());
dlist.Items.Add(li);
}
com.Connection.Close();
return dlist;
}
protected void Label4_DataBinding(object sender, EventArgs e)
{
Codes cd = new Codes();
(sender as Label).Text = cd.StageName(Convert.ToInt32((sender as Label).Text));
}
