ReportDocument cryRpt = new ReportDocument();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
string connStr = ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;
SqlConnection con = new SqlConnection(connStr);
con.Open();
SqlDataAdapter da3 = new SqlDataAdapter("select * from FlexiDetails where slno='" + TextBox1.Text + "'", con);
DataSet ds3 = new DataSet();
da3.Fill(ds3, "finalbill");
cryRpt.Load(HttpContext.Current.Server.MapPath("rptFlexiReceipt.rpt"));
cryRpt.SetDataSource(ds3.Tables[0]);
crConnectionInfo.ServerName = "208.91.198.196";
crConnectionInfo.DatabaseName = "sevamx7z_SEVADBES";
crConnectionInfo.UserID = "seva_root";
crConnectionInfo.Password = "seva@321";
CrTables = cryRpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
CrystalReportViewer1.ReportSource = cryRpt;
System.Drawing.Printing.PrintDocument printDoc = new System.Drawing.Printing.PrintDocument();
int i;
int rawKind = 0;
for (i = 0; i < printDoc.PrinterSettings.PaperSizes.Count; i++)
{
if (printDoc.PrinterSettings.PaperSizes[i].PaperName == "10x6")
{
rawKind = (int)GetField(printDoc.PrinterSettings.PaperSizes[i], "kind");
}
}
cryRpt.SetDataSource(ds3);
CrystalReportViewer1.RefreshReport();
NOTICE LINE
cryRpt.SetDataSource(ds3.Tables[0]);