Olá
Já criei o dataset e configurei o reportview, mas esta a dar erro no xxx.Tables(0)
erro: Error 8 Non-invocable member ‘System.Data.DataSet.Tables’ cannot be used like a method.
MySqlConnection conn = default(MySqlConnection);
MySqlCommand cmd = default(MySqlCommand);
MySqlDataAdapter adap = default(MySqlDataAdapter);
conn = new MySqlConnection("Database=" + BANCO + ";Data Source=" + SERVIDOR + ";User Id=" + USUARIO + ";Password=" + SENHA + "; ");
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM fichacli";
adap = new MySqlDataAdapter();
adap.SelectCommand = cmd;
DataSet custDB = new DataSet1();
custDB.Clear();
adap.Fill(custDB, "fichacli");
DataTable aaa = null;
aaa = custDB.Tables(0);
this.ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = "C:\\Users\\Diogo\\Documents\\Visual Studio 2012\\Projects\\mediproject\\mediproject\\Report3.rdlc";
this.ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("fichacli", aaa));
ReportViewer1.DocumentMapCollapsed = true;
//this.ReportViewer1.ReportRefresh();