How to convert one dataset to other datasethttp://forums.asp.net/t/929450.aspx/1?How+to+convert+one+dataset+to+other+datasetTue, 18 Oct 2005 09:24:06 -04009294501086186http://forums.asp.net/p/929450/1086186.aspx/1?How+to+convert+one+dataset+to+other+datasetHow to convert one dataset to other dataset <p><br> dim ds as new MyDataset//This dataset i created while Using ADO.NET Connection<br> dim dset as new DataSet//This is Standard dataset<br> ds=SQLHelper.ExecuteDataSet(CommandType.StoredProcedure,&quot;spr_Procedure1&quot;)</p> <p><br> //There is no error in stored procedure<br> //Then i tried giving like this</p> <p><br> dset=SQLHelper.ExecuteDataSet(CommandType.StoredProcedure,&quot;spr_Procedure1&quot;)<br> ds=CType(dset,MyDataset)</p> <p>//It shows the following error<br> System.InvalidCastException: Specified cast is not valid.</p> <p>Or is there any way i can get the dataset using ADO.NET connection &amp; stored<br> Procedure,If so plz send me the procedure,very urgent<br> Thanx in advance</p> 2005-10-18T09:24:06-04:00