public static void UpdateMovie(MovieClass Movie,int LastIndex) { try { if (DBCon.ConnectionString == "") { DBCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Directory.GetCurrentDirectory() + "\\Movies.mdb;User Id=Admin;Password=;"; DBCon.Open(); } string command = "UPDATE Movies SET "; command += "Name = '" + WorkerClass.StringWithoutApostrophe(Movie.Movie_Name) + "',"; command += "[Year] = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_Year()) + "',"; command += "[Mark] = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_Mark()) + "',"; command += " IMDb_Adress = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_IMDB_Adress()) + "',"; command += " [Date] = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_Date_Month().ToString()) + "/" + WorkerClass.StringWithoutApostrophe(Movie.Get_Date_Day().ToString()) + "/" + WorkerClass.StringWithoutApostrophe(Movie.Get_Date_Year().ToString()) + "',"; command += " [Review] = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_Review()) + "',"; command += " RunTime = '" + Movie.Runtime + "',"; command += " IMDb_Name = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_IMDB_Name()) + "',"; command += " IMDb_Mark = '" + Movie.Get_IMDB_Mark() + "',"; command += " DirectorName = '" + WorkerClass.StringWithoutApostrophe(Movie.Director) + "',"; command += " DirectorWebLink = '" + Movie.DirectorLink + "',"; command += " [Country] = '" + WorkerClass.StringWithApostrophe(WorkerClass.ListToString(Movie.Get_Country())) + "',"; command += " Stars = '" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_Stars())) + "',"; command += " StarsLink = '" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_StarsLink())) + "',"; command += " Genres = '" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_Genre())) + "',"; command += " [Language] = '" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_Language())) + "',"; command += " Tags = '" + WorkerClass.StringWithApostrophe(WorkerClass.ListToString(Movie.Get_Tags())) + "',"; command += " StoryLine = '" + WorkerClass.StringWithoutApostrophe(Movie.Storyline) + "',"; command += " TrailerMovie = '" + WorkerClass.StringWithoutApostrophe(Movie.MovieTrailer) + "',"; command += " DefaultMovie = " + (Movie.Default ? 1 : 0).ToString() + ","; command += " MPAA = '" + WorkerClass.StringWithoutApostrophe(Movie.MPAA_Rating) + "',"; command += " Prizes = '" + WorkerClass.StringWithoutApostrophe(Movie.Prize) + "'"; command += " WHERE Index = " + LastIndex; OleDbCommand DBCom = new OleDbCommand(command, DBCon); DBCom.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }