Gym Exercise Tracker in C# and .NET - Printing the DataGridView

/// <summary>

/// Event Handler called when Cell is finished editing
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridExercise_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
UpdateCurrentRow(e);
}

private void UpdateCurrentRow(DataGridViewCellEventArgs e)
{
int index = e.RowIndex;
DataRow dr = scheduleDataSet.Tables[0].Rows[e.RowIndex];
string val = dr[gridExercise.Columns[e.ColumnIndex].DataPropertyName].ToString();
OleDbCommand updateCommand = new OleDbCommand();

// construct update command and update from the data set
updateCommand.CommandText = "UPDATE `Schedule` SET `Completed` = {0}, `Reps` = {1},
`Weight` = {2}, `Sets` = {3} WHERE `ID` = {4}";

updateCommand.CommandText = String.Format(updateCommand.CommandText, dr["Completed"],
dr["Reps"], dr["Weight"],
dr["Sets"], dr["ID"]);

updateCommand.CommandType = System.Data.CommandType.Text;
updateCommand.Connection = scheduleTableAdapter.Connection;
updateCommand.Connection.ConnectionString = string.Format(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\Schedule.mdb",
Path.GetDirectoryName(Application.ExecutablePath));

updateCommand.Connection.Open();

// execute the update on the database
updateCommand.ExecuteNonQuery();
updateCommand.Connection.Close();
}

private void DrawGridBody(Graphics g, ref int columnPosition, ref int rowPosition)
{
// loop through each row and draw the data to the graphics
// surface.

foreach (DataRow dr in scheduleDataSet.Tables[0].Rows)
{
columnPosition = 0;

// draw a line to separate the rows

g.DrawLine(Pens.Black, new Point(0, rowPosition), new Point(this.Width, rowPosition));

// loop through each column in the row, and
// draw the individual data item
foreach (DataGridViewColumn dc in gridExercise.Columns)
{
// if its a picture, draw a bitmap
if (dc.DataPropertyName == "Picture")
{
if (dr[dc.DataPropertyName].ToString().Length != 0)
{
if (CustomImageCell.Images.ContainsKey(dr[dc.DataPropertyName].ToString()))
{
g.DrawImage(CustomImageCell.Images[dr[dc.DataPropertyName].ToString()],
new Point(columnPosition, rowPosition));
}
}
}
else if (dc.ValueType == typeof(bool))
{
// draw a check box in the column

g.DrawRectangle(Pens.Black, new Rectangle(columnPosition, rowPosition + 20, 10, 10));
}
else
{
// just draw string in the column
string text = dr[dc.DataPropertyName].ToString();

if (dc.DefaultCellStyle.Font != null)
g.DrawString(text, dc.DefaultCellStyle.Font, Brushes.Black,
(float)columnPosition, (float)rowPosition + 20f);
else
g.DrawString(text, this.Font, Brushes.Black, (float)columnPosition, (float)rowPosition + 20f);
}

// go to the next column position
columnPosition += dc.Width + 5;

}

// go to the next row position
rowPosition = rowPosition + 65;
}

}