>I would like to know how I can access programmaticall y 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.St oredProcedure", 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)i nova.ch