>I would like to know how I can access programmatically stored procedures in
a SQL Server. I've been pulling my hair up all weekend, and it seems that I
couldn't get it.
1) Drop a SqlConnection on your form, and hook it up to your SQL
database
2) Drop a SqlCommand on your form, set the Connection property to the
above connection, set the CommandType to
"CommandType.StoredProcedure", set CommandText to the stored procedure
name (e.g. "MyStoredProc"), and define the parameters the procedure
has in the "Parameters" property
3) Open the connection, and then either use a SqlDataAdapter to fill a
DataTable with the output from your stored proc, or execute your
stored proc (if it doesn't return a result set).
Marc
================================================== ==============
Marc Scheuner May The Source Be With You!
Bern, Switzerland m.scheuner(at)inova.ch