Regarding SQLException

Question

Hi all,

       I have a procedure in database which takes 11 inputs and returns a record.through my asp.net code i am passing the 11 parameters say like

cmd.paramets.add(new sqlParameter ("@jobId",sqldatatype.int));

cmd.parametes.addwithvalue("@jobId",jobId);simarly for 10 more parameters.

connection.open();

dataadapterObject=new sqldataadapter(cmd);

dataadapterobject.fill(dataset);//but here it is catching an exception and saying"Stored Procedure has too many arguments specified"

                                                        //SQLException is getting caught.

i am passing the same parameters as speified in stored proc.Can u please help me with the problem.i have checked the connectionString in web.config.everything is fine.

Regards,

Sivapratap.