void getData() { DataTable dt = new DataTable(); dt = std.dtStudent(txtRFID.Text); if (dt.Rows.Count > 0) { //txtRFID.Text = Convert.ToString(dt.Rows[0]["rfid"]); id = Convert.ToInt32(dt.Rows[0]["id"]); txtStudentID.Text = Convert.ToString(dt.Rows[0]["studentID"]); //txtLRN.Text = Convert.ToString(dt.Rows[0]["lrn"]); txtLname.Text = Convert.ToString(dt.Rows[0]["lname"]); txtFname.Text = Convert.ToString(dt.Rows[0]["fname"]); txtMname.Text = Convert.ToString(dt.Rows[0]["mname"]); txtSex.Text = Convert.ToString(dt.Rows[0]["sex"]); txtGrade.Text = Convert.ToString(dt.Rows[0]["grade"]); txtSection.Text = Convert.ToString(dt.Rows[0]["section"]); // txtProgram.Text = Convert.ToString(dt.Rows[0]["progCode"]); // txtDesc.Text = Convert.ToString(dt.Rows[0]["progDesc"]); // txtYearlvl.Text = Convert.ToString(dt.Rows[0]["yearlvl"]); txtguardian.Text = Convert.ToString(dt.Rows[0]["guardian"]); // txtc.Text = Convert.ToString(dt.Rows[0]["mobileNo"]); std.studentImage(picStudent, dt, "img"); } else { clear(); } }
void getData(string rfid, string aycode) { pictureBox1.Image = null; dtStd.Clear(); dtStd = student.dtStudent(rfid, aycode); if (dtStd.Rows.Count > 0) { id = (int)dtStd.Rows[0]["id"]; txtStudentID.Text = Convert.ToString(dtStd.Rows[0]["studentID"]); txtLname.Text = Convert.ToString(dtStd.Rows[0]["lname"]); txtFname.Text = Convert.ToString(dtStd.Rows[0]["fname"]); txtMname.Text = Convert.ToString(dtStd.Rows[0]["mname"]); txtSex.Text = Convert.ToString(dtStd.Rows[0]["sex"]); txtGrade.Text = Convert.ToString(dtStd.Rows[0]["grade"]) + " - " + Convert.ToString(dtStd.Rows[0]["section"]); // txtProgram.Text = (string)dtStd.Rows[0]["progCode"]; // txtDesc.Text = (string)dtStd.Rows[0]["progDesc"]; // txtYearlvl.Text = Convert.ToString(dtStd.Rows[0]["yearlvl"]); student.studentImage(pictureBox1, dtStd, "img"); //insert student logs for SMS //queue insertForSMS(); id = 0; } else { clearFields(); } }
public void getData() { DataTable dt = new DataTable(); dt = std.dtStudent(id); if (dt.Rows.Count > 0) { tempRFID = txtRFID.Text = Convert.ToString(dt.Rows[0]["rfid"]); txtStudentID.Text = Convert.ToString(dt.Rows[0]["studentID"]); txtLRN.Text = Convert.ToString(dt.Rows[0]["lrn"]); txtlname.Text = Convert.ToString(dt.Rows[0]["lname"]); txtfname.Text = Convert.ToString(dt.Rows[0]["fname"]); txtmname.Text = Convert.ToString(dt.Rows[0]["mname"]); cmbSex.Text = Convert.ToString(dt.Rows[0]["sex"]); cmbGrade.Text = Convert.ToString(dt.Rows[0]["grade"]); cmbSection.Text = Convert.ToString(dt.Rows[0]["section"]); // cmbProgram.Text = Convert.ToString(dt.Rows[0]["progCode"]); // txtyrlvl.Text = Convert.ToString(dt.Rows[0]["yearlvl"]); tempMobile = txtContact.Text = Convert.ToString(dt.Rows[0]["mobileNo"]); tempParentMobile = txtParentsContact.Text = Convert.ToString(dt.Rows[0]["pMobileNo"]); txtguardian.Text = Convert.ToString(dt.Rows[0]["guardian"]); std.studentImage(picStudent, dt, "img"); } }