Database

<br />
LOAD DATA LOCAL INFILE 'filename.csv'<br />
INTO TABLE myTable<br />
FIELDS TERMINATED BY ','<br />
LINES TERMINATED BY '\n';<br />

// Create the dataset
DatasetReportPositiveEmployees ds = new DatasetReportPositiveEmployees();
string sSQL = "SELECT DISTINCT empID, empFName, empLName, empAcctNum from Employee " +
"LEFT INNER JOIN TestResult ON empID = testEmployeeID " +
"WHERE (testResult IN (SELECT resultID FROM Result WHERE resultTreatAsPositive=1))";

System.Data.OracleClient.OracleConnection localConn = new System.Data.OracleClient.OracleConnection(settings.ConnectionString);
localConn.Open();

System.Data.OracleClient.OracleCommand localCmd = new System.Data.OracleClient.OracleCommand();
localCmd.Connection = localConn;
localCmd.CommandText = sSQL;
localCmd.CommandType = CommandType.Text;

System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter();
adapter.SelectCommand = localCmd;
adapter.Fill(ds, "EMPLOYEE"); // Name must match name in Dataset

// Create Report
CrystalReportPositiveEmployees report = new CrystalReportPositiveEmployees();

Tried with/without this section
CrystalDecisions.Shared.TableLogOnInfo login = new CrystalDecisions.Shared.TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in report.Database.Tables)
{
login = tbl.LogOnInfo;
login.ConnectionInfo.ServerName = "myComputer";
login.ConnectionInfo.UserID = "myUser";
login.ConnectionInfo.Password = "myPass";
tbl.ApplyLogOnInfo(login);
}

// Tell report to use dataset
report.SetDataSource(ds);

// Create new form, report viewer has been declared public
formReportViewer dlg = new formReportViewer();
dlg.crystalReportViewer1.ReportSource = report;

// No errors, until next command executes
dlg.ShowDialog();

string filename = "csvsample.csv";<br />
<br />
	string cs = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Y:/csv/;Extended Properties='text;HDR=Yes;FMT=Delimited'";<br />
<br />
				OleDbConnection  objOleDBConn = new OleDbConnection(cs);<br />
				objOleDBConn.Open();<br />
				sqlSelect =	"select * from ["+ filename+"]"; <br />
OleDbDataAdapter objOleDBDa = new OleDbDataAdapter(sqlSelect,objOleDBConn);