calling stored procedure in ADO.NET 2.0

[David Sagenaut]

How can I calling a stored procedure (say "sp_example") in ADO.NET 2.0? I
used to do this in ADO.NET 1.1, but in 2.0 (beta2 vs2005), after the
following
...
sqlConnection con = new sqlConnection(strCon)
sqlCommand cmd = sqlCommand("sp_example", con);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.???

under the Parameters property, I only find the AddRange() and AddWithValue()
method, but not the Add() method which is in ADO.NET 1.1. Does anyone have
an idea how to call a stored procedure in the new 2.0 framwork? Thanks in
advance.

David

 

[Karl Seguin]

You might want to check out:
http://weblogs.asp.net/jackieg/archive/2005/03/22/395517.aspx?Pending=true

it explains why the change and how to get around it. I believe it's now a 2
line operation. Without knowing exactly which overload of Add you wanted to
use, I can't say exactly what the equivillant is..

Karl