private void ListView_SelectedIndexChanged(object sender, EventArgs e)
{
if (listView.SelectedItems.Count > 0)
{
ListViewItem current = listView.SelectedItems[0];
start = (fingerdatabase)current.Tag;
currentuser = start.username;
currentid = start.userid;
currentscan = start.scanid;
}
}
public static fingerdatabase insert(string user, string u)
{
List <fingerdatabase> me = new List <fingerdatabase>();
string y = string.Format("INSERT INTO fingerdb(username,userid,scanid) VALUES('{0}','{1}','{2}')", user, u, "scan registered yet");
MySqlCommand cmd = new MySqlCommand(y, databaseconnection);
databaseconnection.Open();
cmd.ExecuteNonQuery();
fingerdatabase open = new fingerdatabase(user, u, "scan registered yet");
databaseconnection.Close();
return(open);
}
public static List <fingerdatabase> GetFingerdatabases()
{
List <fingerdatabase> user = new List <fingerdatabase>();
string query = "SELECT * FROM fingerdb";
MySqlCommand cmd = new MySqlCommand(query, databaseconnection);
databaseconnection.Open();
MySqlDataReader read = cmd.ExecuteReader();
while (read.Read())
{
string username = read["username"].ToString();
string userid = read["userid"].ToString();
string scanid = read["scanid"].ToString();
fingerdatabase u = new fingerdatabase(username, userid, scanid);
user.Add(u);
}
databaseconnection.Close();
return(user);
}