Posted on: 12/15/2014 4:44:23 AM | Views : 495

my sample code.
1.But this s not separating the columns properly.i have given the Hexadecimal delimiters in the below passage:
protected void Button2_Click(object sender, EventArgs e) { DataSet ds = Convert(Server.MapPath("temp\\01_issues.csv"), "MyNewTable", "\0x09"); } public static DataSet Convert(string File,string TableName, string delimiter) { //The DataSet to Return DataSet result = new DataSet(); //Open the file in a stream reader. StreamReader s = new StreamReader(File); //Split the first line into the columns string[] columns = s.ReadLine().Split(delimiter.ToCharArray()); //Add the new DataTable to the RecordSet result.Tables.Add(TableName); //Cycle the colums, adding those that don't exist yet //and sequencing the one that do. foreac ...

Go to the complete details ...