6 - Better Data Binding

Private Sub winGrid_Loaded(sender As Object, _

e As System.Windows.RoutedEventArgs) Handles Me.Loaded

'create a connection to database

Dim cs As String = ConfigurationManager.ConnectionStrings("csMovies").ConnectionString

Dim cn As SqlConnection = New SqlConnection(cs)

'create a new dataset

Dim ds As DataSet = New DataSet()

'open the connection (not strictly necessary, as the

'data adapter will do this when you use it anyway)

cn.Open()

'fill data tables

Dim daMovies As SqlDataAdapter = New SqlDataAdapter()

daMovies.SelectCommand = New SqlCommand("SELECT * FROM tblFilm", cn)

daMovies.Fill(ds, "Films")

'now set the data context for the entire window

Me.DataContext = ds

cn.Close()

End Sub

private void Window_Loaded(object sender, RoutedEventArgs e)

{

// create a connection to Top Trumps database

String cs = ConfigurationManager.ConnectionStrings["csMovies"].ConnectionString;

SqlConnection cn = new SqlConnection(cs);

try

{

// create a new dataset

DataSet ds = new DataSet();

// open the connection (not strictly necessary, as the

// data adapter will do this when you use it anyway)

cn.Open();

// fill data tables

SqlDataAdapter daMoviess = new SqlDataAdapter();

daMoviess.SelectCommand =

new SqlCommand("SELECT * FROM tblMovies WHERE PackId=1", cn);

daMoviess.Fill(ds, "Movies");

// now set the data context for the entire window

this.DataContext = ds;

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

// close the connection whether went wrong or not

cn.Close();

}

}

private void DataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)

{

// find out the row clicked on

DataRowView dr = dg.SelectedItem as DataRowView;

// get the field values for this row

string FilmName = (int)dr["FilmName"];

int FilmOscarWins = (int)dr["FilmOscarWins"];

// display choice made

MessageBox.Show(FilmName + ' ' + FilmOscarWins.ToString());

}