ASP.NETÖ´Ðд洢¹ý³Ì£¬²¢»ñÈ¡´æ´¢¹ý³ÌµÄ·µ»ØÖµ

//Á¬½ÓÊý¾Ý¿â
        string myStr = CODE.DbHelperSQL.connectionString;
        SqlConnection myConn = new SqlConnection(myStr);
        myConn.Open();
        //´´½¨SqlCommand¶ÔÏó
        SqlCommand cmd = new SqlCommand("pr_GetSQLWhere", myConn);
        cmd.CommandType = CommandType.StoredProcedure;
        //Ìí¼Ó²ÎÊý
        SqlParameter sUserID = cmd.Parameters.Add("@sUserID", SqlDbType.VarChar,50);
        sUserID.Value ="01";
        SqlParameter sRetSQL = cmd.Parameters.Add("@sRetSQL", SqlDbType.VarChar,50);
        sRetSQL.Direction = ParameterDirection.Output;
        cmd.ExecuteNonQuery();
        string strs = sRetSQL.Value.ToString();
        return strs;