Database

private void button1_Click(object sender, System.EventArgs e)
{
	try
	{
		// Code to get data from database
		myCon.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\as400.mdb";						
		myCon.Open();

		string sqlQuery = "Select [CLNT#], CNAME, [CSS#], CADMHH, CADMYY, CADMMM, CADMDD, CSEX from SAMFILE_CLIENTP";
		myAdp = new OleDbDataAdapter(sqlQuery, myCon);
						
		// Create a Dataset and using DataAdapter to fill it
		PIN_DataSet PDS = new PIN_DataSet();
		PDS.Clear();
		myAdp.Fill(PDS,"SAMFILE_CLIENTP");

		//START - Added new DataSet for concatenating date fields
		DataSet newPDS = new DataSet();
		newPDS = PDS.Copy();
								
		DataColumn dCol = new DataColumn(newPDS.Tables[0].Columns.Add("DT", typeof(String)).ToString());
		for(Int32 i = 0; i < newPDS.Tables[0].Rows.Count; i++)
		{
			DataRow row = newPDS.Tables[0].Rows[i];
		 	row["DT"] = row["CADMMM"].ToString() + "/" + row["CADMDD"].ToString() + "/" + row["CADMHH"].ToString() + row["CADMYY"].ToString();
		}
		//END - Added new DataSet for concatenating date fields	
		

		// Create a CrystalReport1 object
		PIN_Crystal_Report myReport = new PIN_Crystal_Report();


		// Set the DataSource of the report
		myReport.SetDataSource(PDS);


		// Set the Report Source to ReportView 
		crystalReportViewer1.ReportSource = myReport;
	}
	catch(Exception obj)
	{
		MessageBox.Show(obj.Message, "X'eption");
	}
}