Using OleDB with memorystream

Question

Hi everyone I know how to use OleDB to open up a CSV file and treat it like a database table but I have a method that is passed a memorystream which represents the byte array of a CSV file and I need to use OleDB to read from that. How can I open and connect to that memorystream like I could with a CSV file on disk? Thanks.

Sachin Kalia · Answer

Hi Jaganathan Thanks for your great helpon this. I used the given below code to read csv via stream. It might be helpful for someone needed. // Get a reference to PostedFile object HttpPostedFile myFile = FileUpload1.PostedFile; // Get size of uploaded file int nFileLen = myFile.ContentLength; // make sure the size of the file is > 0 if (nFileLen > 0) { // Allocate a buffer for reading of the file byte[] myData = new byte[nFileLen]; // Read uploaded file from the Stream myFile.InputStream.Read(myData 0 nFileLen); MemoryStream st = new MemoryStream(myData); List lstValues = new List (); DataTable dtTest = new DataTable(); StreamReader sr = new StreamReader(st); //DataColumn[] cols = new DataColumn[sr.ReadLine().Split('').Length]; //dtTest.Columns.AddRange(cols); string[] splits1 = sr.ReadLine().Split(''); for (int i = 0; i { dtTest.Columns.Add(new DataColumn(splits1[i] Type.GetType(System.String))); } while (!sr.EndOfStream) { //dt_New.Rows.Add(sr.ReadLine().Split('')); string[] splits = sr.ReadLine().Split(''); for (int i = 0; i { //dtTest.Columns.Add(new DataColumn(splits[i] Type.GetType(System.String))); lstValues.Add(splits[i]); } dtTest.Rows.Add(lstValues.ToArray()); lstValues.Clear(); }

Jaganathan Bantheswaran · Answer

Hi You can try to write the CVS file memory stream to cvs file again and connect to OleDB.

Sachin Kalia · Answer

Thanks Jaganathan for initiation. is there any way to convert this stream to datatable.so that i could be able to bind it with any gridview kind of object. Regards Sachin Kalia

Jaganathan Bantheswaran · Answer

Hi There is no Provider to connect with the MemoryStream.