private void TeacherList()
{
var selectQuery = "SELECT TeacherName from TeacherRegister";
var sql = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = sql.getData(selectQuery);
foreach (DataRow dr in dt.Rows)
{
this.cmbTeacherName.Items.Add(dr["TeacherName"]);
}
}
private void CourseList()
{
var selectQuery = "SELECT Distinct CourseName from Course";
var sql = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = sql.getData(selectQuery);
foreach (DataRow dr in dt.Rows)
{
this.cmbCourse.Items.Add(dr["CourseName"]);
}
}
private void SemesterList()
{
var selectQuery = "SELECT * from Semester";
var sql = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = sql.getData(selectQuery);
foreach (DataRow dr in dt.Rows)
{
this.cmbSemester.Items.Add(dr["SemesterId"]);
}
}
private void BindCategory()
{
var selectQuery = "SELECT * from FeeManage";
var sql = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = sql.getData(selectQuery);
foreach (DataRow dr in dt.Rows)
{
this.cmbCategory.Items.Add(dr["Category"]);
}
}
private void frmStudentReports_Load(object sender, EventArgs e)
{
lib.CourseDetails objCourseDetails = new lib.CourseDetails();
var selectQuery = "SELECT Distinct CourseName from Course";
var sql = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = sql.getData(selectQuery);
foreach (DataRow dr in dt.Rows)
{
this.comboBox1.Items.Add(dr["CourseName"]);
}
}
private void cmbCategory_SelectedIndexChanged(object sender, EventArgs e)
{
this.txtPaidAmount.Clear();
//this.txtDueAmount.Clear();
var selectQuery = "SELECT * from FeeManage Where Category='" + cmbCategory.Text + "'";
var sql = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = sql.getData(selectQuery);
foreach (DataRow dr in dt.Rows)
{
this.txtAmount.Text = dr["Amount"].ToString();
}
}
