Creating reports and dashboards | Stimulsoft community forum

Code: Select all

		public void CSVimport(string csv)
		{
			MessageBox.Show(csv); // test if the csv-string is here
			DataTable dt = new DataTable("CSVdataset");
	
			string[] lines = csv.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
				
			for(int i = 0;i < lines[0].Split(';').Length;i++)
			{
				dt.Columns.Add(lines[0].Split(';')[i]);
			}
				
			foreach (string line in lines)
			{
				string[] cells = line.Split(';');
					
				DataRow dr = dt.NewRow();
				//for (int i = 0; i < cells.Length; i++)
				//{
				//	dr[i] = cells[i];
				//}
					
				dt.Rows.Add(cells);
			}
				
			DataSet ds = new DataSet("CSVdataset");
	
			ds.Tables.Add(dt);
				
			this.DataBand2.DataSourceName = "CSVdataset"; // data is not shown in the report
			
			StringWriter sw = new StringWriter();
			ds.WriteXml(sw);
			string result = sw.ToString();
			MessageBox.Show(result); // just to test it, if the csv.string is in the dataset
				
			//this.Render();
			
			//return ds;
		}

Code: Select all

var csvString = DataSourceName.ColumnName;
DataTable dt = new DataTable("CSVdataset");
string[] lines = csvString.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
for (int i = 0; i < lines[0].Split(';').Length; i++)
{
    dt.Columns.Add(lines[0].Split(';')[i]);
}
foreach (string line in lines)
{
    string[] cells = line.Split(';');
    DataRow dr = dt.NewRow();
    dt.Rows.Add(cells);
}
DataSource1.DataTable = dt;