I have a CSV file with two columns in it.
Below is some data from the file:
This CSV is read into a table like this:
OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= C:\;Extended Properties=""Text;HDR=No;FMT=Delimited""");
OleDbCommand cmd = new OleDbCommand(sqlSelect, cn);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
dt = new DataTable("TestTable");
dt.Locale = CultureInfo.InvariantCulture;
This data table is then bound to a datagirdview like this:
BindingSource bsdatabind = new BindingSource();
bsdatabind.DataSource = this.dtperson;
this.dataCenterGridView.DataSource = bsdatabind;
When the data is displayed in the DataGridView it shows only '0' for '0000', '2' for '0002' and completely ignores '000A'.
what do I need to make it display the data as it is in the CSV.
Thanks and Regards.