SQL Procedure Running from VB.Net

[gautam.kamal]

I made a SQL procedure which fetch data from 3-4 tables & insert into another table after some calculations. When I Run the Procedure it works fine & insert all records to table. But when i'm running this procedure from Front end i.e. from VB.Net it doesn't work well . it insert only first 9-10 records.here 'li' is variable against which that procedure has to run.
I use the following code

cmd.commandtext="exec PR @li='26',@d1='date'
cmd_pur.CommandType = CommandType.StoredProcedure
cmd.connection=Conection name
cmd.executenonquery()


Now please somebody let me know what can be possible causeof my error