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 ...