I have a button in my window when I press load the datagridview but do not load the data to the report viewer
BUTTON CODE
OleDbConnection connection = MSAConnection.getConnection();
OleDbDataAdapter adapter = new OleDbDataAdapter();
DataSetS DataSet = new DataSetS();
private void Generar_Click(object sender, EventArgs e)
{
string query = @"SELECT * FROM Persona";
OleDbCommand command = new OleDbCommand(query, connection);
// command.Parameters.AddWithValue("@desde", dateTimePickerDesde.Value.Date);
adapter.SelectCommand = command;
DataSet.Clear();
adapter.Fill(DataSet, "DTPersona");
dataGridView2.DataSource = DataSet;
dataGridView2.DataMember = "DTPersona";
dataGridView2.Refresh();
ReportViewer.Clear();
ReportViewer.RefreshReport();
}
What am I doing wrong?
THIS IS THE DataSet in the report designer
THIS IS THE DataTable