public int GetLoginInfo(Student_tblDTO student_tbldto) { string query = "SELECT Count(*) FROM student_tbl WHERE student_id='" + student_tbldto.STUDENT_ID + "' AND password='******'"; int count = -1; if (dbconnect.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection); count = int.Parse(cmd.ExecuteScalar() + ""); dbconnect.CloseConnection(); return(count); } else { return(count); } }
public DataSet getSingleStudent(Student_tblDTO student_tbldto) { string query = "SELECT * FROM student_tbl WHERE student_id='" + student_tbldto.STUDENT_ID + "'"; if (dbconnect.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection); mysqlAdapter = new MySqlDataAdapter(cmd); dataSet = new DataSet(); mysqlAdapter.Fill(dataSet); dbconnect.CloseConnection(); return(dataSet); } else { return(dataSet); } }