public void loadMoviesGrid()
{
// create a data services object , load up the movies from db and destroy the object
moviesdataServices ds = new moviesdataServices();
ds.loadMovies(dataGridView1);
ds = null;
}
private void button3_Click(object sender, EventArgs e)
{
SortedList dataList = new SortedList();
dataList.Add("@mID", this.Movie.Text);
moviesdataServices ds = new moviesdataServices();
ds.deleteMovie(dataList);
ds = null;
loadMoviesGrid();
}
private void Button1_Click(object sender, EventArgs e)
{
//create a new list containing the data
SortedList dataList = new SortedList();
dataList.Add("@mID", this.Movie.Text);
dataList.Add("@mMovieName", this.MovieName.Text);
dataList.Add("@mMovieRating", this.MovieRating.Text);
dataList.Add("@mMovieActors", this.MovieAct.Text);
dataList.Add("@mMovieD", this.MovieD.Text);
dataList.Add("@mMovieProductionDate", this.dateTimePicker1.Value);
moviesdataServices ds = new moviesdataServices();
ds.insertMovie(dataList);
ds = null;
loadMoviesGrid();
}