private void ViewStudentProfile_Load(object sender, EventArgs e) { this.Text = "Welcome " + stName; ob = new Gateway(); ob.FillDeptComboBox(); for (i = 0; i < ob.countDeptRow; i++) { stDeptComboBox.Items.Add(ob.deptName[i]); } connection.Open(); string queryString = "SELECT Student_ID,St_Name,(SELECT Dept_Name FROM Dept_Info_Table WHERE Dept_ID=Student_Info_Table.Dept_ID)as Dept,Year,Semester,Mobile,Email,Password FROM Student_Info_Table WHERE Student_ID='" + studentID + "'"; SqlCommand command = new SqlCommand(queryString, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { stIdTextBox.Text = reader["Student_ID"].ToString(); stNameTextBox.Text = reader["St_Name"].ToString(); stDeptComboBox.Text = reader["Dept"].ToString(); stYearComboBox.Text = reader["Year"].ToString(); stSemesterComboBox.Text = reader["Semester"].ToString(); stMobileTextBox.Text = reader["Mobile"].ToString(); stEmailTextBox.Text = reader["Email"].ToString(); stPassTextBox.Text = reader["Password"].ToString(); } connection.Close(); }
private void ViewTeacherProfile_Load(object sender, EventArgs e) { this.Text = "Welcome " + teacherName; ob = new Gateway(); ob.FillDeptComboBox(); for (i = 0; i < ob.countDeptRow; i++) { dNameComboBox.Items.Add(ob.deptName[i]); } connection.Open(); string queryString = "SELECT Teacher_ID,Teacher_Name,Designation,(SELECT Dept_Name FROM Dept_Info_Table WHERE Dept_ID=Teacher_Info_Table.Dept_ID)as Dept,Password FROM Teacher_Info_Table WHERE Teacher_ID='" + teacherID + "'"; SqlCommand command = new SqlCommand(queryString, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { teacherIdTextBox.Text = reader["Teacher_ID"].ToString(); teacherNameTextBox.Text = reader["Teacher_Name"].ToString(); designationTextBox.Text = reader["Designation"].ToString(); dNameComboBox.Text = reader["Dept"].ToString(); passwordTextBox.Text = reader["Password"].ToString(); } connection.Close(); }
private void AddStudent_Info_Load(object sender, EventArgs e) { ob = new Gateway(); ob.FillDeptComboBox(); for (i = 0; i < ob.countDeptRow; i++) { stDeptComboBox.Items.Add(ob.deptName[i]); } }
private void Add_Teacher_Info_Load(object sender, EventArgs e) { ob = new Gateway(); ob.FillDeptComboBox(); for (i = 0; i < ob.countDeptRow; i++) { dNameComboBox.Items.Add(ob.deptName[i]); searchDeptComboBox.Items.Add(ob.deptName[i]); } }
private void Add_Dept_Info_Load(object sender, EventArgs e) { int i; gateways = new Gateway(); gateways.FillDeptComboBox(); for (i = 0; i < gateways.countDeptRow; i++) { searchComboBox.Items.Add(gateways.deptName[i]); } }
private void Add_Routine_Info_Load(object sender, EventArgs e) { //For Course ComboBox Tooltip------------------------------ courseComboBox.DrawMode = DrawMode.OwnerDrawFixed; courseComboBox.DrawItem += courseComboBox_DrawItem; courseComboBox.DropDownClosed += courseComboBox_DropDownClosed; //Fill Dept Name ComboBox ---------------------------------- gateways = new Gateway(); gateways.FillDeptComboBox(); for (i = 0; i < gateways.countDeptRow; i++) { deptNameComboBox.Items.Add(gateways.deptName[i]); searchDeptComboBox.Items.Add(gateways.deptName[i]); deptForTeachercomboBox.Items.Add(gateways.deptName[i]); } }
private void Teacher_Profile_Load(object sender, EventArgs e) { //teacherDataGridView.AutoGenerateColumns = false; this.Text = teacherName; // Tool tip for Course ComboBox courseComboBox.DrawMode = DrawMode.OwnerDrawFixed; courseComboBox.DrawItem += courseComboBox_DrawItem; courseComboBox.DropDownClosed += courseComboBox_DropDownClosed; // Fill Dept ComboBox gateways = new Gateway(); gateways.FillDeptComboBox(); for (c = 0; c < gateways.countDeptRow; c++) { deptComboBox.Items.Add(gateways.deptName[c]); } //---------------------------- }