TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Venkat Mungari
NA
854
26.1k
Import CSV file to my Asp.net Website
Oct 23 2012 4:07 AM
i have a problem with .csv file importing to my website
public DataTable ReadDataFromCSVFormat()
{
ReadColumnsfromCSVfile(file,isRowOneHeader);
CreateDataSet();
return CSVData;//
error comes in this place
}
public DataTable ReadColumnsfromCSVfile(string file, bool isRowOneHeader)
{
DataTable csvDataTable = new DataTable();
//no try/catch - add these in yourselfs or let exception happen
//String[] csvData = File.ReadAllLines(HttpContext.Current.Server.MapPath(file));
// String[] csvData = Server.MapPath(this.UploadFolderPath) + FileUploadctrl.FileName;
String[] csvData = File.ReadAllLines(HttpContext.Current.Server.MapPath(this.UploadFolderPath) + FileUploadctrl.FileName);
//if no data in file 'manually' throw an exception
if (csvData.Length == 0)
{
throw new Exception("CSV File Appears to be Empty");
}
String[] headings = csvData[0].Split(',');
int index = 0; //will be zero or one depending on isRowOneHeader
if (isRowOneHeader) //if first record lists headers
{
index = 1; //so we won't take headings as data
//for each heading
for (int i = 0; i < headings.Length; i++)
{
//replace spaces with underscores for column names
headings[i] = headings[i].Replace(" ", "_");
//add a column for each heading
csvDataTable.Columns.Add(headings[i], typeof (string));
}
}
else //if no headers just go for col1, col2 etc.
{
for (int i = 0; i < headings.Length; i++)
{
//create arbitary column names
csvDataTable.Columns.Add("col" + (i + 1).ToString(), typeof (string));
}
}
//populate the DataTable
for (int i = index; i < csvData.Length; i++)
{
//create new rows
DataRow row = csvDataTable.NewRow();
for (int j = 0; j < headings.Length; j++)
{
//fill them
row[j] = csvData[i].Split(',')[j];
}
//add rows to over DataTable
csvDataTable.Rows.Add(row);
}
//return the CSV DataTable
return csvDataTable;
}
please check it......
Reply
Answers (
1
)
Importing Contacts from Yahoo to Asp Website
the graphics filter was unable to convert this file.microsoft word