//Crystal View DataSourch public DataTable CristalReportDataSourch(Telerik.Windows.Controls.RadGridView radgridview, DataTable tempDataTable, Variables.OperationTrypes oprationType) { string txtline = string.Empty; NecessaryFunction necessaryElement = new NecessaryFunction(); GridViewExportOptions exportOption = new GridViewExportOptions(); exportOption.Format = ExportFormat.Text; string fileNameWithPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "DATA_EXPORT.txt"); necessaryElement.CreateTextFile(fileNameWithPath); FileStream fileStream = new FileStream(fileNameWithPath, FileMode.OpenOrCreate, FileAccess.Write); radgridview.Export((Stream)fileStream, exportOption); fileStream.Close(); fileStream.Dispose(); StreamReader txtReader = new StreamReader(fileNameWithPath); while ((txtline=txtReader.ReadLine())!=null) { char[] delimiterChars = { ' ', '"', '\t' }; String[] columnData = txtline.Split(delimiterChars,StringSplitOptions.RemoveEmptyEntries); if (oprationType.Equals(Variables.OperationTrypes.Sales)) { tempDataTable.Rows.Add(columnData[0].Trim(), columnData[1].Trim(), columnData[2].Trim(), columnData[3].Trim()); } else if (oprationType.Equals(Variables.OperationTrypes.InvPurDebCre)) { tempDataTable.Rows.Add(columnData[0].Trim(), columnData[3].Trim(), columnData[4].Trim(), columnData[5].Trim(), columnData[6].Trim(), columnData[7].Trim(), columnData[8].Trim(), columnData[9].Trim(), columnData[11].Trim(), columnData[10].Trim()); } } txtReader.Close(); txtReader.Dispose(); necessaryElement.DeleteFile(fileNameWithPath); return tempDataTable; }