Implicit conversion to System.IO.MemoryStream

[cathiec]

I am using a memory stream object and i want to use the create stream method to display a dataset in the browser window. I get the error:

"Cannot implicitly convert type System.IO.Stream to System.IO.MemoryStream"

on the line:

s = SF.CreateStream(GetData());

s is the memory stream object

SF is an object of the eXport.NET class (an add on that we use to export excel documents to browser - it supports the create stream method)

GetData() is the method that returns the dataset

private DataSet GetData()
{
SqlDataAdapter da;
DataSet ds;
ds = new DataSet();
da = new SqlDataAdapter("stpDEBgetInsuranceMailMerge", strConnection);
da.SelectCommand.CommandType = CommandType.StoredProcedure;

da.Fill(ds);
return(ds);
}

i would greatly appreciate any suggestions,

 

[pelikan]

you have to cast the Stream to a MemoryStream
does this work:

s = (MemoryStream) SF.CreateStream(GetData()); ?