1. 建立預存程序
CREATE PROCEDURE MyProc_Select_AC_ACPT_M
@ACPT_VOU_NO nvarchar(50)
AS
SET NOCOUNT ON;
SELECT ACPT_VOU_NO,ACPT_VOU_TYPE,CASH_AMT
FROM AC_ACPT_M
WHERE ACPT_VOU_NO = @ACPT_VOU_NO
GO
2.測試是否成功
execute MyProc_Select_AC_ACPT_M @ACPT_VOU_NO = 'PTR00020099'
3.執行程式呼叫預存程序
//呼叫預存程式帶查詢參數,無傳回值
DataTable dt.Clear();
using (SqlConnection dataConnection = new SqlConnection (conn.DB63_PTERP))
{
//MyProc_Select_AC_ACPT_M ==>預存程序名稱
SqlCommand cmd = new SqlCommand("MyProc_Select_AC_ACPT_M", dataConnection);
cmd.CommandType = CommandType.StoredProcedure;
//@ACPT_VOU_NO 宣告其欄位名稱、屬性、長度
cmd.Parameters.Add("@ACPT_VOU_NO", SqlDbType.NVarChar, 20);
//設定由畫面取得的值
cmd.Parameters["@ACPT_VOU_NO"].Value = textBox_sp.Text;
SqlDataAdapter da3 = new SqlDataAdapter(cmd);
da3.Fill(dt);
}
留言列表