/// <summary> /// Illustrates using a GrapeCity SqlServer object as a data source. /// /// </summary> private void btnSqlServer_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; //Verify that a SQL Server has been selected if (cbSqlServerList.SelectedItem == null) { MessageBox.Show("Please select a SQL Server first."); Cursor = Cursors.Arrow; return; } //SqlServer Data Source object to use Data.SqlDBDataSource sql = new Data.SqlDBDataSource(); //Assign the database connection string based on the SQL Server selected sql.ConnectionString = "Data Source=" + cbSqlServerList.SelectedItem + ";Initial Catalog=Northwind;Integrated Security=SSPI"; //Run the SQL command. sql.SQL = "SELECT * FROM invoices ORDER BY CustomerID, OrderID"; //Create the report and assign the data source. Invoice rpt = new Invoice(); rpt.DataSource = sql; //Run and view the report try { arvMain.LoadDocument(rpt); } catch (System.Data.SqlClient.SqlException ex) { MessageBox.Show(ex.Message); } Cursor = Cursors.Arrow; }
/// <summary> /// Illustrates using a GrapeCity SqlServer object as a data source. /// /// </summary> private void btnSqlServer_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; //Verify that a SQL Server has been selected // if (cbSqlServerList.SelectedItem == null) { MessageBox.Show(Properties.Resources.SelectSQLServer); Cursor = Cursors.Arrow; return; } //SqlServer Data Source object to use // Data.SqlDBDataSource sql = new Data.SqlDBDataSource(); //Assign the database connection string based on the SQL Server selected // sql.ConnectionString = "Data Source=" + cbSqlServerList.SelectedItem + ";Initial Catalog=Northwind;Integrated Security=SSPI"; //Run the SQL command. // sql.SQL = "SELECT * FROM invoices ORDER BY CustomerID, OrderID"; //Create the report and assign the data source. // var rpt = new ActiveReports.SectionReport(); rpt.LoadLayout(XmlReader.Create(System.IO.Path.Combine("..\\..\\", Properties.Resources.ReportName))); rpt.DataSource = sql; //Run and view the report // try { arvMain.LoadDocument(rpt); } catch (System.Data.SqlClient.SqlException ex) { MessageBox.Show(ex.Message); } Cursor = Cursors.Arrow; }