Using OleDB with memorystream

Sachin Kalia

15y15.4k.NET

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Kalia15y ago
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 <= splits1.Length - 1; 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 <= splits.Length - 1; i++)
{
//dtTest.Columns.Add(new DataColumn(splits[i], Type.GetType("System.String")));
lstValues.Add(splits[i]);

}
dtTest.Rows.Add(lstValues.ToArray());

lstValues.Clear();

}
0
Jaganathan Bantheswaran15y ago
Hi,

You can try to write the CVS file memory stream to cvs file again and connect to OleDB.
0
Sachin Kalia15y ago
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
0
Jaganathan Bantheswaran15y ago
Hi,

There is no Provider to connect with the MemoryStream.
0