How To Bind Crystal Report

See more:

C#3.5

Hi,

Here my problem i crate dynamic data table for binding, but i dont know how to bind in Crytal report

MyCode :

DataTable dt = new DataTable();
string Qry = "select ShiftGroupCodeC from ShiftGroupInfo";
dt = Dt_Args(Qry);
DataTable dt4 = new DataTable();
DataRow Drow = null;
dt4.Columns.Add(new DataColumn("Day", typeof(string)));
dt4.Columns.Add(new DataColumn("Night", typeof(string)));
Drow = dt4.NewRow();
for (int i = 0; i < dt.Rows.Count; i++)
{
   string s = dt.Rows[i]["ShiftGroupCodeC"].ToString();
   DataTable dt3 = new DataTable();
   string Qry1 = "select distinct st.EmpCodeC,st.EmpNameC,st.DeptCodeC,st.ShiftGroupC from ShiftTable as st inner join ClientDeployment as cd on st.EmpCodeC=cd.EmpCodeC where st.dated between '01/Oct/2014' and '07/Oct/2014' and cd.LocationC='J1' and st.ShiftGroupC='" + s + "'";
   dt3 = Dt_Args(Qry1);
   for (int k = 0; k < dt3.Rows.Count; k++)
   {
      if (i < 1)
      {
         Drow["Day"] = dt3.Rows[k]["EmpNameC"].ToString();
         dt4.Rows.Add(Drow);
         Drow = dt4.NewRow();
      }
      else
      {
         Drow["Night"] = dt3.Rows[k]["EmpNameC"].ToString();
         dt4.Rows.Add(Drow);
         Drow = dt4.NewRow();
      }
   }
}

//SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
//Deployment ds = new Deployment();
//dscmd.Fill(ds, "Product");
objRpt.SetDataSource(dt4);
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();