Import CSV to radGrid

[Suriya]

Dear Sir,
               Now i am need to import a csv file's data, into the radgrid... please help for this query.,

then another one is, i wanna to import the field name in the radgrid's column one by one.,

reply both the queries...

Regards

S Suriya Narayanan

[Jim]

That is not possible, you have to do something like:

        string strConnectionString = string.Empty;
        strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFilePath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";";
        OleDbConnection cnCSV = new OleDbConnection(strConnectionString);
        cnCSV.Open();
        OleDbCommand cmdSelect = new OleDbCommand(@"SELECT [Number], [Transaction Number], [Client], [Amount], [Note] FROM [Sheet1$] WHERE [Number] IS NOT NULL", cnCSV);
        OleDbDataAdapter daCSV = new OleDbDataAdapter();
        daCSV.SelectCommand = cmdSelect;
        DataTable dtCSV = new DataTable();
        daCSV.Fill(dtCSV);
        cnCSV.Close();
        daCSV = null;
        return dtCSV;

and then bind the datatable to the grid. I am pretty sure there are other posts about this.