private void BindGrid(string sql) { var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); if (dt.Rows.Count > 0) { FeeId = dt.Rows[0]["FeeId"].ToString(); txtStudentName.Text = dt.Rows[0]["StudentName"].ToString(); txtRollNo.Text = dt.Rows[0]["RollNo"].ToString(); txtCourse.Text = dt.Rows[0]["Course"].ToString(); txtSemester.Text = dt.Rows[0]["Semester"].ToString(); objGlobal.getPictureFromDatabase(picStudent, dt, 0, "StudentPic"); foreach (DataRow dr in dt.Rows) { dataGridFeeView.Rows.Add(); dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["Id"].Value = dr["FeeId"]; dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["CategoryName"].Value = dr["CategoryName"]; dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["PaidDate"].Value = dr["PaidDate"]; dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["TotalAmount"].Value = dr["TotalAmount"]; dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["PaidAmount"].Value = dr["PaidAmount"]; dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["DueAmount"].Value = dr["DueAmount"]; } } else { MessageBox.Show("Không tìm thấy!", Global.Caption, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtSearch.Focus(); txtSearch.SelectAll(); } }
private void GetDataBind(string sql) { var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); if (dt.Rows.Count > 0) { _TeacherId = dt.Rows[0]["Id"].ToString(); txtTeacherName.Text = dt.Rows[0]["TeacherName"].ToString(); if (dt.Rows[0]["Gender"].ToString().Trim().Equals("Male") == true) { this.rdMale.Checked = true; } else { this.rdFemale.Checked = true; } txtAddress.Text = dt.Rows[0]["Address"].ToString(); mtxtRegisterDate.Text = dt.Rows[0]["RegisterDate"].ToString(); txtPhoneNo.Text = dt.Rows[0]["PhoneNo"].ToString(); txtEmail.Text = dt.Rows[0]["Email"].ToString(); cmbExperience.Text = dt.Rows[0]["Experience"].ToString(); ObjGlobal.getPictureFromDatabase(picTeacher, dt, 0, "TPhoto"); } else { MessageBox.Show("Record not found!", Global.Caption, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtSearch.Focus(); txtSearch.SelectAll(); } }
private void BindDataB(string sql) { var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); foreach (DataRow dr in dt.Rows) { CourseId = Convert.ToInt32(dr["Id"]); } }
private void cmbSubjectName_SelectedIndexChanged(object sender, EventArgs e) { var sql = "SELECT * from SubjectDetails Where CourseName='" + cmbCourse.Text + "' AND Semester='" + cmbSemester.Text + "' AND SubjectName='" + cmbSubjectName.Text + "'"; var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); foreach (DataRow dr in dt.Rows) { this.SubjCode = Convert.ToInt32(dr["Id"]); } }
private void cmbSemester_SelectedIndexChanged(object sender, EventArgs e) { var sql = "SELECT * from Course Where CourseName='" + cmbCourse.Text + "' AND Semester='" + cmbSemester.Text + "'"; var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); foreach (DataRow dr in dt.Rows) { this.CId = dt.Rows[0]["Id"].ToString(); } }
private void BindDataA(string sql) { var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); this.cmbSemester.Items.Clear(); this.cmbSemester.DropDownHeight = 106; foreach (DataRow dr in dt.Rows) { this.cmbSemester.Items.Add(dr["Semester"]); } }
private void cmbTeacherName_SelectedIndexChanged(object sender, EventArgs e) { picTeacher.Image = null; var sql = "SELECT * from TeacherRegister Where TeacherName='" + cmbTeacherName.Text + "'"; var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); foreach (DataRow dr in dt.Rows) { this.TeacherId = Convert.ToInt32(dr["Id"]); objGlobal.getPictureFromDatabase(picTeacher, dt, 0, "TPhoto"); } }
private void cmbStudentName_SelectedIndexChanged(object sender, EventArgs e) { var sql = "SELECT * from RegStudent Where StudentName='" + cmbStudentName.Text + "'"; var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); foreach (DataRow dr in dt.Rows) { this.Sid = dr["Id"].ToString(); this.txtRollNo.Text = dr["RollNo"].ToString(); objGlobal.getPictureFromDatabase(picStudent, dt, 0, "StudentPic"); } }
private void cmbCourse_SelectedIndexChanged(object sender, EventArgs e) { this.cmbSemester.Enabled = true; var sql = "SELECT * from Course Where CourseName='" + cmbCourse.Text + "'"; var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); this.cmbSemester.Items.Clear(); this.cmbSemester.DropDownHeight = 106; foreach (DataRow dr in dt.Rows) { this.cmbSemester.Items.Add(dr["Semester"]); } }
private void cmbSemester_SelectedIndexChanged(object sender, EventArgs e) { this.cmbSubjectName.ResetText(); this.cmbSubjectName.Items.Clear(); this.cmbSubjectName.DropDownHeight = 106; BindDataB("SELECT * from Course Where CourseName='" + cmbCourse.Text + "' AND Semester='" + cmbSemester.Text + "'"); var sql = "SELECT * from SubjectDetails Where CourseName='" + cmbCourse.Text + "' AND Semester='" + cmbSemester.Text + "'"; var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); foreach (DataRow dr in dt.Rows) { this.cmbSubjectName.Items.Add(dr["SubjectName"]); } }
private void GetDataBind(string sql) { var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); if (dt.Rows.Count > 0) { txtStudentName.Text = dt.Rows[0]["StudentName"].ToString(); txtRollNo.Text = dt.Rows[0]["RollNo"].ToString(); txtCourse.Text = dt.Rows[0]["Course"].ToString(); txtSemester.Text = dt.Rows[0]["Semester"].ToString(); objGlobal.getPictureFromDatabase(picStudent, dt, 0, "StudentPic"); } else { MessageBox.Show("Record not found!", Global.Caption, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtSearch.Focus(); txtSearch.SelectAll(); } }
private void GetDataBind(string sql) { var getdata = new lib.DatabaseConnection(); DataTable dt = new DataTable(); dt = getdata.getSearchData(sql); if (dt.Rows.Count > 0) { StudentId = dt.Rows[0]["Id"].ToString(); txtRollNo.Text = dt.Rows[0]["RollNo"].ToString(); txtStudentName.Text = dt.Rows[0]["StudentName"].ToString(); if (dt.Rows[0]["Gender"].ToString().Trim().Equals("Male") == true) { this.rdMale.Checked = true; } else { this.rdFemale.Checked = true; } txtAddress.Text = dt.Rows[0]["Address"].ToString(); mtxtDOB.Text = dt.Rows[0]["DateOfBirth"].ToString(); mtxtAdmissionDate.Text = dt.Rows[0]["AdmissionDate"].ToString(); txtPhoneNo.Text = dt.Rows[0]["PhoneNo"].ToString(); txtEmail.Text = dt.Rows[0]["Email"].ToString(); cmbCountry.Text = dt.Rows[0]["Country"].ToString(); cmbShift.Text = dt.Rows[0]["Shift"].ToString(); cmbCourse.Text = dt.Rows[0]["Course"].ToString(); cmbSemester.Text = dt.Rows[0]["Semester"].ToString(); objGlobal.getPictureFromDatabase(picStudent, dt, 0, "StudentPic"); } else { MessageBox.Show("Record not found!", Global.Caption, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtSearch.Focus(); txtSearch.SelectAll(); } }