销售分析报表.cs

来自「用C#实现超市的管理」· CS 代码 · 共 35 行

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace Myproject
{
    public partial class 销售分析报表 : Form
    {
        private CrystalReport1 objcrysta;
        public 销售分析报表()
        {
            InitializeComponent();
        }

        private void 销售分析报表_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=sa;database=student");
            string mert = "select *from NewTianjsp";
            SqlDataAdapter objdata = new SqlDataAdapter(mert,con);
            DataSet1 objdaset = new DataSet1();
            objdata.Fill(objdaset, "NewTianjsp");
            objcrysta = new CrystalReport1();
            objcrysta.SetDataSource(objdaset.Tables["NewTianjsp"]);
            crystalReportViewer1.ReportSource = objcrysta;

        }

      
    }
}