UPDATE note SET note=18.5,mention="VERY GOOD" FROM note INNER JOIN matières ON note.id_matière=matières.id INNER JOIN élèves ON note.id_élève=élèves.id WHERE matière="Français" AND nom="DUPOND" AND prénom="JEAN-DANIEL"
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionpublic void AddStudent(string path, List<string> ListStudent) { string dir = Path.GetDirectoryName(path); SQLiteConnectionStringBuilder sqlString = new SQLiteConnectionStringBuilder(); sqlString.DataSource = dir + @"\data.gkc.db"; sqlString.FailIfMissing = false; string pramas = sqlString.ToString(); SQLiteConnection myConnection = new SQLiteConnection(pramas); SQLiteCommand cmd = myConnection.CreateCommand(); myConnection.Open(); for (int i=0; i<ListStudent.Count;i++) { cmd.CommandText "SELECT id FROM Students where Student "+ListStudent[i]+";"; if ((cmd.ExecuteNonQuery()) > 0) continue; else { cmd.CommandText = "INSERT INTO Students (Student) VALUES ('" + ListStudent[i] + "');"; cmd.ExecuteNonQuery(); } } myConnection.Close(); MessageBox.Show("Data Base Uploaded"); }
cmd.CommandText "SELECT id FROM Students where Student "+ListStudent[i]+";"; if (cmd.ExecuteScalar != DBNull.Value) continue; else
SQLiteDataReader Reader = cmd.ExecuteReader(); if (Reader.Read()) {..... }