Sunday, October 28, 2007

Create Comma separate (csv) file type export

//fist you have to import
using RKLib.ExportData;

//Inside the button
try
{
dsSet dsFinishedGoods = new dsSet();
dsSetTableAdapters.uspRPInventoryStatusReport9_8TableAdapter AA = new dsSetTableAdapters.uspRPInventoryStatusReport9_8TableAdapter();
dsSetTableAdapters.uspRPCompanyInfoTableAdapter BB = new dsSetTableAdapters.uspRPCompanyInfoTableAdapter();
AA.Fill(dsFinishedGoods._uspRPInventoryStatusReport9_8);
// Export the details of specified columns to Excel
if (dsFinishedGoods._uspRPInventoryStatusReport9_8.Rows.Count > 0)
{
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");
//objExport.ExportDetails(dataList, iColumns, sHeaders, Export.ExportFormat.Excel, saveName);
objExport.ExportDetails(dsFinishedGoods._uspRPInventoryStatusReport9_8, Export.ExportFormat.CSV, "FinishedGoods_Report.csv");
}
}
catch (Exception ex)
{
}

No comments: