public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            cust_name_report rpt = new cust_name_report();

            rpt.Site = this.Site;
            return(rpt);
        }
示例#2
0
        private void btnsubmit_Click(object sender, EventArgs e)
        {
            SqlConnection sqlcon  = new SqlConnection();
            SqlCommand    sqlcomm = new SqlCommand();

            try
            {
                cust_name_report name_report = new cust_name_report();

                sqlcon = new SqlConnection(ConfigurationSettings.AppSettings["photostudioConnectionString"].ToString());
                sqlcon.Open();
                sqlcomm             = new SqlCommand();
                sqlcomm.Connection  = sqlcon;
                sqlcomm.CommandType = CommandType.StoredProcedure;
                sqlcomm.CommandText = "cust_name_report_select";
                sqlcomm.Parameters.Add(new SqlParameter("@cust_name", SqlDbType.VarChar, 50));
                sqlcomm.Parameters["@cust_name"].Value = txtcust_name_rpt.Text;
                SqlDataAdapter dta = new SqlDataAdapter(sqlcomm);
                DataSet        ds1 = new DataSet();
                dta.Fill(ds1, "table");
                int row_count = ds1.Tables[0].Rows.Count;

                if (row_count == 0)
                {
                    cust_name_reportviewer.Refresh();
                    MessageBox.Show("No Customer of such name!");
                    cust_name_reportviewer.ReportSource = null;
                    return;
                }
                name_report.SetDataSource(ds1.Tables[0]);
                cust_name_reportviewer.ReportSource = name_report;
                sqlcon.Close();
                sqlcon.Dispose();
                txtcust_name_rpt.Text = "";
            }
            catch
            {
            }
            finally
            {
                sqlcon.Close();
                sqlcon.Dispose();
            }
        }