winfrom 水晶报表制作

 string sqlstr = "select * from S_Menu";
            DataSet data = SQL_helper.Sql_helper.Query(sqlstr);
            try
            {            //使用报表加载数据
                ReportDocument myreport = new ReportDocument();
                string reportPath = "report.rpt";
                myreport.Load(reportPath);
                myreport.SetDataSource(data);
                crystalReportViewer1.ReportSource = myreport;
            }
            catch(Exception ex) {
                MessageBox.Show(ex.Message);
            }

        /// 
  
        /// 执行查询语句，返回dataset  
        ///   
        ///   
        ///   
        ///  
        public static DataSet Query(string sqlstring)
        {
            using (SqlConnection connection = new SqlConnection(str))
            {
                DataSet ds = new DataSet();
                try
                {
                    connection.Open();
                    SqlDataAdapter command = new SqlDataAdapter(sqlstring, connection);
                    command.Fill(ds, "S_Menu");
                }
                catch (System.Data.SqlClient.SqlException ex)
                {
                    throw new Exception(ex.Message);
                }
                return ds;
            }

        }