try
   {
    this.sqlConnection1.Open();
    using(this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter())
    {
     this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
     DataSet ds = new DataSet();
     this.sqlDataAdapter1.Fill(ds);
     ds.Tables[0].TableName = "titles";
     if(this.dataGrid1.DataSource != null)
     {
      this.dataGrid1.TableStyles.Clear();
     }
     this.dataGrid1.TableStyles.Add(this.dataGridTableStyle1);
     this.dataGrid1.DataSource = ds.Tables[0].DefaultView;
    }
   }
   catch(Exception ex)
   {
    throw ex;
   }
   finally
   {
    this.sqlConnection1.Close();
   }