//-------------------------------------------------------------------------------------------------------------------------------------------------
public SortedDictionary <int, employee> dataemp()
{
SqlConnection con1 = new SqlConnection("Data Source =.; Initial Catalog = DSProject; Integrated Security = True");
con1.Open();
SqlDataAdapter read = new SqlDataAdapter("select * from employees ", con1);
DataTable dt = new DataTable();
read.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
employee zft = new employee();
zft.name = dr["name"].ToString();
zft.Academic_year = (int)dr["Academic_year"];
zft.password = (int)dr["_password"];
emp.Add((int)dr["ID"], zft);
}
con1.Close();
return(emp);
}