asp.net调用存储过程1

1,传入参数,传出参数

public int GetTeam1Id(string userId)
        {
            int team1ID = -1;
            string strSPName = "PDM.PRODNAME_PHONEINFO_PKG.GET_TEAM1_ID";
            using (OracleConnection dbConnection = new OracleConnection(helper.mConnectionString))
            {
                dbConnection.Open();

                OracleCommand dbCommand = new OracleCommand();
                dbCommand.CommandType = CommandType.StoredProcedure;
                dbCommand.CommandText = strSPName;
                dbCommand.Connection = dbConnection;

                dbCommand.Parameters.Add("PS_USER_ID", userId);
                dbCommand.Parameters.Add("PS_TEAM1_ID", OracleType.Number);
                dbCommand.Parameters["PS_TEAM1_ID"].Direction = ParameterDirection.Output;

                try
                {
                    dbCommand.ExecuteNonQuery();
                    team1ID = int.Parse(dbCommand.Parameters["PS_TEAM1_ID"].Value.ToString());
                }
                catch
                {
                    dbConnection.Close();
                    dbConnection.Dispose();
                }
                if (dbConnection.State == ConnectionState.Open)
                {
                    dbConnection.Close();
                }
                dbConnection.Dispose();
              
            }
            return team1ID;

        }

2,

存储过程的读取一般是
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
SqlCommand cmd;
这是个形式
cmd = new SqlCommand("sp_你的过程", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Type", SqlDbType.Int));
cmd.Parameters["@Type"].Value = 1;
cmd.Parameters.Add(new SqlParameter("@YourName", SqlDbType.NVarChar, 40));
cmd.Parameters["@YourName"].Value = GoodsName.Text.Trim();

GridView1.DataSource = GetDataSet(你的数据库操作,作为显示的源);
GridView1.DataKeyNames = new String[] { "id" };
GridView1.DataBind();
这个是GridView的绑定方法

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。