passing the parameter in store procedur.

The problem is that you are not passing the sql parameter array to your SqlDataAccess class, so it is not being passed to stored procedure, your are creating the SqlParameter array :

But you have'nt used it, you need to set the parameters on SqlCommand object in the ExecuteDataSet method implementation, so you may need to add another input parameter for the method and then use it like: