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);
}
}
