|
How can datatable to be insert into the Crystal Report?
Now I am using SqlDataAdapter, this "adpt.Fill(dataSet, "UploadMsg");" is important so it know the name of the dataset:
SqlDataAdapter adpt = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(uploadSql, conn);
adpt.SelectCommand = cmd;
// Add parameters and set values.
cmd.Parameters.Add("@dntAccountCode", SqlDbType.NVarChar, 13).Value = dntAccountCode;
adpt.Fill(dataSet, "UploadMsg");
customerReport.SetDataSource(dataSet);
I created a dynamic datatable, but don't know how to put them into the cystal report dataset.
Could not find any clue about this problem.
|