//-------------------------------------------------------------------------------
//測試獲得存儲過程傳出的參數
//OLEDB方式，測試通過
//-------------------------------------------------------------------------------
???OleDbCommand myCommand=new OleDbCommand();
???myCommand.Connection=cn;
???if(cn.State== ConnectionState.Closed){
????cn.Open();
???}
???myCommand.CommandText="ShowCmdTest";
???myCommand.CommandType=System.Data.CommandType.StoredProcedure;
???myCommand.CommandTimeout = 20;

???OleDbParameter inPara=new OleDbParameter("@inA",OleDbType.VarChar,80);
???inPara.Value="5";
???inPara.Direction=ParameterDirection.Input;
???myCommand.Parameters.Add(inPara);
???OleDbParameter outPara=new OleDbParameter("@outB",OleDbType.VarChar,80);
???outPara.Direction=ParameterDirection.Output;
???myCommand.Parameters.Add(outPara);
???myCommand.ExecuteNonQuery();
???Response.Write(outPara.Value);
???OleDbDataReader myReader = myCommand.ExecuteReader();
???DataTable dt = new DataTable();
???dt.Columns.Add("SubjectName");
???dt.Columns.Add("CreateDate");
???while(myReader.Read())
???{
????DataRow workRow = dt.NewRow();
????workRow["SubjectName"] = myReader.GetValue(1);
????workRow["CreateDate"] = myReader.GetValue(2);
????dt.Rows.Add(workRow);
????//Response.Write(myReader.GetValue(0).ToString()+"<br>");
???}
???myReader.Close();
???//BindGrid();
???MyDataGrid.DataSource = dt.DefaultView;// myReader;
???MyDataGrid.DataBind();

//-------------------------------------------------------------------------------
//測試獲得存儲過程傳出的參數
//SqlClient方式，測試通過
//-------------------------------------------------------------------------------
???//連接數據庫
???SqlConnection sqlconn=new SqlConnection();
???sqlconn.ConnectionString="server=192.168.3.80;uid=sa;Password=rain;database=MyStudy";
???//server=192.168.3.80;uid=sa;Password=rain;database=MyStudy";
???sqlconn.Open();
???SqlCommand com=new SqlCommand();
???com.Connection=sqlconn;

???com.CommandText="ShowCmdTest";
???com.CommandType=CommandType.StoredProcedure;
???SqlParameter[] p_htno=new SqlParameter[2];
???p_htno[0] = new SqlParameter("@inA",SqlDbType.VarChar,80);
???p_htno[1] = new SqlParameter("@outB",SqlDbType.VarChar,80);
???p_htno[0].Value ="測試輸入";??
???p_htno[1].Direction=ParameterDirection.Output;
???//p_htno[1].Value = this.drop_character.Items[this.drop_character.SelectedIndex].Value;

???for ( int i =0 ;i< p_htno.Length;i++)
???{
????com.Parameters.Add(p_htno[i]);
???}
???com.ExecuteNonQuery();
???Response.Write(p_htno[1].Value.ToString()+"<br>測試輸出成功！");

轉載于:https://www.cnblogs.com/JimZhang/archive/2005/09/27/245288.html

總結

以上是生活随笔為你收集整理的ASP.Net中怎样获得存储过程传出的参数。的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。