C#

TER PROCEDURE [dbo].[uspGetPivotedData]
AS
drop table dbo.MemberHistory;
DECLARE @cols AS NVARCHAR(MAX), @query  AS NVARCHAR(MAX),@colsFormated AS NVARCHAR(MAX)
SET @cols = STUFF((SELECT DISTINCT ',' + QUOTENAME(YEAR(t.EventYear))
            FROM Transactions t
            FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'),1,1,'')
 
set @query = ';WITH CTE AS(SELECT
                     t.TransactionID, 
					 m.memberName,
				     m.date_registered, 
					 envelopeNumber,
					 registrationFee,
					 t.Balance,
                     YEAR(eventyear) eventyear,
					 t.Amount
                     from dbo.Transactions AS t INNER JOIN dbo.Members AS m ON t .MemberID = m.MemberID INNER JOIN
                     dbo.PaymentTypes AS p ON t .TypeID = p.PaymentTypeID)
            SELECT * INTO #TABLE FROM CTE
            SELECT
            TransactionID,
				memberName,
				date_registered, 
				envelopeNumber,
				registrationFee,
				Balance, ' + @cols + ' INTO dbo.MemberHistory from #TABLE          
            pivot
            (
                MAX(Amount)
                for eventyear in (' + @cols + ')
            ) p ORDER BY TransactionID'
EXECUTE sp_executesql @query

private void Form2_Load(object sender, System.EventArgs e)
  {
      // Bind the DataGridView to the BindingSource
      // and load the data from the database.
      dataGridView2.DataSource = bindingSource1;
      GetData("select * from MemberHistory");
  }

  private void reloadButton_Click(object sender, System.EventArgs e)
  {
      // Reload the data from the database.
      GetData(dataAdapter.SelectCommand.CommandText);
  }

  private void submitButton_Click(object sender, System.EventArgs e)
  {
      // Update the database with the user's changes.
      dataAdapter.Update((DataTable)bindingSource1.DataSource);
  }

  private void GetData(string selectCommand)
  {
      try
      {
          // Specify a connection string. Replace the given value with a
          // valid connection string for a Northwind SQL Server sample
          // database accessible to your system.
          String connectionString = ConfigurationManager.ConnectionStrings["Members"].ConnectionString;

          // Create a new data adapter based on the specified query.
          dataAdapter = new SqlDataAdapter(selectCommand, connectionString);

          // Create a command builder to generate SQL update, insert, and
          // delete commands based on selectCommand. These are used to
          // update the database.
          SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);

          // Populate a new data table and bind it to the BindingSource.
          DataTable table = new DataTable();
          table.Locale = System.Globalization.CultureInfo.InvariantCulture;
          dataAdapter.Fill(table);
          bindingSource1.DataSource = table;

          // Resize the DataGridView columns to fit the newly loaded content.
          dataGridView2.AutoResizeColumns(
              DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
      }
      catch (SqlException)
      {
          MessageBox.Show("There is an issue with connection string.");
      }
  }