I need your help. I have a text file (NL-test.txt attached) which has values delimited with comma. When i load the program using following code some of the values are missing. I am attaching the text file and also the screenshot with missing info marked in RED color. Please help.
DataTable dt = new DataTable();
string strFileName = "C:\\NL_test.txt";
string strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "C:\\" + ";Extended Properties='text;HDR=Yes'";
string CommandText = "select * from " + strFileName;
OleDbConnection conn = new OleDbConnection(strConnString);
OleDbDataAdapter da = new OleDbDataAdapter(CommandText, conn);
dataGridViewX1.DataSource = dt;