winForm 简洁报表小测试

第一次使用报表，翻阅大量资料，整理了一部分，并做了简单测试...  虽然没什么技术含量，也算是一个参照吧。。。

 

首先创建一个form界面，添加一个crystalReportViewer控件，进行相关设置后即可

 

 

 

namespace baobiao
{
    public partial class Form2 : Form
    {
        public static int tid = 0;

        public Form2()
        {
            InitializeComponent();
        }

        private void Form2_Load(object sender, EventArgs e)
        {
            tid = Convert.ToInt32(baobiao.Form1.tmpid);
          
            showdata(tid);
        }
        public void showdata(int tid)
        {
             string M_str_sqlcon = "Data Source=***;DataBase=***;User id=***;pwd=***";
            string M_str_sqlstr = "select * from *** where id='" + tid + "'";
            SqlConnection myCon = new SqlConnection(M_str_sqlcon);
            try
            {
                myCon.Open();
                SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, myCon);
                DataSet myds = new DataSet();
                sqlda.Fill(myds);

                string reportpath = Application.StartupPath.Substring(0, Application.StartupPath.Substring(0, Application.StartupPath.LastIndexOf("//")).LastIndexOf("//"));
                reportpath += @"/CrystalReport1.rpt";

                CrystalReport11.Load(reportpath);

                CrystalReport11.SetDataSource(myds.Tables[0].DefaultView);

                this.crystalReportViewer1.ReportSource = CrystalReport11;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
    }
}