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