ASP.Net中怎樣獲得預存程序傳出的參數。

來源:互聯網
上載者:User

//-------------------------------------------------------------------------------
//測試獲得預存程序傳出的參數
//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>測試輸出成功!");

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.