Comments by iceprincess50 (Top 5 by date)

thanx i solved it

thanx but i have another error

The name 'mDBHelper' does not exist in the current co

DataTable mDT_Report = new DataTable();
ReportDocument cryRpt = new ReportDocument();
mDT_Report=mDBHelper.GetTable("select * from emp");
cryRpt.Database.Tables[0].SetDataSource(mDT_Report);
MessageBox.Show("Generating Report", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
crystalReportViewer1.ReportSource = cryRpt;

i tried this solution but i have another error

DataTable mDT_Report = new DataTable();
ReportDocument cryRpt = new ReportDocument();

cryRpt.Load(@"G:\\WindowsApplication2\\WindowsApplication2\\CrystalReport1.rpt");
foreach (CrystalDecisions.CrystalReports.Engine.Table table in cryRpt.Database.Tables)
{
table.LogOnInfo;
LogOnInfo.ConnectionInfo.ServerName = "server";
LogOnInfo.ConnectionInfo.DatabaseName = "f_library";
LogOnInfo.ConnectionInfo.UserID = "sa";
LogOnInfo.ConnectionInfo.Password = "ahmed";
table.ApplyLogOnInfo(LogOnInfo);
}
cryRpt.Database.Tables[0].ApplyLogOnInfo(LogInfo);

mDT_Report = mDBHelper.GetTable("select * from emp");
cryRpt.Database.Tables[0].SetDataSource(mDT_Report);
MessageBox.Show("Generating Report", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
crystalReportViewer1.ReportSource = cryRpt;


}

Error 1 Only assignment, call, increment, decrement, and new object expressions can be used as a statement G:\WindowsApplication2\WindowsApplication2\frm_report.cs 45 17 WindowsApplication2


i already make crystal report and choose data from sql connection

Data Source=server;Initial Catalog=f_library;User ID=sa;Password=ahmed

thannnnnnnnnnnnnnnnnnnnnnnnnnnnnnx