private void Button2_Click(object sender, System.EventArgs e)
{
string strProvider = "Server=(local);UID=sa;PWD=;DataBase=pubs";
CrystalReport1 myReport = new CrystalReport1();
Dataset1 ds =new Dataset1();
SqlConnection MyConn = new SqlConnection(strProvider);
MyConn.Open();
string strSel = "Select * from Stores";
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"stores");
myReport.SetDataSource(ds);
CrystalDecisions.CrystalReports.Engine.ReportDocument ReportDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
ReportDoc.Load("E:\\Inetpub\\wwwroot\\report\\CrystalReport1.rpt");
ReportDoc.PrintOptions.PrinterName = "HP LaserJet 5000 Series PCL";
//ReportDoc.PrintToPrinter(1, true, 0, 0);
ReportDoc.PrintToPrinter(1,true,0,1);
}
