Wednesday, March 28, 2012

Problem in Dataset

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 advancePost your question at ADO.NET or VB.NET section to get much response

No comments:

Post a Comment