getCon(); //连接数据库的方法 int id = 35;
SqlParameter[] par = new SqlParameter[2];
par[0] = new SqlParameter("@id", SqlDbType.Int);
par[0].Value = id;
par[1] = new SqlParameter("@count", SqlDbType.Int);
par[1].Direction = ParameterDirection.Output; //设置为输出参数
SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure,
"getChildCount", par);
this.Label1.Text = par[1].Value.ToString(); //接收输出的参数
存储过程代码如下:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)