public DataSet GetData(int item, string str)
{
stStudent StudentData = new stStudent(0, "", "");
Student = new ArrayList();
DataSet ds = new DataSet();
using (var conn = new SQLiteConnection(connStr))
{
conn.Open();
string sql = "SELECT * FROM Student WHERE StudentNum =\"" + item + "\"";
SQLiteDataAdapter adapter = new SQLiteDataAdapter(sql, conn);
adapter.Fill(ds);
}
return ds;
}
public DataSet GetData(int item, string str)
{
stStudent StudentData = new stStudent(0, "", "");
Student = new ArrayList();
DataSet ds = new DataSet();
using (var conn = new SQLiteConnection(connStr))
{
conn.Open();
string sql = "SELECT * FROM Student WHERE StudentNum =\"" + item + "\"";
SQLiteDataAdapter adapter = new SQLiteDataAdapter(sql, conn);
adapter.Fill(ds);
}
return(ds);
}
public ArrayList Select_Reader(eItem item, string str)
{
stStudent StudentData = new stStudent(0, "", "");
Student = new ArrayList();
using (var conn = new SQLiteConnection(connStr))
{
conn.Open();
string sql = "SELECT * FROM Student WHERE studentNum =\"" + str + "\"";
SQLiteCommand cmd = new SQLiteCommand(sql, conn);
SQLiteDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
StudentData.studentNum =Convert.ToInt32(rdr["studentNum"]);
StudentData.name = rdr["name"].ToString();
StudentData.phone = rdr["phone"].ToString();
Student.Add(Student);
}
rdr.Close();
}
return Student;
}
public ArrayList Select_Reader(eItem item, string str)
{
stStudent StudentData = new stStudent(0, "", "");
Student = new ArrayList();
using (var conn = new SQLiteConnection(connStr))
{
conn.Open();
string sql = "SELECT * FROM Student WHERE studentNum =\"" + str + "\"";
SQLiteCommand cmd = new SQLiteCommand(sql, conn);
SQLiteDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
StudentData.studentNum = Convert.ToInt32(rdr["studentNum"]);
StudentData.name = rdr["name"].ToString();
StudentData.phone = rdr["phone"].ToString();
Student.Add(Student);
}
rdr.Close();
}
return(Student);
}