Click to See Complete Forum and Search --> : Problem in Dataset


aswini
October 18th, 2005, 05:35 AM
Hi,

dim ds as new MyDataset//This dataset i created while Using ADO.NET Connection
dim dset as new DataSet//This is Standard dataset
ds=SQLHelper.ExecuteDataSet(CommandType.StoredProcedure,"spr_Procedure1")


//There is no error in stored procedure
//Then i tried giving like this


dset=SQLHelper.ExecuteDataSet(CommandType.StoredProcedure,"spr_Procedure1")
ds=CType(dset,MyDataset)

//It shows the following error
System.InvalidCastException: Specified cast is not valid.

Or is there any way i can get the dataset using ADO.NET connection & stored
Procedure,If so plz send me the procedure

Thanx in advance

Madhi
October 22nd, 2005, 07:50 AM
Post your question at ADO.NET or VB.NET section to get much response