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)); }