How to pass parameters to stored procedure, which is used by sqlDataSource

[nitinp]

I want to bind GridView with sqlDataSource like following

sqlDataSource1.SelectCommand = "GET_TRACKING_INFO";
sqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
 
sqlDataSource1.SelectParameters.Add("Group_code",TypeCode.String, "1");
sqlDataSource1.SelectParameters[0].Direction =ParameterDirection.Input; 
 
GridView1.DataSource = sqlDataSource1;
GridView1.DataBind();

But raises error "Procedure or function GET_TRACKING_INFO has too many arguments specified"

When I execute this stored procedure in SQL query analyzer it works fine, there is no other parameter is used.

Please tell me what is wrong with it. Very urgent.

[josephhamilton1]

GET_TRACKING_INFO takes one argument I'm guessing.

You're probably not clearing you input parameters on the 2nd time through.
Put this at the beginning of the sub to be sure:

sqlDataSource1.SelectParameters.Clear()

Otherwise, be sure that you're SP really does take a parameter.

[hajoabdul]

@nitinp
''''''''''''''''''''''''''''''

The reason for that error coming from your stored procedure is due to the fact that not all the parameters are being declared, either the ones in the stored procedures are less than the ones on the interface vice versa, so go through the both phases and make sure that there is equality in parameters

[Frinavale]

Check out these articles for an example:

• how to use a database in your program
• SQL Stored Procedures