Retrieve data from MS SQL server and display in grid view

[becky.b]

Hi, I am using .net visual studio c# to do my project and the database that i am using is called: SQL server 2008. I am developing my codes in 3-tier way.

The database.cs is being code out to call the stored procedue and the stored procedure will retrieve n store data.

The attachement is the codes that I have populated.

The error that I got is:
System.Data.SqlClient.SqlException: Procedure GET_ItemRecords has no parameters and arguments were supplied.

Thanks!

[rinat.mergenbaev]

Hi!

So, the message reports you everything!
check params declared in sql procedure and which you pass in procedure call