private void AddGroup_Load(object sender, EventArgs e)
{
string connection = "Data Source= DESKTOP-A4JVK6F\\SQLEXPRESS; Initial Catalog=AZTU; Integrated Security=true;";
using (SqlConnection sqlConnection = new SqlConnection(connection))
{
sqlConnection.Open();
string facConnect = "Data Source=DESKTOP-A4JVK6F\\SQLEXPRESS; Initial Catalog=AZTU; Integrated Security=true;";
List <Faculty> faculties = new List <Faculty>();
using (SqlConnection facConnection = new SqlConnection(facConnect))
{
facConnection.Open();
string facQuery = "SELECT F.ID AS FacID, F.Name AS FacName FROM Faculties AS F";
using (SqlCommand facCommand = new SqlCommand(facQuery, facConnection))
{
using (SqlDataReader sqlDataReader = facCommand.ExecuteReader())
{
using (DataTable dataTable = new DataTable())
{
while (sqlDataReader.Read())
{
Faculty faculty = new Faculty()
{
ID = int.Parse(sqlDataReader["FacID"].ToString()),
Name = sqlDataReader["FacName"].ToString()
};
faculties.Add(faculty);
}
}
}
}
}
List <FacCombo> facCombos = new List <FacCombo>();
for (int i = 0; i < faculties.Count; i++)
{
FacCombo facCombo = new FacCombo()
{
ID = faculties[i].ID,
Name = faculties[i].Name
};
facCombos.Add(facCombo);
}
cmbx_faculty.ValueMember = "ID";
cmbx_faculty.DisplayMember = "Name";
cmbx_faculty.DataSource = facCombos;
}
}
private void StudentRatingForFaculty_Load(object sender, EventArgs e)
{
string connection = "Data Source= DESKTOP-A4JVK6F\\SQLEXPRESS; Initial Catalog=AZTU; Integrated Security=true;";
using (SqlConnection sqlConnection = new SqlConnection(connection))
{
sqlConnection.Open();
//--------------- Session combobox on load--------------------------
string sesQuery = " SELECT ID ,Name FROM Sessions";
using (SqlCommand sesCommand = new SqlCommand(sesQuery, sqlConnection))
{
SqlDataReader sesReader = sesCommand.ExecuteReader();
DataTable sesTable = new DataTable();
sesTable.Columns.Add("ID", typeof(string));
sesTable.Columns.Add("Name", typeof(string));
sesTable.Load(sesReader);
cmbx_session.ValueMember = "ID";
cmbx_session.DisplayMember = "Name";
cmbx_session.DataSource = sesTable;
}
//----------------- Faculty combobox on load ----------------------------
string facConnect = "Data Source= DESKTOP-A4JVK6F\\SQLEXPRESS; Initial Catalog=AZTU; Integrated Security=true;";
List <Faculty> faculties = new List <Faculty>();
using (SqlConnection facConnection = new SqlConnection(facConnect))
{
facConnection.Open();
string facQuery = "SELECT F.ID AS FacID, F.Name AS FacName FROM Faculties AS F";
using (SqlCommand facCommand = new SqlCommand(facQuery, facConnection))
{
using (SqlDataReader sqlDataReader = facCommand.ExecuteReader())
{
using (DataTable dataTable = new DataTable())
{
while (sqlDataReader.Read())
{
Faculty faculty = new Faculty()
{
ID = int.Parse(sqlDataReader["FacID"].ToString()),
Name = sqlDataReader["FacName"].ToString()
};
faculties.Add(faculty);
}
}
}
}
}
List <FacCombo> facCombos = new List <FacCombo>();
for (int i = 0; i < faculties.Count; i++)
{
FacCombo facCombo = new FacCombo()
{
ID = faculties[i].ID,
Name = faculties[i].Name
};
facCombos.Add(facCombo);
}
cmbx_faculty.ValueMember = "ID";
cmbx_faculty.DisplayMember = "Name";
cmbx_faculty.DataSource = facCombos;
}
}
private void AddPountForm_Load(object sender, EventArgs e)
{
#region profession combo fil on form load
//string conString = "Data Source=DESKTOP-6D6VFHT\\TSQL;Initial Catalog=AZTU;Integrated Security=SSPI";
//string PrfQuery = "Select ID,Name From Professions";
//SqlConnection sqlConnection = new SqlConnection(conString);
//sqlConnection.Open();
//SqlCommand prfCommand = new SqlCommand(PrfQuery, sqlConnection);
//SqlDataReader PrfReader = prfCommand.ExecuteReader();
//DataTable PrfDtable = new DataTable();
//PrfDtable.Columns.Add("ID", typeof(string));
//PrfDtable.Columns.Add("Name", typeof(string));
//PrfDtable.Load(PrfReader);
//cmbx_profession.ValueMember = "ID";
//cmbx_profession.DisplayMember = "Name";
//cmbx_profession.DataSource = PrfDtable;
//grbx_subjects.Hide();
#endregion
string facConnect = "Data Source= DESKTOP-A4JVK6F\\SQLEXPRESS; Initial Catalog=AZTU; Integrated Security=true;";
List <Faculty> faculties = new List <Faculty>();
using (SqlConnection facConnection = new SqlConnection(facConnect))
{
facConnection.Open();
string facQuery = "SELECT F.ID AS FacID, F.Name AS FacName FROM Faculties AS F";
using (SqlCommand facCommand = new SqlCommand(facQuery, facConnection))
{
//SqlDataReader facReader = facCommand.ExecuteReader();
//DataTable facTable = new DataTable();
//facTable.Columns.Add("ID", typeof(string));
//facTable.Columns.Add("Name", typeof(string));
//facTable.Load(facReader);
using (SqlDataReader sqlDataReader = facCommand.ExecuteReader())
{
using (DataTable dataTable = new DataTable())
{
while (sqlDataReader.Read())
{
Faculty faculty = new Faculty()
{
ID = int.Parse(sqlDataReader["FacID"].ToString()),
Name = sqlDataReader["FacName"].ToString()
};
faculties.Add(faculty);
}
}
}
}
}
List <FacCombo> facCombos = new List <FacCombo>();
for (int i = 0; i < faculties.Count; i++)
{
FacCombo facCombo = new FacCombo()
{
ID = faculties[i].ID,
Name = faculties[i].Name
};
facCombos.Add(facCombo);
}
cmbx_faculty.ValueMember = "ID";
cmbx_faculty.DisplayMember = "Name";
cmbx_faculty.DataSource = facCombos;
}
